Microsoft Excel Pre Evaluation – Foundation
(22).webp "Microsoft Excel Pre Evaluation Foundation - Quiz")
Choose the best answer for each of the following questions.
(Pilih jawapan yang terbaik bagi setiap soalan di bawah)
- 1.
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)
- A.
Behind stage View.
- B.
Backstage View
- C.
File stage View.
- D.
Not Sure
Correct Answer
B. Backstage ViewExplanation
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:
-
- 2.
What will happen if you press CTRL S key? (Apakah yang akan terjadi apabila anda menekan kekunci CTRL S?)
- A.
Search
- B.
Save
- C.
Save As
- D.
Not Sure
Correct Answer
C. Save AsExplanation
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:
-
- 3.
How to insert a new spreadsheet in a workbook? (Bagaimana mencipta kertas kerja di dalam buku kerja?)
- A.
CTRL + F11
- B.
ALT + F11
- C.
Shift + F11
- D.
Don't know.
Correct Answer
C. Shift + F11Explanation
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:
-
- 4.
How to go to the last cell in Microsoft Excel spreadsheet? (Langkah untuk pergi ke penghujung kertas kerja adalah:)
- A.
CTRL + Left Arrow
- B.
CTRL + Right Arrow
- C.
CTRL + Up Arrow
- D.
Not Sure
Correct Answer
B. CTRL + Right ArrowExplanation
To go to the last cell in Microsoft Excel spreadsheet, you can use the keyboard shortcut CTRL + Right Arrow. This shortcut allows you to quickly navigate to the rightmost cell in the current row.Rate this question:
-
- 5.
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?)
- A.
Ribbon
- B.
Button
- C.
Icon
- D.
Not Sure
Correct Answer
A. RibbonExplanation
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:
-
- 6.
Which part in Excel view to display the name or reference of selected cell? (Bahagian manakah untuk mempamerkan nama dan rujukan sel?)
- A.
Refer Box
- B.
Name Box
- C.
Cell Box
- D.
Not sure
Correct Answer
B. Name BoxExplanation
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:
-
- 7.
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?)
- A.
Pressing Shift + Home
- B.
Pressing Ctrl + Home
- C.
Pressing Alt + Home
- D.
Not Sure
Correct Answer
B. Pressing Ctrl + HomeExplanation
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:
-
- 8.
Which key is to open Help window instantly? (Mana satu untuk membuka window Help secara serta merta)
- A.
Pressing F1
- B.
Pressing F4
- C.
Pressing F9
Correct Answer
A. Pressing F1Explanation
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:
-
- 9.
What is the formula that shows to date and current time? (Apakah formula yang digunakan untuk memaparkan tarikh hari ini dan masa sekarang?)
- A.
=DATE()
- B.
=TIME()
- C.
=NOW()
- D.
Not Sure
Correct Answer
C. =NOW()Explanation
The correct answer is =NOW(). The NOW() formula is used to display the current date and time.Rate this question:
-
- 10.
How to change the vertical data to horizontal layout? (Bagaimanakah untuk menukar data dalam keadaan menegak kepada mendatar?)
- A.
Copy> Paste special> Translate
- B.
Copy> Paste special> Transpose
- C.
Copy> Paste special> Value
- D.
Not Sure
Correct Answer
B. Copy> Paste special> TransposeExplanation
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:
-
- 11.
What is the function of Ctrl + Y ? (Apakah kegunaan Ctrl + Y?)
- A.
Paste
- B.
Undo
- C.
Redo
- D.
Not Sure
Correct Answer
C. RedoExplanation
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:
-
- 12.
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?)
- A.
Relative
- B.
Absolute
- C.
Dependent
- D.
Not Sure
Correct Answer
A. RelativeExplanation
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:
-
- 13.
Where to find or to create formula and function? (Dimana untuk mencari atau mencipta formula dan fungsi?)
- A.
By press Ctrl FX
- B.
By press Alt FX
- C.
Press FX Button or Insert Function Button (Behind formula bar)
- D.
Not sure
Correct Answer
C. 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:
-
- 14.
What is the use of Auto Fill? (Apakah kegunaan Auto Fill?)
- A.
Inserting formula
- B.
Inserting color into shape.
- C.
Inserting series of data.
- D.
Not Sure
Correct Answer
C. 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:
-
- 15.
How to open Find & Replace window by shortcut key? (Bagaimanakah untuk membuka window Find & Replace dengan kunci singkatan?)
- A.
Ctrl + F or Ctrl + H
- B.
Ctrl + G or Ctrl + R
- C.
Ctrl + F or Ctrl + R
- D.
Not Sure
Correct Answer
A. Ctrl + F or Ctrl + HExplanation
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:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Dec 08, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 02, 2013Quiz Created by
Tnd_boostson
Back to top