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