Microsoft Excel Pre Evaluation – Advance I

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Tnd_boostson
T
Tnd_boostson
Community Contributor
Quizzes Created: 8 | Total Attempts: 1,435
Questions: 15 | Attempts: 69

SettingsSettingsSettings
Microsoft Excel Pre Evaluation  Advance I - Quiz


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


Questions and Answers
  • 1. 

     

    • A.

      File> Info> Properties.

    • B.

      File > Insert> Properties

    • C.

      Data> Connection> Properties.

    • D.

      Not sure.

    Correct Answer
    A. File> Info> Properties.
    Explanation
    The correct answer is "File > Info > Properties" because this option allows the user to access the properties of a file. By selecting this option, the user can view and modify various details about the file, such as its name, size, creation date, and author. This option is commonly found in file management systems and provides a convenient way to manage and organize files.

    Rate this question:

  • 2. 

     When you convert a workbook in  a compatible mode, the file is ____ . (Apabila menukar workbook ke dalam mod compatible, fail itu akan ______ .)

    • A.

      Replaced the original file

    • B.

      Replaced with a copy

    • C.

      Replaced with a new worksheet

    • D.

      Don't know

    Correct Answer
    B. Replaced with a copy
    Explanation
    When you convert a workbook in a compatible mode, the file is replaced with a copy. This means that the original file remains intact and a new copy of the workbook is created in the compatible mode. This allows you to work on the copy without affecting the original file.

    Rate this question:

  • 3. 

    How to quick identify specific information that meets a given criterion? (Bagaimanakah cara untuk mengenalpasti maklumat tertentu dengan ciri-ciri yang ditetapkan?)

    • A.

      Data Validation

    • B.

      Conditional Customization

    • C.

      Conditional Formatting

    • D.

      Don't know

    Correct Answer
    C. Conditional Formatting
    Explanation
    Conditional formatting is a feature in data analysis tools that allows users to apply specific formatting to cells or ranges based on certain conditions or criteria. By using conditional formatting, users can quickly identify specific information that meets a given criterion by applying different formatting styles, such as highlighting, color-coding, or icon sets, to the cells that meet the specified conditions. This helps users visually identify and analyze data that meets specific criteria without having to manually search or filter through the entire dataset.

    Rate this question:

  • 4. 

     File protection with password is to prevent unauthorized user to _______________ a workbook. (Melindungi fail dengan katakunci adalah untuk mengelak pengguna yang tiada kebenaran untuk __________ workbook.)

    • A.

      Open and modify.

    • B.

      Modify and share.

    • C.

      Share and Consolidate.

    • D.

      Not Sure.

    Correct Answer
    A. Open and modify.
    Explanation
    File protection with a password is implemented to prevent unauthorized users from being able to open and modify a workbook. This means that only those with the correct password will be able to access and make changes to the file, ensuring the security and integrity of the workbook's content.

    Rate this question:

  • 5. 

    Which cannot be sort in Conditional Formatting? (Mana satukah yang tidak boleh disusun dalam Conditional Formatting?)

    • A.

      Cell Icon

    • B.

      Cell Color

    • C.

      Cell Border

    • D.

      Don't know

    Correct Answer
    C. Cell Border
    Explanation
    Cell Border cannot be sorted in Conditional Formatting because it is not a sorting option in the formatting rules. Conditional Formatting allows users to apply formatting to cells based on certain criteria, such as cell value or cell color. However, sorting options like sorting by cell icon, sorting by cell color, and sorting by cell value are available in Conditional Formatting.

    Rate this question:

  • 6. 

     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?)

    • A.

      Data Formatting.

    • B.

      Data Validation.

    • C.

      Data Customizing.

    • D.

      Not Sure.

    Correct Answer
    B. Data Validation.
    Explanation
    Data validation is the technique used for restricting the input value or type of data based on a specific set of criteria. It ensures that the data entered into a system meets the required standards and is valid. This can include checking for correct data types, range limits, and other criteria specified by the system. By implementing data validation, errors and inconsistencies in the data can be minimized, leading to improved data quality and reliability.

    Rate this question:

  • 7. 

    Why it is important to share a workbook through a SharePoint Server instead of sharing through e-mail? (Kenapakah penting untuk berkongsi workbook melalui SharePoint Server daripada melaui emel?)

    • A.

      To avoid multiple copies

    • B.

      To prevent data theft.

    • C.

      To prevent data theft.

    • D.

      Don't know

    Correct Answer
    A. To avoid multiple copies
    Explanation
    Sharing a workbook through a SharePoint Server instead of via email is important to avoid multiple copies. When a workbook is shared through email, multiple recipients may save their own copies of the workbook, leading to multiple versions and potential confusion. By sharing through a SharePoint Server, all users can access and collaborate on the same workbook, ensuring that everyone is working on the most up-to-date version. This helps to streamline communication and prevent the creation of unnecessary duplicate copies of the workbook.

    Rate this question:

  • 8. 

     Which one of these is NOT the way of protecting a file? (Yang mana satukah antara berikut BUKAN cara melindungi fail?)

    • A.

      Restrict to be viewed by everyone

    • B.

      Share in a secure manner.

    • C.

      Modify by only trusted user.

    • D.

      None of above.

    Correct Answer
    D. None of above.
    Explanation
    The correct answer is "None of above." This means that none of the options provided are ways of protecting a file. The options given are "Restrict to be viewed by everyone," "Share in a secure manner," and "Modify by only trusted user," which are all methods of protecting a file. Therefore, the correct answer is that there is no option listed that is not a way of protecting a file.

    Rate this question:

  • 9. 

     What is the main purpose of sharing a protected file? (Apakah tujuan utama berkongsi fail yang dilindungi?)

    • A.

      To view file.

    • B.

      To make changes.

    • C.

      To revise changes.

    • D.

      Not Sure.

    Correct Answer
    B. To make changes.
    Explanation
    The main purpose of sharing a protected file is to allow others to make changes to the file. By sharing a protected file, the owner can grant permission to specific individuals or groups to edit and modify the content of the file. This is useful for collaborative work, where multiple people need to contribute and update the file. Sharing a protected file ensures that only authorized individuals can make changes, maintaining the integrity and security of the file.

    Rate this question:

  • 10. 

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

    • A.

      Picture.

    • B.

      Chart.

    • C.

      Table.

    • D.

      Don't know.

    Correct Answer
    C. Table.
    Explanation
    Tables are not supported in a shared workbook. Shared workbooks in Excel allow multiple users to work on the same workbook simultaneously, but certain features are not compatible with this collaboration feature. Tables, which are used to organize and analyze data in Excel, cannot be used in a shared workbook. This is because tables can have complex formulas and formatting that may cause conflicts or inconsistencies when multiple users are making changes to the workbook. Therefore, tables are not allowed in shared workbooks to ensure data integrity and prevent issues during collaboration.

    Rate this question:

  • 11. 

    How to track any changes made to a workbook? (Bagaimanakah untuk mengenalpasti perubahan yang dibuat  dalam worbook?)

    • A.

      Revision tracking.

    • B.

      Reference tracking.

    • C.

      Review tracking.

    • D.

      Not Sure

    Correct Answer
    A. Revision tracking.
    Explanation
    Revision tracking allows you to keep track of any changes made to a workbook. It allows you to see the history of revisions, including who made the changes and when they were made. This can be useful for collaboration purposes or for auditing purposes. With revision tracking, you can easily identify any modifications made to the workbook and revert back to previous versions if needed.

    Rate this question:

  • 12. 

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

    • A.

      Pound sign (#).

    • B.

      Exclamation sign (!).

    • C.

      Question mark (?).

    • D.

      Not Sure.

    Correct Answer
    A. Pound sign (#).
    Explanation
    All the formula errors will begin with the pound sign (#). This is a common convention in many spreadsheet programs, such as Microsoft Excel, to indicate that there is an error in the formula. When a formula error occurs, the cell containing the formula will display the pound sign (#) followed by an error code, such as #DIV/0! for a division by zero error. This helps users quickly identify and troubleshoot formula errors in their spreadsheets.

    Rate this question:

  • 13. 

    What happens if a document has been “Mark As Final”? (Apakah yang terjadi pada dokumen yang telah di “Mark As Final” kan?)

    • A.

      Replace with a new copy

    • B.

      Cannot be shared

    • C.

      Cannot be edited

    • D.

      Don't know

    Correct Answer
    C. Cannot be edited
    Explanation
    When a document has been "Mark As Final", it means that it cannot be edited. This feature is often used to indicate that the document is final and should not be changed. By marking the document as final, it becomes read-only, preventing any modifications or edits from being made. This helps to ensure the integrity and accuracy of the document's content.

    Rate this question:

  • 14. 

     Which is the correct flow of four collaboration process? (Mana satukah aliran yang benar bagi proses kolaborasi?)

    • A.

      Saving> Protect> Sharing> Reviewing.

    • B.

      Protect> Saving> Sharing> Reviewing.

    • C.

      Reviewing > Sharing> Protect> Saving.

    • D.

      Don't know

    Correct Answer
    B. Protect> Saving> Sharing> Reviewing.
    Explanation
    The correct flow of four collaboration process is Protect> Saving> Sharing> Reviewing. This sequence ensures that the information or data being collaborated on is first protected or secured, then saved or stored, followed by sharing it with the relevant parties, and finally reviewing the collaboration to assess its effectiveness or make necessary improvements.

    Rate this question:

  • 15. 

    Which is NOT to trace cell that help to validate and locate a formula? (Yang manakah BUKAN untuk mengesahkan sel yang mengandungi formula?)

    • A.

      Trace precedent

    • B.

      Trace dependent

    • C.

      Traceresident

    • D.

      Not Sure

    Correct Answer
    C. Traceresident
    Explanation
    The option "Traceresident" is not used to trace cells that help to validate and locate a formula. The correct options are "Trace precedent" and "Trace dependent" which are used to trace the cells that are used by a formula (precedents) or the cells that depend on a formula (dependents). "Traceresident" is not a valid term or function used in Excel for tracing cells.

    Rate this question:

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.