Microsoft Excel 2007 Analysis Trivia Quiz

54 Questions | Total Attempts: 301

SettingsSettingsSettings
Microsoft Excel 2007 Analysis Trivia Quiz - Quiz

Excel 2007 Analysis


Questions and Answers
  • 1. 
    The Insert Function dialog box tells you how to use functions.
    • A. 

      True

    • B. 

      False

  • 2. 
    The function arguments dialog box tells you how to use functions.
    • A. 

      True

    • B. 

      False

  • 3. 
    The ____________________ criteria filter requires that the records displaying begin with the specified text string.
  • 4. 
    In PivotTable terminology, the fields that you summarize are known as ______________ fields.
  • 5. 
    A(n) _______________ is a range of values that spans the vertical axis in a column chart.
  • 6. 
    If you want to use your PivotTable to combine items into groups, which of the following would not be true?
    • A. 

      Items that appear as row labels cannot be grouped

    • B. 

      Items that appear as column labels can be grouped

    • C. 

      If items are dates, they can be grouped automatically using the Grouping dialog box

    • D. 

      If items are numbers, they can be grouped manually using the Ctrl key to select items in a group and then choosing Group from the shortcut menu

  • 7. 
    A field name is also called a(n)  _____________
  • 8. 
    The process of hiding certain records and viewing the ones you want is called ____________ your data.
  • 9. 
    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

  • 10. 
    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

  • 11. 
    With the Last Quarter criteria filter, quarters are defined as, for example_________.
    • A. 

      April, May, June

    • B. 

      March, April, May

    • C. 

      May, June, July

    • D. 

      March, April, May, June, July

  • 12. 
    When you designate a range as a(n) ______, Excel provides the same operations as are available for a structured range of data
    • A. 

      Table

    • B. 

      Catalogue

    • C. 

      Index

    • D. 

      Roster

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

      True

    • B. 

      False

  • 14. 
    The simplest and most convenient way to add a record to a table is to enter the data in the first blank row below the last record.
    • A. 

      True

    • B. 

      False

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

      True

    • B. 

      False

  • 16. 
    You can use a table's sizing handle to add columns or rows to a table
    • A. 

      True

    • B. 

      False

  • 17. 
    A(n)_____________________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.
  • 18. 
    When you are in _________ mode, some keyboard shortcuts will work differently.
  • 19. 
    A chart that combines two or more chart types into a single graph is called a(n) _____________ chart.
  • 20. 
    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

  • 21. 
    Item ______ in the figure indicates the fields you want to summarize.
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      4

  • 22. 
    60%-Accent is an example of a cell _____.
    • A. 

      Size

    • B. 

      Style

    • C. 

      Border color

    • D. 

      Height

  • 23. 
    Removing the contents of a cell is known as ____ a cell.
    • A. 

      Clearing

    • B. 

      Emptying

    • C. 

      Editing

    • D. 

      Deleting

  • 24. 
    The amount of money being loaned is known as the _____.
    • A. 

      Mortgage

    • B. 

      Principal

    • C. 

      Loan amount

    • D. 

      Proposed principal

  • 25. 
    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

Back to Top Back to top