Excel Advance 2 Post Test

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

True

False

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.

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.

2. 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)

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.

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.

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

Greater than

Greater than and equal

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.

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.

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

True

False

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.

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.

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

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

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

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

True

False

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.

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.

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

True

False

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.

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.

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

True

False

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.

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.

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

F11

F12

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.

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.

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

True

False

The statement suggests that using the

Explanation

The statement suggests that using the

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

True

False

The statement "VBA is Visual Basic Assignation" is incorrect. VBA stands for Visual Basic for Applications, not Visual Basic Assignation.

Explanation

The statement "VBA is Visual Basic Assignation" is incorrect. VBA stands for Visual Basic for Applications, not Visual Basic Assignation.

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

True

False

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.

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.