Excel Advance 2 Pre Test

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 Naldsauza
N
Naldsauza
Community Contributor
Quizzes Created: 21 | Total Attempts: 16,311
| Attempts: 381
SettingsSettings
Please wait...
  • 1/12 Questions

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

    • True
    • False
    • I Don't Know
Please wait...
About This Quiz

The 'Excel Advance 2 Pre Test' assesses advanced Excel skills, including data sorting, multi-level sorting, use of data filters, logical operations, and pivot table\/chart functionalities. It is designed to evaluate proficiency in Excel for enhancing workplace efficiency.

Excel Advance 2 Pre Test - Quiz

Quiz Preview

  • 2. 

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

    • True

    • False

    • I Don't Know

    Correct Answer
    A. True
    Explanation
    The given answer is true because the IF function is indeed used to test whether certain conditions are true or false. It allows us to perform different actions based on the outcome of the test. If the condition is true, one set of actions is executed, and if the condition is false, another set of actions is executed. Therefore, the IF function is a logical function that helps in decision-making based on the evaluation of conditions.

    Rate this question:

  • 3. 

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

    • Greater than

    • Greater than and equal

    • I Don't Know

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

    Rate this question:

  • 4. 

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

    • Prepared in Excel table layout (Disusun dalam jadual Excel)

    • Prepared in Word table layout (Disusun dalam jadual Word)

    • I Don't Know

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

    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?

    • Executive

    • Non-Executive

    • I Don't Know

    Correct Answer
    A. Non-Executive
    Explanation
    The status shown based on the given criteria is "Non-Executive". This is because the IF function checks if the salary is greater than 3500. Since the salary is 2500, which is not greater than 3500, the function returns the value "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)

    • True

    • False

    • I Don't Know

    Correct Answer
    A. True
    Explanation
    The statement is true because in Pivot, there are indeed two options available: Pivot Table and Pivot Chart. Pivot Table is used to summarize and analyze data in a tabular format, while Pivot Chart is used to visualize data in a graphical format. Therefore, the correct answer is true.

    Rate this question:

  • 7. 

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

    • True

    • False

    • I Don't Know

    Correct Answer
    A. True
    Explanation
    The given statement is true. Data Filter can be found in both the Home and Data Ribbon. This means that users can access the Data Filter feature from either of these two locations in the software interface.

    Rate this question:

  • 8. 

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

    • True

    • False

    • I Don't Know

    Correct Answer
    A. True
    Explanation
    A recorded macro can be assigned to a button, allowing users to easily execute the macro by clicking on the button. This feature is commonly used in software applications to automate repetitive tasks and increase efficiency. By assigning a macro to a button, users can access the functionality of the macro with a single click, saving time and effort.

    Rate this question:

  • 9. 

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

    • True

    • False

    • I Don't Know

    Correct Answer
    A. False
    Explanation
    The statement suggests that using the "

    Rate this question:

  • 10. 

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

    • F11

    • F12

    • I Don't Know

    Correct Answer
    A. F11
    Explanation
    Pressing the F11 key in Excel creates a new chart sheet and moves the selected chart to that new sheet. This shortcut allows users to quickly transfer a chart to a separate sheet for better organization and presentation of data.

    Rate this question:

  • 11. 

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

    • True

    • False

    • I Don't Know

    Correct Answer
    A. False
    Explanation
    The explanation for the correct answer "False" is that performing multi-level sort cannot be done in the Insert Ribbon. The Insert Ribbon is primarily used for inserting various elements such as tables, charts, pictures, etc. It does not have the functionality to perform sorting operations.

    Rate this question:

  • 12. 

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

    • True

    • False

    • I Don't Know

    Correct Answer
    A. False
    Explanation
    The given statement is incorrect. VBA stands for Visual Basic for Applications, not Visual Basic Assignation. VBA is a programming language developed by Microsoft that is used to automate tasks and create applications within other Microsoft Office applications such as Excel, Word, and PowerPoint.

    Rate this question:

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