Ms Office Excel 2007/2010 Intermediate - Pre Test

11 Questions  I  By Naldsauza
Please take the quiz to rate it.

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

  
Changes are done, please start the quiz.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
  • 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

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.