Pre Test Excel 2007 And 2010 Intermediate

Questions

Settings

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

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
Correct Answer
A. True
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
Correct Answer
B. False
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
Correct Answer
A. True
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
Correct Answer
B. False
5.

If the number is 364.66667, what is the final number if we use formula =ROUND(cell that contain 364.66667,0)? / Apakah yang terhasil sekiranya kita menggunakan formula =ROUND(sel yang mengandungi nombor 364.666667,0)? Ans/Jawapan ==> 364.7
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
Correct Answer
B. False
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
Correct Answer
B. False
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
Correct Answer
B. False
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
Correct Answer
A. True (Valid)
9.

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

Lookup Function in Excel 2010 are HLOOKUP, VLOOKUP and VECTOR LOOKUP
- A.
  
  True
- B.
  
  False
- C.
  
  I Dont Know
Correct Answer
A. True
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
Correct Answer
A. True

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 15, 2022

Quiz Edited by
ProProfs Editorial Team
Apr 14, 2012

Quiz Created by
Naldsauza

Pre Test Excel 2007 And 2010 Intermediate

Default extension files for Excel 2007/2010 is / Pengakhiran fail Excel 2007/2010 secara lalai adalah: .exls

Shortcut key for Print Preview in Excel 2007/2010 is / Kekunci pendek bagi fungsi Print Preview di Excel2007/ 2010 adalah: Control + F3

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

Formula to create current date and time is / Formula mencipta tarikh dan masa sekarang ialah =DATE(NOW)

If the number is 364.66667, what is the final number if we use formula =ROUND(cell that contain 364.66667,0)? / Apakah yang terhasil sekiranya kita menggunakan formula =ROUND(sel yang mengandungi nombor 364.666667,0)? Ans/Jawapan ==> 364.7

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()

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

=SUMIF(D4:D10,”>600”) is a formula in Excel 2010. Is it valid or not?

In Excel 2007/ 2010, there are Financial Fornula to calculate Future Value (FV)

Lookup Function in Excel 2010 are HLOOKUP, VLOOKUP and VECTOR LOOKUP

Symbol $ will be used to create Absolute Reference in Ms Excel / Simbol $ digunakan untuk mencipta Absolute Reference di dalam Ms Excel