Excel 2007 Advanced Post Test

15 Questions | Total Attempts: 122

SettingsSettingsSettings
Please wait...
Advanced Excel Quizzes & Trivia

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