Microsoft Excel Post Evaluation – Advance I

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: 74
SettingsSettings
Please wait...
  • 1/15 Questions

    What technique is used for restricting the input value or type of data based on a specific set of criteria? (Apakah cara untuk menghalang kemasukan data berpandukan kriteria yang tertentu?)

    • Data Formatting.
    • Data Validation.
    • Data Customizing
    • Data Refering
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 Post Evaluation Advance I - Quiz

Quiz Preview

  • 2. 

     How to open a workbook with predefined size and position? (Bagaimanakah hendak membuka workbook yang telah ditentukan saiz dan kedudukannya?)

    • Work area.

    • Workspace.

    • Work-pane.

    • Work environment.

    Correct Answer
    A. Workspace.
    Explanation
    The term "workspace" refers to the area where a user can open and work on multiple documents or files. In the context of opening a workbook with predefined size and position, the workspace would provide the necessary environment or platform to do so. It is the correct answer as it aligns with the concept of creating a designated space for working on the workbook.

    Rate this question:

  • 3. 

     Which is used to summarizing data from several ranges to a single range? (Yang manakah digunakan untuk menyimpulkan data daripada pelbagai julat kepada satu julat sahaja?)

    • Data consolidate

    • Data validation.

    • Data conclude.

    • Data abridge.

    Correct Answer
    A. Data consolidate
    Explanation
    Data consolidation is the process of combining data from multiple ranges or sources into a single range. This is often done to create a summary or overview of the data, making it easier to analyze and interpret. By consolidating the data, you can eliminate duplicates, organize it in a structured manner, and perform calculations or other operations on the consolidated range. This can be particularly useful when working with large datasets or when you need to compare and analyze data from different sources or time periods.

    Rate this question:

  • 4. 

     How to locate a workbook by using a specific properties or information? (Bagaimanakah menjejaki workbook dengan menggunakan maklumat yang tertentu?)

    • Color the border of a worksheet.

    • Color the border of a worksheet.

    • Update a worksheet properties.

    • Update a workbook properties.

    Correct Answer
    A. Update a workbook properties.
    Explanation
    The correct answer is "Update a workbook properties." This option suggests that to locate a workbook, one can update its properties. By updating the properties of a workbook, such as its title, author, or other identifying information, it becomes easier to locate the workbook based on specific criteria or information.

    Rate this question:

  • 5. 

    What is the function of Top/Bottom Rules in Conditional Formatting? (Apakah fungsi Top/Bottom Rules dalam Conditional Formatting?)

    • To search the value in the first and last cell in a range of data.

    • To search the minimum and maximum value in range of data

    • To search the value below the maximum value in a range.

    • To search the cell which contains below the maximum value in a range.

    Correct Answer
    A. To search the minimum and maximum value in range of data
    Explanation
    The function of Top/Bottom Rules in Conditional Formatting is to search for the minimum and maximum value in a range of data. It allows users to easily identify the highest and lowest values in a dataset, making it useful for data analysis and visualization.

    Rate this question:

  • 6. 

    How to apply Conditional Formatting in a table? (Bagaimanakah untuk menghasilkan Conditional Formatting di dalam jadual?)

    • Insert> Styles> Conditional Formatting.

    • Insert > Conditional Formatting.

    • Insert> Table> Conditional Formatting.

    • Home > Conditional Formatting.

    Correct Answer
    A. Home > Conditional Formatting.
    Explanation
    To apply conditional formatting in a table, you need to go to the "Home" tab and click on the "Conditional Formatting" option. This option allows you to specify certain conditions or rules that will determine how the data in the table is formatted. By selecting this option, you can easily apply conditional formatting to highlight specific values, apply color scales, or add data bars to the table based on the specified conditions.

    Rate this question:

  • 7. 

    The Review Tracked Revision is to make sure that any revisions made to a file is correct before the core content is _______. (Review Tracked Revision adalah untuk memastikan sebarang rujukan yang dibuat adalah betul sebelum kandungan di_______. )

    • Review.

    • Change.

    • Share.

    • Protect.

    Correct Answer
    A. Change.
    Explanation
    The Review Tracked Revision is used to ensure that any revisions made to a file are correct before the core content is changed. This means that the purpose of the Review Tracked Revision is to review and verify any changes made to the file, ensuring that they are accurate and appropriate before implementing them.

    Rate this question:

  • 8. 

    File protection has two security options which are password and _____ protection. (Terdapat dua cara melindungi fail iaitu dengan perlindungan katakunci dan   ____.)

    • Workspace

    • Worksheet

    • Workbook

    • Workarea

    Correct Answer
    A. Workbook
    Explanation
    The correct answer is "Workbook" because file protection options typically include the ability to password protect the entire workbook, preventing unauthorized access or modifications to the file. This is different from password protection at the worksheet level, which only restricts access to specific sheets within the workbook.

    Rate this question:

  • 9. 

     All the formula errors will begins with _______ sign. (Semua kesilapan formula dimulakan dengan tanda ______. )

    • Pound sign (#).

    • Exclamation sign (!).

    • Question mark (?).

    • Dollar sign ($).

    Correct Answer
    A. Pound sign (#).
    Explanation
    All formula errors in Excel begin with the pound sign (#). This symbol is used to indicate that there is an error in the formula, such as a reference to a cell that does not exist or a calculation that cannot be performed. When Excel detects this symbol, it alerts the user to the presence of an error and provides suggestions for correcting it.

    Rate this question:

  • 10. 

    Which is NOT  TRUE. Exporting an Excel data in .txt format will saves a workbook as a __________ text. (Yang mana TIDAK BENAR. Mengeksport data Excel dalam format .txt akan menyimpan workbook ke sebagai teks ______ . )

    • Quotation mark.

    • Tab delimited.

    • Comma separated.

    • Dash mark.

    Correct Answer
    A. Dash mark.
    Explanation
    Exporting an Excel data in .txt format will save a workbook as a text file with quotation marks, tab delimited, or comma separated, but not with a dash mark.

    Rate this question:

  • 11. 

    How to lock a sheet with Track changes options active? (Bagaimana untuk mengunci sheet bersama-sama pilihan Track Changes diaktifkan?)

    • Review > Protect and Share workbook

    • Review > Share Workbook

    • Review > Protect Sheet

    • Review > Allow Users to Edit Ranges

    Correct Answer
    A. Review > Protect and Share workbook
    Explanation
    To lock a sheet with Track Changes options active, you need to go to the "Review" tab in the Excel toolbar. From there, you can select the "Protect and Share Workbook" option. This will allow you to protect the workbook and enable the Track Changes feature at the same time. By selecting this option, you can prevent others from making changes to the sheet while still being able to track any revisions made by authorized users.

    Rate this question:

  • 12. 

     Which of these Excel features is NOT supported in a shared workbook? (Yang mana antara berikut TIDAK disokong dalam workbook Excel yang dikongsi? )

    • Deleting worksheet.

    • Merging cells.

    • Freezing cells.

    • Splitting cells.

    Correct Answer
    A. Freezing cells.
    Explanation
    Freezing cells is not supported in a shared workbook. Freezing cells allows users to lock certain rows or columns so that they remain visible while scrolling through a large worksheet. However, in a shared workbook, this feature is not available as it could cause conflicts between multiple users trying to freeze or unfreeze cells simultaneously.

    Rate this question:

  • 13. 

    An Excel document that is “Save to Web” (on Windows Live SkyDrive) will share the _____ through email. (Dokumen Excel yang disimpan kepada “Save to Web” (dalam Windows Live SkyDrive) akan berkongsi ________ di dalam emel.)

    • Path.

    • File.

    • Folder.

    • Reminder.

    Correct Answer
    A. Path.
    Explanation
    When an Excel document is saved to the web using "Save to Web" feature on Windows Live SkyDrive, it will share the path of the document through email. The path refers to the location or address where the document is stored on the web. This allows the recipient of the email to access the document by clicking on the shared path.

    Rate this question:

  • 14. 

     Which element is not supported in a shared workbook? (Apakah elemen yang tidakboleh disokong dalam workbook yang dikongsi?)

    • Picture.

    • Chart.

    • Table.

    • Shape.

    Correct Answer
    A. Table.
    Explanation
    In a shared workbook, all users can make changes simultaneously. However, tables in Excel have special features such as structured referencing and automatic filtering, which can cause conflicts when multiple users are editing the workbook. Therefore, tables are not supported in a shared workbook to prevent any potential issues or data inconsistencies.

    Rate this question:

  • 15. 

     Which is the best describes “contains formula referring to other cells”? (Yang mana penjelasan terbaik bagi “mengandungi formula merujuk kepada sel lain?”)

    • Cell reference.

    • Cell viewer.

    • Cell dependent.

    • Cell precedent.

    Correct Answer
    A. Cell dependent.
    Explanation
    The term "contains formula referring to other cells" suggests that the formula in a cell is dependent on the values or calculations in other cells. Therefore, the best description for this is "Cell dependent."

    Rate this question:

Quiz Review Timeline (Updated): Jul 25, 2023 +

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

  • Current Version
  • Jul 25, 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.