Microsoft Excel Post Evaluation – Intermediate
Choose the best answer for each of the following questions. (Pilih jawapan yang terbaik bagi setiap soalan di bawah)
- 1.C$4 is one of the Mixed Reference calculations. On which area that is locked? (C$4 merupakan salah satu dari pengiraan bagi Mixed Reference. Pada bahagian manakah ia dikunci?)
- A.
All
- B.
Column
- C.
Row
- 2.Below are the criteria in giving names in a Range Name except (Dibawah merupakan syarat dalam menamakan Range Name kecuali)
- A.
Starts with alphabet
- B.
Use underscore as a name separator
- C.
Starts with symbols or number
- 3.True or False. Relative Reference is one type of calculations in Microsoft Excel (Betul atau Salah. Relative Reference merupakan salah satu jenis pengiraan dalam Microsoft Excel)
- A.
True
- B.
False
- 4.Which one of these functions is under Database Function category? (Yang mana satukah fungsi dibawah adalah di dalam kategori Fungsi Database?)
- A.
VLookup()
- B.
DSUM()
- C.
Average()
- 5.Template in Excel allows you to (Template di dalam Excel membolehkan anda)
- A.
Save new reuse workbook in your computer
- B.
Do calculations easier
- C.
Have standard report layout
- 6.Choose the best answer. How to calculate summary data from a different worksheet easily? (Pilih jawapan terbaik. Bagaimana untuk mengira kumpulan data dari sheet yang berbeza dengan mudah?)
- A.
SubTotal
- B.
Calculate data across worksheet
- C.
Data Consolidate
- 7.AVERAGEIF () function can be define as (Fungsi Average () boleh diertikan sebagai)
- A.
Total maximum value / total record
- B.
Total sum of a value based on specific criteria/ total record
- C.
Total minimum value / total record
- 8.List down three lookup that can be found in Microsoft Excel (Senaraikan tiga jenis lookup yang boleh ditemui di dalam Microsoft Excel)
- A.
VLOOKUP(), LLOOKUP(), LOOKUP()
- B.
VLOOKUP(),HLOOKUP(),LOOKUP()
- C.
VLOOKUP(),LOOKUP(),MLOOKUP()
- 9.By pressing CTRL G allows you to (Dengan menekan butang CTRL G membenarkan anda)
- A.
Go to Function
- B.
Group object
- C.
Sum Function
- 10.How to create hyperlink between sheets? (Bagaimana mencipta hubungan antara dua sheet berbeza?)
- A.
Insert > Link
- B.
Insert > Hyperlink
- C.
Insert > Text Box
- 11.How to filter data based on specific criteria in an existing table? (Bagaimana untuk menapis data berdasarkan syarat tertentu di dalam jadual?)
- A.
Data > Sort
- B.
Data > Filter
- C.
Data > Sub Total
- 12.True or False. You could use Pie Chart to compare data. (Benar atau Salah. Anda boleh menggunakan Pie Chart untuk membuat perbandingan data)
- A.
True
- B.
False
- 13.Which key to switch between sheets in a workbook? (Apakah kekunci untuk menukar antara sheet didalam workbook?)
- A.
CTRL Home and End
- B.
CTRL Page Up and Page Down
- C.
CTRL Arrow Up and Arrow Down
- 14.True or False. SUM() function and AutoSUM function performs total values in a table (Benar atau Salah. Fungsi SUM() dan AUTOSUM() mengira jumlah nilai di dalam satu jadual)
- A.
True
- B.
False
- 15.By applying Format as Table in an existing table, it allows you to produce (Dengan memilih Format as Table pada jadual, ia membenarkan kita menghasilkan)
- A.
Colour settings and Formatting
- B.
Colour Settings and Summary Calculations
- C.
Colour Settings, Filters and Summary Calculations
Questions: 81 | Attempts: 6318 | Last updated: Jan 8, 2013
-
Sample QuestionAs a newly appointed PHN instructed to organize Barangay Baritan, Which of the following is your initial step in organizing the community for initial action?
Questions: 25 | Attempts: 4309 | Last updated: Jan 9, 2013
-
Sample QuestionWhich statement is more likely the truth?
Questions: 25 | Attempts: 3861 | Last updated: Jun 16, 2021
-
Sample QuestionInvolves the collection, organization and analysis of numerical data
Back to top