We have sent an email with your new password.


Ms Office Excel 2007/2010 Intermediate - Pre Test

11 Questions  I  By Naldsauza
Ms Office Excel 2007/2010 Intermediate - Pre Test
Enter either True, False or I Dont Know.

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  In Excel 2007/ 2010, there are Financial Fornula to calculate Future Value (FV)
A.
B.
C.
2.  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.
3.  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.
4.  Lookup Function in Excel 2010 are HLOOKUP, VLOOKUP and VECTOR LOOKUP
A.
B.
C.
5.  Default extension files for Excel 2007/2010 is / Pengakhiran fail Excel 2007/2010 secara lalai adalah: .exls
A.
B.
C.
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.
B.
C.
7.  =SUMIF(D4:D10,”>600”) is a formula in Excel 2010. Is it valid or not?
A.
B.
C.
8.  Formula to create current date and time is / Formula mencipta tarikh dan masa sekarang ialah =DATE(NOW)
A.
B.
C.
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.
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.  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

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz