Excel Chapter 7 vocab
The column titles from source data that form categories of data for a PivotTable.
Field names
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.
Field section
A process by which you can limit the display of data to only specific information.
Filter
A window that lists the fields from the source data and an area in which you can arrange the fields in the PivotTable.
PivotTable Fields Pane
An Excel BI tool that allows you to create and interact with multiple charts, slicers, and other data visualizations in a single sheet.
Power View
Easy-to-use filtering controls with buttons that enable you to drill down through large amounts of data in an interactive way.
Slicer
A tool that allows you to drill down through PivotTable data with a single click.
Quick Explore
Tools that can be used to perform data analysis and create sophisticated charts and reports.
Business Intelligence
A method of incorporating data from multiple, related tables into an Excel worksheet.
Data Model
The lower portion of the PivotTable Field List where you build the PivotTable report by rearranging and repositioning fields.
Layout section
A graphical representation of the data in a PivotTable report.
PivotChart report
An interactive, Excel report that summarizes and analyzes large amounts of data.
PivotTable
An Excel BI tool that allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables.
PowerPivot
Data in a worksheet or from an external source, arranged in rows and columns suitable for a PivotTable.
Source Data
The command to update a worksheet to reflect new data.
refresh