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

Naldsauza

Community Contributor

Quizzes Created: 21 | Total Attempts: 15,505

Questions: 12 | Attempts: 432 | Updated: Mar 22, 2023

Questions

Settings

Create your own Quiz

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

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

Excel Advance 2 Post Test

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

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)

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)