Excel Advance 2 Pre 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,457

Questions: 12 | Attempts: 374 | Updated: Mar 21, 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
- C.
  
  I Don't Know
Correct Answer
A. True

Explanation
The statement is true because sorting can indeed be done in both ascending and descending formats. Sorting is the process of arranging data in a specific order, and this can be done in either ascending order (from smallest to largest) or descending order (from largest to smallest). This allows for easier organization and analysis of data.

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
- C.
  
  I Don't Know
Correct Answer
B. 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:
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
- C.
  
  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:
4.

Logical Operator for > = is (Operator logikal bagi > = adalah)
- A.
  
  Greater than
- B.
  
  Greater than and equal
- C.
  
  I Don't Know
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 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:
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
- C.
  
  I Don't Know
Correct Answer
B. 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)
- A.
  
  True
- B.
  
  False
- C.
  
  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.

To filter unmached data in two columns, you could use <= (Menentukan status data yang tidak sama anda boleh menggunakan <=)
- A.
  
  True
- B.
  
  False
- C.
  
  I Don't Know
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
- C.
  
  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:
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
- C.
  
  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:
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)
- C.
  
  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:
11.

Recorded Macro can be assigned to a button (Macro yang telah siap boleh dihubungkan kepada butang)
- A.
  
  True
- B.
  
  False
- C.
  
  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:
12.

VBA is Visual Basic Assignation (VBA adalah Visual Basic Assignation)
- A.
  
  True
- B.
  
  False
- C.
  
  I Don't Know
Correct Answer
B. 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 +

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

Excel Advance 2 Pre 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 Pre 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)