Excel Pivot Table Quiz

What is a Pivot Table used for in Excel?

• Formatting text

• Creating graphs

• Summarizing and analyzing data

• Printing documents

Which tab do you use to insert a Pivot Table?

• Home

• Data

• Insert

• Review

In a Pivot Table, what is the area where you drop fields you want to calculate totals for?

• Rows

• Columns

• Filters

• Values

What is the default function applied to numeric fields in the Values area?

• Count

• Sum

• Average

• Max

Which feature lets you filter Pivot Table data visually?

• Filters

• Charts

• Slicers

• Conditions

Which of the following is a valid calculation type in the 'Show Values As' option?

• % of Grand Total

• % of Row Total

• % of Column Total

• All of the above

What is a Pivot Chart?

• A text format

• A chart connected to a Pivot Table

• A shape tool

• A slicer

Which PivotTable feature allows you to compare values across different fields?

• Grouping

• Conditional Formatting

• Show Values As → Difference From

• Report Filter

How can you consolidate data from multiple worksheets using a Pivot Table?

• By using slicers

• By linking charts

• By selecting 'Use this workbook's data model'

• By copying all data into one sheet

What happens when you insert a slicer in a Pivot Table?

• It applies conditional formatting

• It opens a new window

• It adds a visual filter for easy selection

• It removes all filters