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