# Ms Office Excel 2007/2010 Intermediate - Pre Test

11 Questions

Enter either True, False or I Dont Know.

• 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

Related Quizzes
Featured Quizzes
Related Topics