# Ms Office Excel 2007/2010 Intermediate - Pre Test

11 Questions  I  By Naldsauza
Enter either True, False or I Dont Know.

Changes are done, please start the quiz.

 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 In Excel 2007/ 2010, there are Financial Fornula to calculate Future Value (FV)
 A. True
 B. False
 C. I Dont Know
 3 =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
 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. True
 B. False
 C. I Dont Know
 5 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
 6 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
 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()
 A. True
 B. False
 C. I Dont Know
 8 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
 9 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
 10 Lookup Function in Excel 2010 are HLOOKUP, VLOOKUP and VECTOR LOOKUP
 A. True
 B. False
 C. I Dont Know
 11 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
Take Another Quiz