Excel Advance 2 Pre Test
12 Questions
| Total Attempts: 348
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
A Basic Microsoft excel quiz! Have you just finished your training in Microsoft Excel and are looking to test out your understanding? The practice test below is set to test how well you can use excel effectively. Give it...
Questions: 20 | Attempts: 105475 | Last updated: Jul 27, 2021
-
Sample QuestionA fast way to add up this column of numbers is to click on the cell below the numbers and then:
If you're a student and preparing for a computer exam, then look no further than Tthis quiz. his might be a good practice to test your Microsoft word skills, you might get to learn something that you didn't before. Go and...
Questions: 18 | Attempts: 107227 | Last updated: Jul 21, 2021
-
Sample QuestionYou place the insertion point in the middle of a paragraph and start typing. But the new text deletes existing text. What's the problem and how do you fix it?
Office tools such as MS Word, PowerPoint, Excel, Access, etc are must-have skills for any professional nowadays. Take this Microsoft PowerPoint exam quiz to see how well you know some PowerPoint basics. Content in this quiz was...
Questions: 30 | Attempts: 51664 | Last updated: Oct 17, 2021
-
Sample QuestionWhat is the best way to design the layout for your slides?
Hunter x Hunter Nen Test: What is Your Nen Personality?
Hunter x Hunter Nen Test: What is Your Nen Personality?
Which U.S. City Is Suitable for Your Personality Type? Quiz!
Which U.S. City Is Suitable for Your Personality Type? Quiz!
Back to top