Excel chp 4 - PDF
Slicer
Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data in an interactive way.
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.
PivotTable Fields pane
A window that lists the fields from the source data and an area in which you can arrange the fields in the PivotTable.
Values area
An area to position fields that contain data that is summarized in a PivotTable or PivotChart report.
PivotTable
An interactive Excel report that summarizes and analyzes large amounts of data.
column titles
PivotTable field names are formed from the source data's:
filter data
Slicers are used to:
Slicer header
The top of a slicer that indicates the category of the slicer items.
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.
Clear Filter
The ____________ button removes a filter from a slicer.
associated PivotTable
The ____________ is a report in a workbook that is graphically represented in a PivotChart.
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.
pie
A(n) __________ chart illustrates the relationship of each part to a whole.
PivotChart
A graphical representation of the data in a PivotTable.
Data model
A method of incorporating data from multiple, related tables into an Excel worksheet.
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:
Access database file
One possible source of data for a PivotTable is a(n):
Filters area
The area in the layout section of the PivotTable Fields pane where you position fields by which you want to filter the PivotTable report, thus enabling you to display a subset of data in the PivotTable report, is the:
Field names
The column titles from source data that form categories of data for a PivotTable.
Refresh
The command to update a PivotTable to reflect new data.
list
The data for a PivotTable should be in the format of a:
Source data
The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source.
Primary key
The field used to uniquely identify a record in an Access table.
Layout section
The lower portion of the PivotTable Fields pane where you build the PivotTable report by rearranging and repositioning fields.
