Ms Office Excel 2007/2010 Intermediate - Pre Test

11 Questions  I  By Naldsauza on July 7, 2011
Enter either True, False or I Dont Know.

  

Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  =SUMIF(D4:D10,”>600”) is a formula in Excel 2010. Is it valid or not?
A.
B.
C.
2.  Lookup Function in Excel 2010 are HLOOKUP, VLOOKUP and VECTOR LOOKUP
A.
B.
C.
3.  In Excel 2007/ 2010, there are Financial Fornula to calculate Future Value (FV)
A.
B.
C.
4.  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.
B.
C.
5.  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.
B.
C.
6.  Shortcut key for Print Preview in Excel 2007/2010 is / Kekunci pendek bagi fungsi Print Preview di Excel2007/ 2010 adalah: Control + F3
A.
B.
C.
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.
B.
C.
8.  Symbol $ will be used to create Absolute Reference in Ms Excel / Simbol $ digunakan untuk mencipta Absolute Reference di dalam Ms Excel
A.
B.
C.
9.  Default extension files for Excel 2007/2010 is / Pengakhiran fail Excel 2007/2010 secara lalai adalah: .exls
A.
B.
C.
10.  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.
B.
C.
11.  Formula to create current date and time is / Formula mencipta tarikh dan masa sekarang ialah =DATE(NOW)
A.
B.
C.
Back to top


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz