Microsoft Excel Pre Evaluation – Intermediate
Choose the best answer for each of the following questions. (Pilih jawapan yang terbaik bagi setiap soalan di bawah)
- 1.Which on these formulas represent locked calculations of a cell? (Yang mana satukah mewakili pengiraan berkunci bagi satu sel?)
- A.
A1 + A2
- B.
A1 / $A$2
- C.
A1 / A$2
- D.
Not Sure
- 2.What function that can be used to calculate total years of service? (Apakah fungsi yang boleh digunakan untuk mengira jumlah tahun bertugas?)
- A.
Date()
- B.
DateDif()
- C.
Year()
- D.
Not Sure
- 3.What function to return True or False? (Apakah fungsi yang boleh menghasilkan nilai Benar atau Salah?)
- A.
And()
- B.
Else()
- C.
If()
- D.
Not Sure
- 4.What function to calculate total Male in a department? (Apakah fungsi untuk mengira jumlah Lelaki dalam satu jabatan?)
- A.
COUNTIF()
- B.
COUNTA()
- C.
COUNTBLANK()
- D.
Not Sure
- 5.What function to sum a value based on 2 different criteria in a table? (Apakah fungsi bagi mengira jumlah berdasarkan 2 syarat yang berbeza dalam jadual?)
- A.
SUMIF()
- B.
SUMIFS()
- C.
SUM()
- D.
Not Sure
- 6.How to create Total sum in Format as Table? (Bagaimana untuk memcipta Total Sum dalam Format as Table?)
- A.
TOTAL SUM
- B.
TOTAL ROW
- C.
TOTAL COLUMN
- D.
Not Sure
- 7.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
- D.
Not Sure
- 8.Which key is used to transfer chart to a new worksheet? (Apakah jenis kekunci untuk memindahkan carta ke muka yang baru?)
- A.
F12
- B.
F10
- C.
F11
- D.
Not Sure
- 9.How to create 2 axes in one chart? (Bagaimana untuk mencipta 2 paksi dalam satu carta?)
- A.
Change bar to line Chart > Double click > Secondary Axis
- B.
Double click on bar chart > Secondary Axis
- C.
Chart Tools Design > Change Chart Type
- D.
Not Sure
- 10.How to create customize data display in chart? (Bagaimana untuk mencipta paparan yang terpilih didalah Carta?)
- A.
Select Data
- B.
Select Data Row
- C.
Save as template
- D.
Not Sure
- 11.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
- D.
Not Sure
- 12.__________ to ease your calculation process (____________ memudahkan proses pengiraan)
- A.
Cell name
- B.
Range name
- C.
Table name
- D.
Not Sure
- 13.AVERAGE () function can be define as (Fungsi Average () boleh diertikan sebagai)
- A.
Total sum of a value / total record
- B.
Total maximum value / total record
- C.
Total minimum value / total record
- D.
Not Sure
- 14.True or False. There are 3 types of Lookup function in Excel (Betul atau salah. Terdapat 3 jenis fungsi Lookup dalam Excel)
- A.
True
- B.
False
- C.
Not sure
- 15.True or False. There are three types of references in Excel. (Betul atau salah. Terdapat tiga cara pengiraan dalam Excel)
- A.
True
- B.
False
- C.
Not sure
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