Chapter 4 Key terms
Field section
The upper portion of the PivotTable Fields pane containing the fields—column titles—from your source data; use this area to add fields to and remove fields from the PivotTable.
Filter
To limit the display of data to only specific information
Refresh
the command to update a pivotTable to reflect the new data
Source data
the data for a PivotTable, formatted in columns and rows , which can be located in an excel worksheet or an external source.
Field button
A button on a PivotChart with an arrow to choose a filter and thus change the data that is displayed in the chart.
Filtering button
A button on a slicer used to select the item by which to filter.
Clear Filter
A button that removes a filter.
Pivot Chart
A graphical representation of data in a pivotTable report
Data Model
A method of incorporating data from multiple, related tables into an Excel worksheet.
List
A series of rows that contains related data with column titles in the first row.
Field
A single piece of information for every record.
Pivot Table Fields pane
A window that lists at the top, all of the fields, column titles, from the source of data for use in the Pivot Table and at the bottom, an area in which you can arrange the fields in the pivot Table
Record
All of the categories of data pertaining to one person, place, event, thing, or idea
Filters area
An area in the lower portion of the PivotTable Fields pane to position fields by which you want to filter the PivotTable report, enabling you to display a subset of data in the PivotTable report
Values area
An area to position fields that contain data that is summarized in a pivotTable in a pivotTable report.
Columns area
An area to position fields that you want to display as columns in the PivotTable report. Field names placed here become column titles, and the data is grouped in columns by these titles.
Relationship
An association between tables that share common field
PivotTable
An interactive excel report that summarizes and analyzes large amounts of data
Field names
The column titles from source data that form the categories of data for a PivotTable.
Primary Key
The field used to uniquely identify a record in an access table
Layout section
The lower portion of the PivotTable Fields pane containing the four areas for layout; use this area to rearrange and reposition fields in the PivotTable.
Slicer Header
The top of a slicer that indicates the category of the slicer items
Slicer
The top of the slicer that indicates the category of the slicer items.
Row
an area to position fields that you want to display rows in the pivot table report. Field names placed here become row titles, and the data is grouped.
Associated PivotTable
report The PivotTable report in a workbook that is graphically represented in a PivotChart.