Excel chapter 7
Slivers are used to
Filter data
Filter
A process by which you can limit the display of data to only specific information
One possible source of data for a pivot table is an
Access data base file
Buttons on a pivot chart with an arrow to choose a filter and thus change the data that is displayed in the chart are
Field buttons
To prevent a user from making changes to an excel worksheet use the _________ command so that the worksheet is not visible
Hide
Pivot table field panes
A windows that list the fields from the source data and an area in which you can arrange the fields in the pivot table
Slicer
Easy to use filtering controls with buttons that enable you to drill down through large amounts of data in an interactive way
Pivot chart
a graphical representation of the data in a pivot table
To import data from access into an excel data model, use the ___________command
Get external data
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.
The __________ is a report in a workbook that is graphically represented in a pivot chart
Associated pivot table
Data from an excel workbook, an access database or imported from an external source such as a corporate data base, a public data feed, or an analysis service can be incorporated in the _____________.
Data model
data model
A method of incorporating data from multiple, related tables into an Excel worksheet.
Values area
An area to position fields that contain data that is summarized in a PivotTable report or PivotChart report.
The data for a pivot table should be in the format of a
List
refresh
The command to update a worksheet 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 an external source
The ________ button removes a filter from a slicer
Clear filter
Primary key
The field used to uniquely identify a record in an access table
Layout section
The lower portion of the pivot table fields pane where you build the pivot table report by rearranging and repositioning fields
Slicer header
The top of a slicer that indicates the category of the slicer items
An ________ chart illustrates the relationship of each part to a whole
Pie
A ____________ display data series, categories, data markers and axes in the same manner as a standard chart
Pivot chart
To work with multiple tables in excel, a ___________ must be crested between the tables
Relationship
field
A single piece of information for every record
Pivot Table
An interactive excel repoet that summarizes and analyzed large amounts of data
Pivot table field names are formed from the source datas
Column titles
The area in the layout section of the pivot table fields pane where you position fields by which you want to filter the pivot table report, this enabling you to display a subset of data in the pivot table report is
Filters area
The area in the layout section of the pivot table fields pane where data is summarized is the
Values area
Field names
The column titles from source data that form categories of data for pivot table
