Quiz 3: Tables And Pivot Tables

8 Questions | By Enzanblaze

- +

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.

Tables created through Excel's table feature allow users to filter columns by different values.
- A.
  
  True
- B.
  
  False
2.

Pivot tables allow filtering through different values.
- 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.

Discuss
- 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.

Discuss
- 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.

Which pivot table layout allows dragging fields to the grid in a spreedsheet.
- 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.

Discuss
- 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

Back to top

Related Quizzes

Featured Quizzes