Take Another Quiz

Quiz 3: Tables And Pivot Tables

8 Questions
Quiz 3: Tables And Pivot Tables

This quiz tests the basics of tables and pivot tables in Excel 2010. This was created primarily for students from Cal Poly Pomona.

Questions and Answers
  • 1. 
    • A. 

      True

    • B. 

      False

  • 2. 
    • A. 

      True

    • B. 

      False

    • C. 

      Only when using Excel 2003 of earlier versions.

  • 3. 
    Creating tables is as easy as highlighting cells that have already been filled in appropriately and then clicking on the insert tab and then clicking on the table button.
    • A. 

      No, highlighting cells disables the ability to create tables.

    • B. 

      Yes, it is that simple, but the highlighted cells must have numerical data.

    • C. 

      No, you go to the home tab and then click on the table button.

    • D. 

      No, creating tables in Excel is horribly complicated.

    • E. 

      Yes, it is that simple, but the highlighted cells should not have blank cells.

  • 4. 
    Once data in a table gets filtered, you cannot unfilter the table nor get the table back to the original settings.
    • A. 

      False, you may change filters up to three times.

    • B. 

      True

    • C. 

      False, you may change filters as many times as you please without limits

    • D. 

      False, tables cannot be filtered.

  • 5. 
    • A. 

      Default Pivot Table Layout

    • B. 

      Classic Pivot Table Layout

    • C. 

      Master Pivot Table Layout

    • D. 

      Operation Geronimo Layout

  • 6. 
    For a table to work properly, the top row should have column headings.
    • A. 

      True

    • B. 

      False, only rows may have headings.

    • C. 

      False

  • 7. 
    Check all that are true.
    • A. 

      The boxes that are checked indicate that the table should filter out that data.

    • B. 

      The boxes that are checked indicate that the table will filter in that data.

    • C. 

      The boxes that are unchecked indicate that the table will filter out that data.

    • D. 

      The boxes that are unchecked indicate that the table will not filter in that data unless values are present.

  • 8. 
    Pivot tables that have been created can easily be turned into graphs or charts by simply highlighting the whole pivot table and choosing a graph or chart that you want to create.
    • A. 

      True

    • B. 

      False, pivot tables do not contain enough information for graphs or charts

    • C. 

      False, only regular tables may be used to create graphs or charts