Decision Making with Spreadsheets - Chapter 4
Pivot Chart
A ___________ displays data series, categories, data markers, and axes in the same manner as a standard chart
Pie
A ____________ chart illustrates the relationship of each part to a whole
Pivot Chart
A graphical representation of the data in a PivotTable
Data Model
A method of incorporating data from multiple, related tables into an Excel worksheet
Filter
A process by which you can limit the display of data to only specific information
Field
A single piece of information for every record
Pivot Table Fields Pane
A window that lists the fields from the source data and an area in which you can arrange the fields in the Pivot Table
Values area
An area to position fields that contain data that is summarized in a Pivot Table or Pivot Chart report
Pivot Table
An interactive Excel report that summarizes and analyzes large amounts of data
Field Buttons
Buttons on a PivotChart with an arrow to choose a filter and thus change the data that is displayed in the chart are
Data Model
Data from an Excel workbook, an access database, or imported from an external source such as a corporate database, public data feed, or an analysis service can be incorporated in the
Slicer
Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data in an interactive way
Access Database File
One possible source of data for a PivotTable is a
Column Titles
Pivot Table field names are formed from the source data's
Filter data
Slicers are used to
Associated Pivot Table
The ________ is a report in a workbook that is graphically represented in a PivotChart
Clear Filter
The _________ button removes a filter from a slicer
Refresh
The command to update a Pivot Table to reflect new data
Source Data
The data for a Pivot Table, formatted in columns and rows, which can be located in an Excel worksheet or external source
Get Data
To import data from Access into an Excel data model, use the _________ command
Hide
To prevent a user from making changes to an Excel worksheet, use the _______ command so that the worksheet is not visible
Relationship
To work with multiple tables in Excel, a __________ must be created between the tables
Values area
The area in the layout section of the pivotable fields pane where data is summarizes is the
Filters area
The area in the layout section of the pivotable fields pane where you position fields by which you want to filter the pivotable report, thus enabling you to display a subset of data in the pivotable report is the
Field Names
The column titles from source data that form categories of data for a Pivot Table
List
The data for a pivot Table should be in the format of a
Primary key
The field used to uniquely identity a record in an Access table
Layout Section
The lower portion of the Fields pane where you build the Pivot Table report by rearranging and repositioning the fields
Slicer Header
The top of a slicer that indicates the category of the slicer items
Field Section
The upper portion of the Pivot Table fields pane containing the fields - column titles - from your source data; use this area to add fields to and remove fields from the PivotTable