Excel 5 -Quiz Pivot Tables

What is a Pivot Table used for? * *

Storing data

Summarizing and analyzing data

Formatting data

Protecting worksheets

How do you create a Pivot Table? * *

Insert > Pivot Table

Data > Pivot Table Tools

Home > Table > Pivot Table

File > New Pivot Table

Which of the following is NOT a component of a Pivot Table? * *

Rows

Columns

Filters

Graphs

What is a Pivot Chart? *

A chart that summarizes data from a Pivot Table

A type of static chart

A table that contains graphs

A chart that cannot be modified

How do you change the summary function in a Pivot Table (e.g., from Sum to Average)? *

Right-click a value cell > Summarize Values By

Home > Change Summary

Insert > Modify Table

File > Options > Summary