MS Office Excel 2007/2010 Intermediate - Pre Test

11 Questions | By Naldsauza | Last updated: Mar 21, 2022 | Total Attempts: 328

Questions

Settings

Create your own Quiz

Enter either True, False or I Dont Know.

Questions and Answers

1.

Default extension files for Excel 2007/2010 is / Pengakhiran fail Excel 2007/2010 secara lalai adalah: .exls
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
2.

Shortcut key for Print Preview in Excel 2007/2010 is / Kekunci pendek bagi fungsi Print Preview di Excel2007/ 2010 adalah: Control + F3
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
3.

One of features that help user make using spreadsheet with quicker and faster is Insert Function utility. Where is the location for Insert Function key? / Dimana letaknya butang Insert Function ? Formula Tab --> within Function Library Group
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
4.

Formula to create current date and time is / Formula mencipta tarikh dan masa sekarang ialah =DATE(NOW)
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
5.

If the number is 364.66667, what is the final number if we use formula =ROUND(cell that contain 364.66667)? / Apakah yang terhasil sekiranya kita menggunakan formula =ROUND(sel yang mengandungi nombor 364.666667)? 364.7
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
6.

What formula to combine several text at several cell into one cell? / Formula apakah yang kita gunakan untuk menyambungkan beberapa perkataan menjadi satu ayat dalam satu sel? =CONSOLIDATE()
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
7.

What is the last column and row for Excel 2007/ 2010? Lajur dan Kolum terakhir di dalam Excel 2007/2010 adalah Ans: Unlimited/ Jawapan : Tiada had
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
8.

=SUMIF(D4:D10,”>600”) is a formula in Excel 2010. Is it valid or not?
- A.
  
  True (Valid)
- B.
  
  False (Not Valid)
- C.
  
  I Dont Know
9.

In Excel 2007/ 2010, there are Financial Fornula to calculate Future Value (FV)
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
10.

Lookup Function in Excel 2010 are HLOOKUP, VLOOKUP and VECTOR LOOKUP
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
11.

Symbol $ will be used to create Absolute Reference in Ms Excel / Simbol $ digunakan untuk mencipta Absolute Reference di dalam Ms Excel
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know