Ms Office Excel 2007/2010 Intermediate - Pre Test
11 Questions
Cancel
-
+
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
Back to top
