MS Office Excel 2007/2010 Advance - Post Test

10 Questions | Total Attempts: 1252

SettingsSettingsSettings
MS Office Excel 2007/2010 Advance - Post Test - Quiz

Select the best answer


Questions and Answers
  • 1. 
    _______ allows you to save different display and print setting and impose them quickly and easily on the worksheet at any time
    • A. 

      Views

    • B. 

      Scenario Manager

    • C. 

      Solver

    • D. 

      Bookmarks

  • 2. 
    You can ________ data from each separate worksheet into a master worksheet to summarize and report results.
    • A. 

      Concatenate

    • B. 

      Consolidate

    • C. 

      Containing

    • D. 

      Filtering

  • 3. 
    Excel provides some LOOKUP functions which is
    • A. 

      Vector Lookup, V Lookup and W Lookup

    • B. 

      Vector Lookup, H Lookup and Horizontal Lookup

    • C. 

      Vector Lookup, H Lookup and V Lookup

    • D. 

      HectorLookup, VLookup and Vector Lookup

  • 4. 
    Which one is valid Vector Lookup statement?
    • A. 

      =LOOKUP(B13,D3:D11,E3:E11)

    • B. 

      =VLOOKUP(B13,D3:D11,E11)

    • C. 

      =VECTORLOOKUP(B13,D3:D11,E11)

    • D. 

      =VHLOOKUP(B13,D3:D11,E11)

  • 5. 
    What If Analysis contains all below except
    • A. 

      Data Table

    • B. 

      Scenario Manager

    • C. 

      Goal Seek

    • D. 

      Pivot Tables

  • 6. 
    What formula it is {=TABLE(,B4)} ?
    • A. 

      Array for Data Table

    • B. 

      Pivot Table

    • C. 

      Vector Lookup

    • D. 

      Data Validation

  • 7. 
    What is short cut key to make hyperlink?
    • A. 

      Ctrl H

    • B. 

      Ctrl K

    • C. 

      Alt H

    • D. 

      Alt K

  • 8. 
    1 of rules for create range name is can have space between name
    • A. 

      True

    • B. 

      False

  • 9. 
    Where can we find, delete and edit our Range Name and Cell Name?
    • A. 

      Icon Range Manager

    • B. 

      Icon Range Name

    • C. 

      Icon Name Designer

    • D. 

      Icon Name Manager

  • 10. 
    You can create hyperlink to link between 2 workbook, between 2 worksheet or between Excel worksheet and Internet
    • A. 

      False

    • B. 

      True

Back to Top Back to top