Excel 2007 Advanced Post Test

15 Questions | Total Attempts: 122
SettingsSettingsSettings
Please wait...
Advanced Excel Quizzes & Trivia
More Advanced Excel Quizzes
Advanced Excel Quiz Questions And Answers Advanced Excel Quiz Questions And Answers
CMP 540 Excel Trivia Questions Quiz CMP 540 Excel Trivia Questions Quiz
Could You Pass The MS Excel Assessment Trivia Quiz? Could You Pass The MS Excel Assessment Trivia Quiz?
Featured Quizzes
Which Celebrity Do You Look Like Quiz? Which Celebrity Do You Look Like Quiz?
This Is The Easiest Quiz You'll Take In Your Life! This Is The Easiest Quiz You'll Take In Your Life!
Which Naruto Character Are You Most Like? Which Naruto Character Are You Most Like?
Related Topics
Questions and Answers
  • 1. 
    Once you hide a row, it remains hidden as long as the workbook is active.
    • A. 

      True

    • B. 

      False

  • 2. 
    When a worksheet is printed, the grid lines that surround the cells are printed by default.
    • A. 

      True

    • B. 

      False

  • 3. 
    You can rotate cell contents in Excel so that they appear at any angle or orientation.
    • A. 

      True

    • B. 

      False

  • 4. 
    After you merge a range into a single cell, you can't realign its content.
    • A. 

      True

    • B. 

      False

  • 5. 
    Formatting changes only the appearance of data- it does not affect the data itself.
    • A. 

      True

    • B. 

      False

  • 6. 
    The ____ button is equivalent to using the sum button.
    • A. 

      COUNT

    • B. 

      ADD

    • C. 

      AutoSum

    • D. 

      AddSum

  • 7. 
    Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.
    • A. 

      True

    • B. 

      False

  • 8. 
    After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry
    • A. 

      Shift

    • B. 

      Tab

    • C. 

      Esc

    • D. 

      Alt

  • 9. 
    You use ______ filters to find all objects with a value greater than X or acquired after a certain date
    • A. 

      Custom

    • B. 

      Criteria

    • C. 

      Index

    • D. 

      Pivot

  • 10. 
    You can create at most one Excel table in a worksheet
    • A. 

      True

    • B. 

      False

  • 11. 
    When you clear a filter, all filters in the worksheet are cleared
    • A. 

      True

    • B. 

      False

  • 12. 
    To sort data in an Excel worksheet you can use the ______.
    • A. 

      Sort A to Z and Sort Z to A buttons

    • B. 

      QuickSort Options

    • C. 

      Sort command on the Formulas tab

    • D. 

      Any of the above

  • 13. 
    An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.
    • A. 

      True

    • B. 

      False

  • 14. 
    Put the following five steps in the order in which you would perform them to use the Paste Special function: 1. Select and copy a range 2. Click the Paste button arrow in the Clipboard group 3. Specify exactly what you want to paste 4. Click Paste Special to open the dialog box 5. Select the range where you want to pase the Clipboard contents
    • A. 

      1, 2, 4, 3, 5

    • B. 

      1, 2, 4, 5, 3

    • C. 

      1, 5, 2, 4, 3

    • D. 

      1, 5, 2, 3, 4

  • 15. 
    The Paste Options button allows you to________.
    • A. 

      Keep source formatting

    • B. 

      Copy formatting only

    • C. 

      Copy values only

    • D. 

      All of the above

Back to Top Back to top