Microsoft Excel Pre Evaluation – Foundation

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Tnd_boostson
T
Tnd_boostson
Community Contributor
Quizzes Created: 8 | Total Attempts: 1,481
| Attempts: 101
SettingsSettings
Please wait...
  • 1/15 Questions

    How to go to the last cell in Microsoft Excel spreadsheet? (Langkah untuk pergi ke penghujung kertas kerja adalah:)

    • CTRL + Left Arrow
    • CTRL + Right Arrow
    • CTRL + Up Arrow
    • Not Sure
Please wait...
About This Quiz


Choose the best answer for each of the following questions.
(Pilih jawapan yang terbaik bagi setiap soalan di bawah)

Microsoft Excel Pre Evaluation Foundation - Quiz

Quiz Preview

  • 2. 

     How to change the vertical data to horizontal layout? (Bagaimanakah untuk menukar data dalam keadaan menegak kepada mendatar?)

    • Copy> Paste special> Translate

    • Copy> Paste special> Transpose

    • Copy> Paste special> Value

    • Not Sure

    Correct Answer
    A. Copy> Paste special> Transpose
    Explanation
    To change vertical data to a horizontal layout, you can use the "Copy > Paste special > Transpose" function. This will allow you to copy the vertical data and paste it in a horizontal format.

    Rate this question:

  • 3. 

    How to return to cell A1 when you are at the HF1 cell? (Bagaimanakah untuk kembali ke sel A1 apabila anda berada di sel HF1?)

    • Pressing Shift + Home

    • Pressing Ctrl + Home

    • Pressing Alt + Home

    • Not Sure

    Correct Answer
    A. Pressing Ctrl + Home
    Explanation
    Pressing Ctrl + Home is the correct answer because it is a keyboard shortcut in Excel that takes you back to cell A1. By pressing Ctrl + Home, you can quickly navigate to the beginning of the worksheet, regardless of your current location.

    Rate this question:

  • 4. 

     What is the formula that shows to date and current time? (Apakah formula yang digunakan untuk memaparkan tarikh hari ini dan masa sekarang?)

    • =DATE()

    • =TIME()

    • =NOW()

    • Not Sure

    Correct Answer
    A. =NOW()
    Explanation
    The correct answer is =NOW(). The NOW() formula is used to display the current date and time.

    Rate this question:

  • 5. 

    Which key is to open Help window instantly? (Mana satu untuk membuka window Help secara serta merta)

    • Pressing F1

    • Pressing F4

    • Pressing F9

    Correct Answer
    A. Pressing F1
    Explanation
    Pressing the F1 key is the correct answer to open the Help window instantly. The F1 key is a commonly used keyboard shortcut to access the Help function in many software applications and operating systems. By pressing F1, users can quickly access relevant documentation, tutorials, and support resources to assist them in using the software or resolving any issues they may encounter.

    Rate this question:

  • 6. 

    What will happen if you press CTRL S key? (Apakah yang akan terjadi apabila anda menekan kekunci CTRL S?)

    • Search

    • Save

    • Save As

    • Not Sure

    Correct Answer
    A. Save As
    Explanation
    Pressing the CTRL S key combination will trigger the "Save As" function. This allows the user to save the current file or document with a new name or in a different location. It is useful when the user wants to create a copy of the file or save it in a different format or location without overwriting the original version.

    Rate this question:

  • 7. 

    Where to find or to create formula and function? (Dimana untuk mencari atau mencipta formula dan fungsi?)

    • By press Ctrl FX

    • By press Alt FX

    • Press FX Button or Insert Function Button (Behind formula bar)

    • Not sure

    Correct Answer
    A. Press FX Button or Insert Function Button (Behind formula bar)
    Explanation
    To find or create formulas and functions in Microsoft Excel, you can press the FX button or the Insert Function button located behind the formula bar. These buttons allow you to access the function library and choose from a wide range of pre-defined formulas or create your own custom formulas.

    Rate this question:

  • 8. 

     What is the use of Auto Fill? (Apakah kegunaan Auto Fill?)

    • Inserting formula

    • Inserting color into shape.

    • Inserting series of data.

    • Not Sure

    Correct Answer
    A. Inserting series of data.
    Explanation
    The use of Auto Fill is to quickly and easily insert a series of data. This feature allows users to automatically fill cells with a sequence of numbers, dates, or other data patterns, saving time and effort. By selecting a starting value and dragging the fill handle, the series can be extended to multiple cells, automatically incrementing or repeating the pattern.

    Rate this question:

  • 9. 

    What are the term for Home, Insert, Page Layout, Data, Review and View? (Apakah nama istilah bagi Home, Insert, Page layout, Data, Review dan View?)

    • Ribbon

    • Button

    • Icon

    • Not Sure

    Correct Answer
    A. Ribbon
    Explanation
    The correct term for Home, Insert, Page Layout, Data, Review, and View is "Ribbon". The Ribbon refers to the graphical control element in Microsoft Office applications, including Word, Excel, and PowerPoint, that organizes commands into a series of tabs. Each tab corresponds to a specific activity or set of commands, such as formatting text, inserting tables, or reviewing documents. The Ribbon provides a user-friendly interface for accessing various features and functions within the application.

    Rate this question:

  • 10. 

    What is the function of Ctrl + Y ? (Apakah kegunaan Ctrl + Y?)

    • Paste

    • Undo

    • Redo

    • Not Sure

    Correct Answer
    A. Redo
    Explanation
    Ctrl + Y is used to redo an action that has been undone using the Ctrl + Z shortcut. It allows the user to reverse the undo action and restore the previous state or action. This can be useful when the user wants to revert back to a previous version or redo an action that was mistakenly undone.

    Rate this question:

  • 11. 

    Which reference type that changes when formula is copied from one cell on the spreadsheet to another? (Mana satukah jenis rujukan yang berubah apabila formula disalin dari satu sel ke kertas kerja lain?)

    • Relative

    • Absolute

    • Dependent

    • Not Sure

    Correct Answer
    A. Relative
    Explanation
    When a formula is copied from one cell to another on a spreadsheet, the reference type that changes is the relative reference. Relative references adjust their cell references based on their new location, allowing the formula to adapt to its new position. This means that if a formula in cell A1 references cell B1, when it is copied to cell A2, the formula will automatically adjust to reference cell B2.

    Rate this question:

  • 12. 

    How to insert a new spreadsheet in a workbook? (Bagaimana mencipta kertas kerja di dalam buku kerja?)

    • CTRL + F11

    • ALT + F11

    • Shift + F11

    • Don't know.

    Correct Answer
    A. Shift + F11
    Explanation
    To insert a new spreadsheet in a workbook, you can use the shortcut Shift + F11. This shortcut allows you to quickly add a new worksheet to your workbook without having to go through the menu options. By pressing Shift + F11, a new sheet will be inserted before the currently selected sheet in the workbook. This is a handy shortcut for quickly adding new sheets and organizing your data in a workbook.

    Rate this question:

  • 13. 

    What is this area called,  if you want to create a new workbook? (Tips:  File > Ribbon (2010 ver) / Office Button (2007 ver) Berikan istilah khusus bagi kawasan dimana anda boleh mencipta workbook baru.  (Tips:  File > Ribbon (2010 ver) / Office Button (2007 ver)

    • Behind stage View.

    • Backstage View

    • File stage View.

    • Not Sure

    Correct Answer
    A. Backstage View
    Explanation
    The area where you can create a new workbook is called the "Backstage View". This view can be accessed by clicking on the "File" tab in the Ribbon (2010 version) or the Office Button (2007 version).

    Rate this question:

  • 14. 

     How to open Find & Replace window  by shortcut key? (Bagaimanakah untuk membuka window Find & Replace dengan kunci singkatan?)

    • Ctrl + F or Ctrl + H

    • Ctrl + G or Ctrl + R

    • Ctrl + F or Ctrl + R

    • Not Sure

    Correct Answer
    A. Ctrl + F or Ctrl + H
    Explanation
    To open the Find & Replace window using a shortcut key, you can press Ctrl + F or Ctrl + H. This keyboard combination will bring up the Find & Replace dialog box, allowing you to search for specific text and replace it with something else within a document or application.

    Rate this question:

  • 15. 

     Which part in Excel view to display the name or reference of selected cell? (Bahagian manakah untuk mempamerkan nama dan rujukan sel?)

    • Refer Box

    • Name Box

    • Cell Box

    • Not sure

    Correct Answer
    A. Name Box
    Explanation
    The Name Box in Excel is the part of the view that displays the name or reference of the selected cell. It allows users to easily see and edit the name or reference of a cell, making it a useful tool for navigating and managing data in Excel.

    Rate this question:

Quiz Review Timeline (Updated): Dec 8, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Dec 08, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 02, 2013
    Quiz Created by
    Tnd_boostson
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.