Excel Advance 2 Post 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

Naldsauza

Community Contributor

Quizzes Created: 21 | Total Attempts: 16,165

| Attempts: 439

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/12 Questions

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

About This Quiz

This 'Excel Advance 2 Post Test' assesses advanced Excel skills, covering topics like data sorting, multi-level sorting, data filtering, logical operators, and PivotTable functionalities. Ideal for learners aiming to enhance their proficiency in Excel for professional or educational purposes.

2.

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

A. 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)
- True
- 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)
- Greater than
- Greater than and equal
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 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?
- Executive
- Non-Executive
Correct Answer

A. 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)
- True
- 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 <=)
- True
- False
Correct Answer

A. 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)
- F11
- 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)
- True
- 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)
- Prepared in Excel table layout (Disusun dalam jadual Excel)
- 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)
- True
- 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)
- True
- False
Correct Answer

A. 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 (Updated): Mar 22, 2023 +

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

Excel Advance 2 Post Test

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

Quiz Preview

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

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

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

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?

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

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

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

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

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

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

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

Excel Advance 2 Post Test

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

Quiz Preview

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

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

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

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?

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

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

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

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

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

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

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

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