Kuiz Microsoft Excel

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 Matover91
M
Matover91
Community Contributor
Quizzes Created: 1 | Total Attempts: 874
| Attempts: 874 | Questions: 20
Please wait...
Question 1 / 20
0 %
0/100
Score 0/100
1. Ikon "Undo" berfungsi …. *

Explanation

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.

Submit
Please wait...
About This Quiz
Kuiz Microsoft Excel - Quiz

The 'Kuiz Microsoft Excel' assesses knowledge of Microsoft Excel, a key electronic spreadsheet software. It covers file formats, interface elements like the Office Button, and basic functions such as saving workbooks. This quiz is ideal for enhancing practical Excel skills.

Personalize your quiz and earn a certificate with your name on it!
2. Untuk memindahkan atau menyalin worksheet, menu yang harus dipilih setelah klik kanan pada tab sheet adalah ….*

Explanation

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.

Submit
3. Ctrl+P adalah shortcut key untuk memunculkan kotak dialog …. *

Explanation

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.

Submit
4. Fungsi dalam Excel yang digunakan mengira jumlah dari sekelompok nilai ialah …. *

Explanation

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.

Submit
5. Microsoft Excel ialah perisian ...................... *

Explanation

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".

Submit
6. Salah satu cara menyimpan wordbook pada excel adalah dengan menggunakan …. *

Explanation

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.

Submit
7. Apakah format file bagi Microsoft Excel? *

Explanation

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.

Submit
8.  Ikon "save", "redo", dan "undo" merupakan bahagian menu dari …. *

Explanation

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.

Submit
9. Fungsi apakah yang akan dapat membahagikan paparan kepada 4 bahagian; *

Explanation

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.

Submit
10. Tombol pengurusan fail dokumen pada Microsof Office Excel berbentuk bulat dengan logo Office di tengahnya disebut .… *

Explanation

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.

Submit
11. Untuk mengubah satuan ukuran di dalam Excel, digunakan perintah …. *

Explanation

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.

Submit
12. Rujukan sel untuk pelbagai sel-sel yang bermula dalam sel B1 dan sehingga ke ruangan sel G dan turun ke baris 10 adalah .... *

Explanation

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.

Submit
13. Jika anda menekan kekunci ............, "cell" menerima apa yang anda taip sebagai kandungannya. *

Explanation

When you press the Enter key, the "cell" receives whatever you have typed as its content.

Submit
14. Seorang pengguna ingin mengeluarkan spreadsheet dari worksheet. Manakah urutan yang betul bagi peristiwa-peristiwa yang akan dilakukannya? *

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.

Submit
15. Berikut adalah kombinasi kekunci yang digunakan untuk kembali ke "cell" A1. *

Explanation

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.

Submit
16.  Berapakah ketetapan "worksheet" bila memulakan Microsoft Excel. *

Explanation

When starting Microsoft Excel, the default number of worksheets that are created is 3.

Submit
17. Berikut ini yang merupakan alamat "cell", yaitu .… *

Explanation

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".

Submit
18. Ruangan pada worksheet yang berbentuk segi empat dan merupakan tempat kumpulan beberapa "cell" disebut …. *

Explanation

A range in a worksheet is a rectangular area that consists of multiple cells. It is used to group and organize related data together.

Submit
19. Manakah komponen berikut yang memaparkan "cell" yang sedang aktif? *

Explanation

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.

Submit
20. Kekunci yang digunakan untuk mengubah maklumat dalam "cell" ialah.... *

Explanation

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.

Submit
View My Results

Quiz Review Timeline (Updated): Mar 21, 2023 +

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 05, 2014
    Quiz Created by
    Matover91
Cancel
  • All
    All (20)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Ikon "Undo" berfungsi …. *
Untuk memindahkan atau menyalin worksheet, menu yang harus dipilih...
Ctrl+P adalah shortcut key untuk memunculkan kotak dialog...
Fungsi dalam Excel yang digunakan mengira jumlah dari sekelompok nilai...
Microsoft Excel ialah perisian ...................... *
Salah satu cara menyimpan wordbook pada excel adalah dengan...
Apakah format file bagi Microsoft Excel? *
 Ikon "save", "redo", dan "undo" merupakan bahagian menu dari...
Fungsi apakah yang akan dapat membahagikan paparan kepada 4...
Tombol pengurusan fail dokumen pada Microsof Office Excel berbentuk...
Untuk mengubah satuan ukuran di dalam Excel, digunakan perintah...
Rujukan sel untuk pelbagai sel-sel yang bermula dalam sel B1 dan...
Jika anda menekan kekunci ............, "cell" menerima apa...
Seorang pengguna ingin mengeluarkan spreadsheet dari worksheet....
Berikut adalah kombinasi kekunci yang digunakan untuk kembali ke...
 Berapakah ketetapan "worksheet" bila memulakan Microsoft...
Berikut ini yang merupakan alamat "cell", yaitu .… *
Ruangan pada worksheet yang berbentuk segi empat dan merupakan tempat...
Manakah komponen berikut yang memaparkan "cell" yang sedang...
Kekunci yang digunakan untuk mengubah maklumat dalam "cell"...
Alert!

Advertisement