Kuiz Microsoft Excel
Questions and Answers
- 1.
Microsoft Excel ialah perisian ...................... *
- A.
Grafik
- B.
Pemprosesan Perkataan
- C.
Hamparan Elektronik
- D.
Animasi
Correct Answer
C. Hamparan ElektronikExplanation
Microsoft Excel adalah perisian yang digunakan untuk membuat, mengedit, dan mengorganisir data dalam bentuk hamparan elektronik. Dalam Excel, pengguna dapat membuat dan mengelola daftar, tabel, dan grafik untuk melakukan perhitungan, analisis, dan visualisasi data. Oleh karena itu, jawaban yang tepat adalah "Hamparan Elektronik".Rate this question:
-
- 2.
Apakah format file bagi Microsoft Excel? *
- A.
XLW/XLWX
- B.
XLE/XLEX
- C.
XLF/XLFX
- D.
XLS/XLSX
Correct Answer
D. XLS/XLSXExplanation
The correct answer is XLS/XLSX. Microsoft Excel uses the XLS/XLSX file format for its spreadsheets. XLS is the file extension used for Excel files in earlier versions, while XLSX is the newer file format introduced in Excel 2007. Both formats allow users to store and manipulate data in a structured manner, including formulas, charts, and formatting.Rate this question:
-
- 3.
Tombol pengurusan fail dokumen pada Microsof Office Excel berbentuk bulat dengan logo Office di tengahnya disebut .… *
- A.
Excel Options
- B.
Office Button
- C.
Ribbon
- D.
Tilte Bar
Correct Answer
B. Office ButtonExplanation
The correct answer is Office Button. The Office Button in Microsoft Office Excel is a round button with the logo of Office in the center. It is used for managing file documents in Excel, providing options such as opening, saving, printing, and sharing files. The Office Button is located in the top-left corner of the Excel window and serves as a central hub for accessing various file-related functions.Rate this question:
-
- 4.
Ruangan pada worksheet yang berbentuk segi empat dan merupakan tempat kumpulan beberapa "cell" disebut …. *
- A.
Sheet
- B.
Column
- C.
Range
- D.
Pointer
Correct Answer
C. RangeExplanation
A range in a worksheet is a rectangular area that consists of multiple cells. It is used to group and organize related data together.Rate this question:
-
- 5.
Berikut ini yang merupakan alamat “cell”, yaitu .… *
- A.
84
- B.
3F
- C.
B5
- D.
BB
Correct Answer
A. 84Explanation
The given answer "84" is the correct address for the "cell". This can be inferred from the question prompt which states that the given options are addresses and we need to identify the one that represents a "cell" address. Among the given options, "84" is the only address that can be associated with a "cell".Rate this question:
-
- 6.
Salah satu cara menyimpan wordbook pada excel adalah dengan menggunakan …. *
- A.
Ctrl+B
- B.
Ctrl+P
- C.
Ctrl+C
- D.
Ctrl+S
Correct Answer
D. Ctrl+SExplanation
One way to save a wordbook in Excel is by using Ctrl+S. This keyboard shortcut allows users to quickly save their workbooks without having to navigate through the menu options. By pressing Ctrl+S, the current workbook is saved with any changes made since the last save. This helps to ensure that any progress made is not lost and can be accessed later.Rate this question:
-
- 7.
Ikon “save”, “redo”, dan “undo” merupakan bahagian menu dari …. *
- A.
Ribbon
- B.
Office Button
- C.
Quick Access Toolbar
- D.
Titlebar
Correct Answer
C. Quick Access ToolbarExplanation
The correct answer is Quick Access Toolbar. The question is asking about the menu options "save", "redo", and "undo" in an application. These options are typically found in the Quick Access Toolbar, which is a customizable toolbar located at the top of the application window. It allows users to quickly access frequently used commands without navigating through multiple menus. The Ribbon is a menu interface that contains various tabs and commands, the Office Button is a menu button in older versions of Microsoft Office, and the Titlebar is the topmost bar of an application window that displays the title of the document or program.Rate this question:
-
- 8.
Ctrl+P adalah shortcut key untuk memunculkan kotak dialog …. *
- A.
Customize
- B.
Print
- C.
Heater
- D.
Page setup
Correct Answer
B. PrintExplanation
Ctrl+P adalah shortcut key untuk memunculkan kotak dialog Print. Dengan menekan Ctrl+P, pengguna dapat dengan cepat mengakses opsi pencetakan dan mengatur pengaturan cetak sebelum mencetak dokumen.Rate this question:
-
- 9.
Untuk mengubah satuan ukuran di dalam Excel, digunakan perintah …. *
- A.
Start–Setting–Control Panel–Regional–Currency
- B.
Office Button–Open
- C.
Office Button–Excel Options–Save–Default File Location
- D.
Office Button–Excel Options–Advanced–Display–Ruler Units
Correct Answer
D. Office Button–Excel Options–Advanced–Display–Ruler UnitsExplanation
The correct answer is "Office Button–Excel Options–Advanced–Display–Ruler Units". This option allows the user to change the unit of measurement in Excel, specifically for the ruler units.Rate this question:
-
- 10.
Ikon “Undo” berfungsi …. *
- A.
Mencetak dokumen
- B.
Menyimpan dokumen
- C.
Memotong bahagian dari dokumen
- D.
Membatalkan proses yang telah dijalankan
Correct Answer
D. Membatalkan proses yang telah dijalankanExplanation
The correct answer is "Membatalkan proses yang telah dijalankan" which translates to "Undoing a process that has been executed." This means that the "Undo" function allows the user to reverse or cancel a previous action or operation that has been performed.Rate this question:
-
- 11.
Jika anda menekan kekunci ............, "cell" menerima apa yang anda taip sebagai kandungannya. *
- A.
Enter
- B.
Ctrl + Enter
- C.
Tab
- D.
Insert
Correct Answer
A. EnterExplanation
When you press the Enter key, the "cell" receives whatever you have typed as its content.Rate this question:
-
- 12.
Seorang pengguna ingin mengeluarkan spreadsheet dari worksheet. Manakah urutan yang betul bagi peristiwa-peristiwa yang akan dilakukannya? *
- A.
Pilih: File-Save As – Save As Type – Excel worksheet
- B.
Pilih: Klik kanan pada “spreadsheet tab” dan pilih “DELETE”.
- C.
Pilih: Kilk kanan pada “spreadsheet” dan pilih “ Insert – Entire Column”
- D.
Tiada yang di atas
Correct Answer
B. Pilih: Klik kanan pada “spreadsheet tab” dan pilih “DELETE”.Explanation
The correct answer is to select: Right-click on the "spreadsheet tab" and choose "DELETE". This is the correct sequence of events because the user wants to remove the spreadsheet from the worksheet. By right-clicking on the "spreadsheet tab" and selecting "DELETE", they can easily remove the spreadsheet from the worksheet. The other options mentioned, such as saving the spreadsheet as an Excel worksheet or inserting an entire column, are not relevant to the user's goal of removing the spreadsheet.Rate this question:
-
- 13.
Rujukan sel untuk pelbagai sel-sel yang bermula dalam sel B1 dan sehingga ke ruangan sel G dan turun ke baris 10 adalah .... *
- A.
G1-G10
- B.
B1.G10
- C.
B1;G10
- D.
B1:G10
Correct Answer
D. B1:G10Explanation
The correct answer is B1:G10. This is because the ":" symbol is used in Excel to indicate a range of cells. In this case, it means that the reference starts from cell B1 and goes to cell G10, including all the cells in between.Rate this question:
-
- 14.
Fungsi dalam Excel yang digunakan mengira jumlah dari sekelompok nilai ialah …. *
- A.
SUM
- B.
AVERAGE
- C.
MAX
- D.
MIN
Correct Answer
A. SUMExplanation
The correct answer is SUM. The SUM function in Excel is used to calculate the total sum of a range of values. It adds up all the numbers in the specified range and returns the sum as the result. This function is commonly used when you want to find the total of a group of values in Excel.Rate this question:
-
- 15.
Untuk memindahkan atau menyalin worksheet, menu yang harus dipilih setelah klik kanan pada tab sheet adalah ….*
- A.
Delete
- B.
Rename
- C.
Move or copy
- D.
Paste
Correct Answer
C. Move or copyExplanation
After right-clicking on the worksheet tab, the menu that needs to be selected to move or copy the worksheet is "Move or copy". This option allows the user to either move the worksheet to a different location within the same workbook or copy it to another workbook. This menu option provides the necessary functionality to manage the placement and duplication of worksheets within Excel.Rate this question:
-
- 16.
Manakah komponen berikut yang memaparkan “cell” yang sedang aktif? *
- A.
Name box
- B.
Formula bar
- C.
Menu bar
- D.
Status bar
Correct Answer
A. Name boxExplanation
The name box displays the name or reference of the active cell in a spreadsheet. It is located next to the formula bar and is used to quickly navigate to a specific cell by typing in its address. The name box is an essential component in spreadsheet software as it allows users to easily identify and access the active cell, making data entry and manipulation more efficient.Rate this question:
-
- 17.
Berapakah ketetapan “worksheet” bila memulakan Microsoft Excel. *
- A.
2
- B.
3
- C.
4
- D.
5
Correct Answer
B. 3Explanation
When starting Microsoft Excel, the default number of worksheets that are created is 3.Rate this question:
-
- 18.
Fungsi apakah yang akan dapat membahagikan paparan kepada 4 bahagian; *
- A.
Split
- B.
Hide
- C.
Zoom
- D.
Gridlines
Correct Answer
A. SplitExplanation
The correct answer is "Split." This function allows the user to divide the display into four sections, allowing for easier organization and comparison of information. By splitting the screen, users can view multiple sections simultaneously, which can be particularly useful when working with large amounts of data or when comparing different sets of information.Rate this question:
-
- 19.
Kekunci yang digunakan untuk mengubah maklumat dalam “cell” ialah.... *
- A.
F1
- B.
F2
- C.
F3
- D.
F4
Correct Answer
B. F2Explanation
The correct answer is F2. F2 is the key used to edit information in a cell. When you press F2, you can directly edit the content of the selected cell in programs like Microsoft Excel. It allows you to make changes or corrections to the data without having to delete and retype the entire content of the cell.Rate this question:
-
- 20.
Berikut adalah kombinasi kekunci yang digunakan untuk kembali ke “cell” A1. *
- A.
PageUp (PgUp)
- B.
Alt + PageUp
- C.
Ctrl + Home
- D.
Ctrl + Left Arrow
Correct Answer
C. Ctrl + HomeExplanation
The combination of Ctrl + Home is used to return to cell A1. This key combination is commonly used in spreadsheet programs such as Microsoft Excel. Ctrl + Home is a shortcut that allows users to quickly navigate to the top-left cell of the active worksheet. It is useful when working with large datasets or when you want to quickly return to the starting point of your spreadsheet.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
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 05, 2014Quiz Created by
Matover91
Back to top