MS Office Excel 2007/2010 Advance - Pre Test

10 Questions | Total Attempts: 819

SettingsSettingsSettings
Please wait...
MS Office Excel 2007/2010 Advance - Pre Test

Select either True, False or I Don't Know


Questions and Answers
  • 1. 
    Excel provides some LOOKUP functions which is Vector Lookup, H Lookup, V Lookup
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 2. 
    Is it formula is valid for Vector Lookup? =LOOKUP(B13,D3:D11,E11)
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 3. 
    View allows you to save different display and print setting and impose them quickly and easily on the worksheet at any time
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 4. 
    You can consolidate data from each separate worksheet into a master worksheet to summarize and report result
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 5. 
    Data Validation can help us to uniform data and at the same time control human error by using warning created by you.
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 6. 
    What If Analysis contain several method to help us make decisions such as Solver, Data Tables and Conditional Formatting
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 7. 
    You can create hypelink within Excel spreadsheet and Excel workbook by pressing Ctrl+H
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 8. 
    Cell name and Range name can be create by rules of Using AplhaNumeric, Cannot contain space and can use symbol "_" only.
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 9. 
    You can create Pivot table either within same data source worksheet or new worksheet.
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

  • 10. 
    We can  find a Name Manager Dialog Box in Excel at Formula Tab.
    • A. 

      True

    • B. 

      False

    • C. 

      I Dont Know

Back to Top Back to top