Excel Advance 2 Pre Test

12 Questions | By Naldsauza | Last updated: May 23, 2019 | Total Attempts: 345

Questions

Settings

Answer all question

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

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

VBA is Visual Basic Assignation (VBA adalah Visual Basic Assignation)
- A.
  
  True
- B.
  
  False
- C.
  
  I Don't Know