Excel - Pivot Tables

A ____ is an interactive view of worksheet data.

• PivotChart report

• PivotTable report

• 2-D column chart

• trendline

A ____ report is an interactive chart that allows users to change the groupings that graphically present data.

• SlicerChart

• PivotChart

• TrendChart

• 2-D Column chart

In PivotTables, ____ fields correspond to columns in the original data.

• row

• index

• summary

• category

In a PivotTable, ____ fields correspond to summary values of original data across categories.

• category

• index

• data

• summary

Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.

• organizing

• implementing

• sorting

• filtering

The summary function that calculates the number of data values in a PivotTable report is ____.

• Count

• Product

• Var

• Count Nums

The summary function that calculates the smallest data value in a PivotTable report is ____.

• Varp

• Min

• Max

• Average

PivotTables are always based on a PivotChart.

• True

• False

To add data to a PivotTable, select field check boxes in the PivotTable Fields task pane.

• True

• False

You can change the view of a PivotTable report depending on what you want to analyze.

• True

• False