Microsoft Excel Pre Evaluation – Foundation

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

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.

What is this area called, if you want to create a new workbook? (Tips: File > Ribbon (2010 ver) / Office Button (2007 ver) Berikan istilah khusus bagi kawasan dimana anda boleh mencipta workbook baru. (Tips: File > Ribbon (2010 ver) / Office Button (2007 ver)
- A.
  
  Behind stage View.
- B.
  
  Backstage View
- C.
  
  File stage View.
- D.
  
  Not Sure
2.

What will happen if you press CTRL S key? (Apakah yang akan terjadi apabila anda menekan kekunci CTRL S?)
- A.
  
  Search
- B.
  
  Save
- C.
  
  Save As
- D.
  
  Not Sure
3.

How to insert a new spreadsheet in a workbook? (Bagaimana mencipta kertas kerja di dalam buku kerja?)
- A.
  
  CTRL + F11
- B.
  
  ALT + F11
- C.
  
  Shift + F11
- D.
  
  Don't know.
4.

How to go to the last cell in Microsoft Excel spreadsheet? (Langkah untuk pergi ke penghujung kertas kerja adalah:)
- A.
  
  CTRL + Left Arrow
- B.
  
  CTRL + Right Arrow
- C.
  
  CTRL + Up Arrow
- D.
  
  Not Sure
5.

What are the term for Home, Insert, Page Layout, Data, Review and View? (Apakah nama istilah bagi Home, Insert, Page layout, Data, Review dan View?)
- A.
  
  Ribbon
- B.
  
  Button
- C.
  
  Icon
- D.
  
  Not Sure
6.

Which part in Excel view to display the name or reference of selected cell? (Bahagian manakah untuk mempamerkan nama dan rujukan sel?)
- A.
  
  Refer Box
- B.
  
  Name Box
- C.
  
  Cell Box
- D.
  
  Not sure
7.

How to return to cell A1 when you are at the HF1 cell? (Bagaimanakah untuk kembali ke sel A1 apabila anda berada di sel HF1?)
- A.
  
  Pressing Shift + Home
- B.
  
  Pressing Ctrl + Home
- C.
  
  Pressing Alt + Home
- D.
  
  Not Sure
8.

Which key is to open Help window instantly? (Mana satu untuk membuka window Help secara serta merta)
- A.
  
  Pressing F1
- B.
  
  Pressing F4
- C.
  
  Pressing F9
9.

What is the formula that shows to date and current time? (Apakah formula yang digunakan untuk memaparkan tarikh hari ini dan masa sekarang?)
- A.
  
  =DATE()
- B.
  
  =TIME()
- C.
  
  =NOW()
- D.
  
  Not Sure
10.

How to change the vertical data to horizontal layout? (Bagaimanakah untuk menukar data dalam keadaan menegak kepada mendatar?)
- A.
  
  Copy> Paste special> Translate
- B.
  
  Copy> Paste special> Transpose
- C.
  
  Copy> Paste special> Value
- D.
  
  Not Sure
11.

What is the function of Ctrl + Y ? (Apakah kegunaan Ctrl + Y?)
- A.
  
  Paste
- B.
  
  Undo
- C.
  
  Redo
- D.
  
  Not Sure
12.

Which reference type that changes when formula is copied from one cell on the spreadsheet to another? (Mana satukah jenis rujukan yang berubah apabila formula disalin dari satu sel ke kertas kerja lain?)
- A.
  
  Relative
- B.
  
  Absolute
- C.
  
  Dependent
- D.
  
  Not Sure
13.

Where to find or to create formula and function? (Dimana untuk mencari atau mencipta formula dan fungsi?)
- A.
  
  By press Ctrl FX
- B.
  
  By press Alt FX
- C.
  
  Press FX Button or Insert Function Button (Behind formula bar)
- D.
  
  Not sure
14.

What is the use of Auto Fill? (Apakah kegunaan Auto Fill?)
- A.
  
  Inserting formula
- B.
  
  Inserting color into shape.
- C.
  
  Inserting series of data.
- D.
  
  Not Sure
15.

How to open Find & Replace window by shortcut key? (Bagaimanakah untuk membuka window Find & Replace dengan kunci singkatan?)
- A.
  
  Ctrl + F or Ctrl + H
- B.
  
  Ctrl + G or Ctrl + R
- C.
  
  Ctrl + F or Ctrl + R
- D.
  
  Not Sure