Chapter 7
An area to position fields that you want to display as columns in the PivotTable is called _________.
COLUMNS area
A method of incorporating data from multiple, related tables into an Excel worksheet is called a ______.
Data Model
A _______ can import data from and Excel workbook, from a Microsoft Access database, or from an external source such as a corporate database, a public feed, or an analysis service.
Data model
The _______ is an area where you can position fields to use for filtering the PivotTable and thereby enabling you to display a subset of the data in the PivotTable report.
FILTERS area
Which of the following is a button on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart?
Field button
When getting external data from Microsoft Access, in the Select Table dialog box, select the "enable selection of multiple tables" check box, and then click the ________ to select all of the tables in the database.
Name
A chart that illustrates the relationship of each part to a whole is called a _________.
Pie chart
When you import data from Microsoft Access to a PivotTable report, the _______ placeholder displays on the left side of the worksheet and PivotTable fields pane displays on the right.
PivotTable
Which of the following is an interactive report that summarizes and helps analyze large amounts of data?
PivotTable
The ______ is a window that lists all the fields from the source data for us in a PivotTable and provides an areas in which you can rearrange the fields in the PivotTable.
PivotTable Fields pane
When you import data from Microsoft Access to a PivotTable report, the _____ displays to the right of the worksheet.
PivotTable Fields pane
Which of the following is a report that is useful when you want to analyze totals, such as when you have a long list of numbers to sum and you want to compare several facts about each total?
PivotTable Report
You can apply a _______ to the entire PivotTable report.
PivotTable style
An area to position fields that you want to display as rows in the PivotTable reports is called the _______.
ROWS area
By default, when a non-numeric field is added to a PivotTable, it is placed in the ______ area.
ROWS area
In the PivotTable field section, you can arrange existing fields by using which of the following areas in the layout section?
ROWS area
______ are filtering controls with buttons that enable you to drill down through large amounts of data.
Slicers
An area to position fields that contain data that is summarized in a PivotTable or PivotChart is called the _______.
VALUES area
When a numeric field is added to a PivotTable, it is placed in the _______ area of the PivotTable field list.
VALUES area
Which of the following areas of a PivotTable field list enables you to display average values?
VALUES area
A field that is being removed from the PivotTable report is indicated by a(n) attached to the pointer as you drag ___________.
X
A PivotTable report _______ large amounts of data so you can analyze related totals.
combines and compares
In Microsoft Access, each column is called a _________.
field
In a PivotTable, a single piece of information for every record is called a ________.
field
A PivotChart displays _________ that you can click to choose a filter and change the data displayed in the chart.
field buttons
Excel uses the column titles as the ________ for the categories of data.
field names
To limit the display of data to only a specific information is called ______.
filter
You can limit the display of data to specific information by using _______.
filtering
The area to rearrange and reposition fields in the PivotTable is called the __________.
layout section
By using a PivotTable, you can show that same data in a table in ______.
more than one arrangement
In Microsoft Access, the field used to uniquely identify a record is called a __________.
primary key
In Microsoft Access, each row is called a __________.
record
If you change the underlying data on which a PivotTable report is based, you must also ________ or update the PivotTable to reflect the new data.
refresh
When you import data from Microsoft Access to Excel, the resulting association between tables of data that share a common field is called a ________.
relationship
A slicer includes a _________ that indicated the category of the slicer items.
slicer header
The data for a PivotTable formatted in columns and rows is called _______.
source data
The default calculation in a PivotTable Report is to ________ the numeric data.
sum
