Quiz 7
A field that is being removed from the PivotTable report is indicated by a(n) attached to the pointer as you drag ________.
X
You can apply a _______ to the entire PivotTable report.
PivotTable Style
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
In Microsoft Access, the field used to uniquely identify a record is called a _______.
primary key
An area to position fields that you want to display as columns in the PivotTable is called ________.
COLUMNS Area
A ________ can import data from an Excel workbook, from a Microsoft Access database, or from an external source such as a corporate database, a public data feed, or an analysis service.
Data Model
A method of incorporating data from multiple, related tables into an Excel worksheet is called a ________.
Data Model
A method of incorporating data from multiple, related tables into an Excel worksheet is a ________.
Data model
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 you import data from Microsoft Access to a PivotTable Report, the ________ placeholder displays on the left side of the worksheet and the PivotTable Fields pane displays on the right.
PivotTable
Which of the following is an interactive Excel 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 arrange the fields in the PivotTable.
PivotTable Fields pane
When you import data from Microsoft Access to a PivotTable Report, the _______ displays on the right side of the worksheet.
PivotTable Fields pane
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
______ are filtering controls with buttons that enable you to drill down through large amounts of data.
Slicers
Which of the following areas of a PivotTable field list enables you to display average values?
VALUES Area
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
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 specific information is called ________.
filter
You can limit the display of data to specific information by using______.
filtering
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
A slicer includes a ________ that indicates 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
By using a PivotTable, you can show the same data in a table in ________.
more than one arrangement
A chart that illustrates the relationship of each part to a whole is called a ________.
pie chart
The area to rearrange and reposition fields in the PivotTable is called the ________.
layout section
