Excel Advance 2 Post Test

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 Naldsauza
N
Naldsauza
Community Contributor
Quizzes Created: 21 | Total Attempts: 15,606
Questions: 12 | Attempts: 432

SettingsSettingsSettings
Microsoft Excel Quizzes & Trivia

Answer all question


Questions and Answers
  • 1. 

    Sorting can be done in Ascending and Descending format (Susunan data boleh dibuat dalam turutan menaik dan menurun)

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The statement is true because sorting can indeed be done in both ascending and descending formats. When sorting in ascending order, the data is arranged from the smallest value to the largest value. On the other hand, when sorting in descending order, the data is arranged from the largest value to the smallest value. Therefore, the statement is correct.

    Rate this question:

  • 2. 

    Performing multi-level sort can be done in Insert Ribbon (Susunatur dalam pilihan pelbagai boleh diperoleh dari ribbon Insert)

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement is false because performing multi-level sort cannot be done in the Insert Ribbon. The Insert Ribbon is primarily used for adding or inserting various elements such as tables, pictures, charts, etc. into a document or presentation. Sorting data, especially in multiple levels, is typically done through the Data or Home Ribbon in most software applications.

    Rate this question:

  • 3. 

    Data Filter can be found in Home and Data Ribbon (Data Filter boleh di perolehi di ribbon Home dan Data)

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the Data Filter can indeed be found in both the Home and Data Ribbons. This means that users can access the Data Filter feature from either of these ribbons, providing them with flexibility in navigating and filtering data in their documents.

    Rate this question:

  • 4. 

    Logical Operator for > = is (Operator logikal bagi > = adalah)

    • A.

      Greater than

    • B.

      Greater than and equal

    Correct Answer
    B. Greater than and equal
    Explanation
    The correct answer is "Greater than and equal." The logical operator for ">=" is used to compare two values and determine if the left value is greater than or equal to the right value. This operator returns true if the left value is greater than or equal to the right value, and false otherwise.

    Rate this question:

  • 5. 

    IF(Salary > 3500, “Executive”, “Non-Executive”) – If Salary is RM 2500, what is the status shown based on the above criteria? (IF(Salary > 3500, “Executive”, “Non-Executive”) – Jika Salary is RM 2500, apakah status yang akan terhasil berdasarkan syarat diatas?

    • A.

      Executive

    • B.

      Non-Executive

    Correct Answer
    B. Non-Executive
    Explanation
    Based on the given criteria, if the salary is greater than 3500, the status shown would be "Executive". However, since the salary is RM 2500, which is less than 3500, the status shown would be "Non-Executive".

    Rate this question:

  • 6. 

    There​ are two options in Pivot – Pivot Table and Pivot Chart (Terdapat dua pilihan di Pivot – Pivot Table dan Pivot Chart)

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that in Pivot, there are indeed two options available - Pivot Table and Pivot Chart. This means that users can choose to create either a Pivot Table or a Pivot Chart depending on their data analysis needs.

    Rate this question:

  • 7. 

    To filter unmached data in two columns, you could use <= (Menentukan status data yang tidak sama anda boleh menggunakan <=)

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement suggests that using the

    Rate this question:

  • 8. 

    Shortcut key to transfer chart to a new spreadsheet is (Kekunci bagi meletakkan carta ke sheet yang baru adalah)

    • A.

      F11

    • B.

      F12

    Correct Answer
    A. F11
    Explanation
    Pressing the F11 key is the shortcut to transfer a chart to a new spreadsheet. This means that when you have a chart selected in Excel, pressing F11 will automatically create a new sheet and move the chart to that sheet. This can be a convenient way to organize and separate charts from the rest of your data in Excel.

    Rate this question:

  • 9. 

    IF function is to test certain conditions is TRUE or FALSE (Fungsi IF merupakan fungsi logikal samana ia BENAR atau TIDAK BENAR)

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The explanation for the given correct answer is that the IF function is indeed used to test certain conditions and determine if they are true or false. It allows for conditional execution of different actions based on the evaluation of the condition.

    Rate this question:

  • 10. 

    You could summarize an existing report to a Pivot Table if data (Anda boleh meringkaskan laporan ke Pivot Table jika data)

    • A.

      Prepared in Excel table layout (Disusun dalam jadual Excel)

    • B.

      Prepared in Word table layout (Disusun dalam jadual Word)

    Correct Answer
    A. Prepared in Excel table layout (Disusun dalam jadual Excel)
    Explanation
    The correct answer is "Prepared in Excel table layout" because a Pivot Table is a feature in Excel that allows users to summarize and analyze large amounts of data. It is specifically designed to work with data organized in an Excel table layout. Therefore, if the data is prepared in an Excel table layout, it can be easily summarized using a Pivot Table. On the other hand, if the data is prepared in a Word table layout, it cannot be directly summarized using a Pivot Table.

    Rate this question:

  • 11. 

    Recorded Macro can be assigned to a button (Macro yang telah siap boleh dihubungkan kepada butang)

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    A recorded macro is a set of actions that are recorded and saved in a computer program. It allows users to automate repetitive tasks by replaying the recorded actions. Assigning a recorded macro to a button means that when the button is clicked, the recorded macro will be executed, performing the actions that were recorded. Therefore, the statement "Recorded Macro can be assigned to a button" is true.

    Rate this question:

  • 12. 

    VBA is Visual Basic Assignation (VBA adalah Visual Basic Assignation)

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement "VBA is Visual Basic Assignation" is incorrect. VBA stands for Visual Basic for Applications, not Visual Basic Assignation.

    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 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 13, 2012
    Quiz Created by
    Naldsauza
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.