Microsoft Excel Post Evaluation – Intermediate

15 Questions | By Tnd_boostson | Last updated: Mar 22, 2022 | Total Attempts: 381

Questions

Settings

Create your own Quiz

Choose the best answer for each of the following questions. (Pilih jawapan yang terbaik bagi setiap soalan di bawah)

Questions and Answers

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

Related Topics

More Evaluation Quizzes

Chn Rle Evaluation Exam

5IMPORTANT INSTRUCTIONS Read the questions carefully. You are given 60 minutes to finish the test and this includes one essay question. Enter your COMPLETE REAL NAME for scoring purposes. DO NOT use a pseudonym, a nickname or...

Questions: 81 | Attempts: 27651 | Last updated: Mar 22, 2022

Sample Question
As a newly appointed PHN instructed to organize Barangay Baritan, Which of the following is your initial step in organizing the community for initial action?

Study the Barangay Health statistics and records

Make a courtesy call to the Barangay Captain

Meet with the Barangay Captain to make plans

Make a courtesy call to the Municipal Mayor

None of the above

Spying For Lying's Human Lie Detector Certification Evaluation Test

Testing your abilities to examining behavioral clues in the context of nonverbal communication and behavioral psychology. Emotions, body language & gestures, and deception are all tested.To receive a certificate you must...

Questions: 25 | Attempts: 4400 | Last updated: Mar 22, 2022

Sample Question
Which statement is more likely the truth?

I did not do it.

I didn't do it.

Program Evaluation Final

Questions: 55 | Attempts: 3106 | Last updated: Mar 22, 2022

Sample Question
The ultimate purpose of program evaluation is

The collection of data on the number of people who utilize a service.

The improvement of programs and the selection of the best program among possible programs

Making decisions about the proper groups a program should serve.

An assessment of how program staff people spend their time.