Pre Test Excel 2007 and 2010 Intermediate

1. In Excel 2007/ 2010, there are Financial Fornula to calculate Future Value (FV)

True

False

I Dont Know

2. Symbol $ will be used to create Absolute Reference in Ms Excel / Simbol $ digunakan untuk mencipta Absolute Reference di dalam Ms Excel

True

False

I Dont Know

3. Default extension files for Excel 2007/2010 is / Pengakhiran fail Excel 2007/2010 secara lalai adalah: .exls

True

False

I Dont Know

4. =SUMIF(D4:D10,">600") is a formula in Excel 2010. Is it valid or not?

True (Valid)

False (Not Valid)

I Dont Know

5. 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

True

False

I Dont Know

6. 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

True

False

I Dont Know

7. Shortcut key for Print Preview in Excel 2007/2010 is / Kekunci pendek bagi fungsi Print Preview di Excel2007/ 2010 adalah: Control + F3

True

False

I Dont Know

8. Lookup Function in Excel 2010 are HLOOKUP, VLOOKUP and VECTOR LOOKUP

True

False

I Dont Know

9. Formula to create current date and time is / Formula mencipta tarikh dan masa sekarang ialah =DATE(NOW)

True

False

I Dont Know

10. If the number is 364.66667, what is the final number if we use formula =ROUND(cell that contain 364.66667,0)? / Apakah yang terhasil sekiranya kita menggunakan formula =ROUND(sel yang mengandungi nombor 364.666667,0)? Ans/Jawapan ==> 364.7

True

False

I Dont Know

11. 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()

True

False

I Dont Know

Pre Test Excel 2007 and 2010 Intermediate

1. In Excel 2007/ 2010, there are Financial Fornula to calculate Future Value (FV)

2.

What first name or nickname would you like us to use?

2. Symbol $ will be used to create Absolute Reference in Ms Excel / Simbol $ digunakan untuk mencipta Absolute Reference di dalam Ms Excel

3. Default extension files for Excel 2007/2010 is / Pengakhiran fail Excel 2007/2010 secara lalai adalah: .exls

4. =SUMIF(D4:D10,">600") is a formula in Excel 2010. Is it valid or not?

5. 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

6. 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

7. Shortcut key for Print Preview in Excel 2007/2010 is / Kekunci pendek bagi fungsi Print Preview di Excel2007/ 2010 adalah: Control + F3

8. Lookup Function in Excel 2010 are HLOOKUP, VLOOKUP and VECTOR LOOKUP

9. Formula to create current date and time is / Formula mencipta tarikh dan masa sekarang ialah =DATE(NOW)

10. If the number is 364.66667, what is the final number if we use formula =ROUND(cell that contain 364.66667,0)? / Apakah yang terhasil sekiranya kita menggunakan formula =ROUND(sel yang mengandungi nombor 364.666667,0)? Ans/Jawapan ==> 364.7

11. 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()