Excel Unit L

Question 1

Feature lets you summarize large amounts of columnar worksheet data in a compact table format.

Answer 1

PivotTable Report

Question 2

The data columns represent categories of data.

Answer 2

Fields

Question 3

After you create the PivotTable you do what by adding fields to ares in the PivotTable.

Answer 3

Populate

Question 4

Controls what calculation excel uses to summarize the table data.

Answer 4

Summary Function

Question 5

Is a graphic object with a set of buttons that let you easily filter PivotTable data to show only the data you need.

Answer 5

Slicer

Question 6

You can filter a PivotTable by using a, which lets you filter PivotTable data using a list arrow to show data for one or more field values.

Answer 6

Report Filter

Question 7

The data you used to create the PivotTable however the values and results in the PivotTable are read-only values.

Answer 7

Data Source

Question 8

To change PivotTable data you must edit the items directly in the data source then update.

Answer 8

Refresh

Question 9

Is a chart that you create from data or from a PivotTable report.

Answer 9

PivotChart Report