Excel Chp 4 - Textbook

Field section

A window that lists at the top, all of the fields—column titles—from the source data for use in the PivotTable and at the bottom, an area in which you can arrange the fields in the PivotTable.

PivotTable Fields pane

A window that lists at the top, all of the fields—column titles—from the source data for use in the PivotTable and at the bottom, an area in which you can arrange the fields in the PivotTable.

field buttons

A button on a PivotChart with an arrow to choose a filter and thus change the data that is displayed in the chart.

Filtering buttons

A button on a slicer used to select the item by which to filter.

PivotChart

A graphical representation of the data in a PivotTable report.

Slicers

Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data.

field names

The column titles from source data that form the categories of data for a PivotTable.

source data

The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source.

list

A series of rows that contains related data with column titles in the first row.

PivotTable

An interactive Excel report that summarizes and analyzes large amounts of data.