MS Office Excel 2007/2010 Intermediate - Post Test

13 Questions

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Find the best answer


Questions and Answers
  • 1. 
    Default extension files for Excel 2007/2010 is
    • A. 

      Docx

    • B. 

      Pptx

    • C. 

      Exls

    • D. 

      Xlsx

  • 2. 
    Shortcut key for Print Preview in Excel 2010 is
    • A. 

      Ctrl + F2

    • B. 

      Alt + F2

    • C. 

      Shift + F2

    • D. 

      Ctrl + Alt + F2

  • 3. 
    • A. 

      Formula Tab --> within Function Library group

    • B. 

      Formula Tab --> within Defined Named group

    • C. 

      Insert Tab --> within Function Library Group

    • D. 

      Insert Tab --> within Defined Named group

  • 4. 
    Formula to create current date and time is
    • A. 

      =DATE(NOW)

    • B. 

      =DAY(NOW)

    • C. 

      =NOW()

    • D. 

      =(DATE)

  • 5. 
    If the number is 364.66667, what is the final number if we use formula =ROUND(cell that contain 364.66667,0)?
    • A. 

      365

    • B. 

      364.7

    • C. 

      364

    • D. 

      364.6

  • 6. 
    What formula to combine several text at several cell into one cell?
    • A. 

      =CONSOLIDATE()

    • B. 

      =CONCATENATE()

    • C. 

      =TRIM()

    • D. 

      =MID()

  • 7. 
    WHAT IS THE LAST COLUMN AND ROW FOR EXCEL 2007/2010?
    • A. 

      IV, 65536

    • B. 

      XFD, 1048576

    • C. 

      Unlimited

    • D. 

      ZZZ, 999999

  • 8. 
    Which formula is false in Excel 2007/2010?
    • A. 

      =SUMIF(D4:D10,">600")

    • B. 

      =ROUNDUP(C2/C3,1)

    • C. 

      =IF(AVERAGE(B3:B6)>25,SUM(B3:B6),0)

    • D. 

      =LEFTS(D4)

  • 9. 
    What symbol represent absolute reference in Ms Excel?
    • A. 

      $

    • B. 

      &

    • C. 

      %

    • D. 

      #

  • 10. 
    There are pivot graph and pivot table to present large data in real time in excel 2007/2010.
    • A. 

      True

    • B. 

      False

  • 11. 
    What result for the following formula? =if(c2>500,"good","not good") where value in c2=500
    • A. 

      Not good

    • B. 

      Good

    • C. 

      Not valid

    • D. 

      No result appear

  • 12. 
    Formula's that can find any value related with finance are
    • A. 

      SUM(), LEFT(), DSUM()

    • B. 

      FV(), CONCATENATE(), NOW()

    • C. 

      FV(), NPV(), PV()

    • D. 

      DAY(), Now(), Today()

  • 13. 
    What exactly year 2001! means in excel 2007/2010?
    • A. 

      Absolute reference

    • B. 

      Name of worksheet

    • C. 

      Name of cell reference

    • D. 

      One of function in math and trig