# 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.
| By Naldsauza
N
Naldsauza
Community Contributor
Quizzes Created: 21 | Total Attempts: 15,656
Questions: 12 | Attempts: 376

Settings

• 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

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

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

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

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

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

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

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

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

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

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

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

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

Related Topics