ITE 140 Chapter 7
field buttons
A PivotChart displays ________ that you can click to choose a filter and change the data displayed in the chart.
combines and compares
A PivotTable report ________ large amounts of data so you can analyze related totals. Group of answer choices
data model
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.
pie chart
A chart that illustrates the relationship of each part to a whole is called a ________.
X
A field that is being removed from the PivotTable report is indicated by a(n) attached to the pointer as you drag ________.
data model
A method of incorporating data from multiple, related tables into an Excel worksheet is called a ________.
Slicer header
A slicer includes a ________ that indicates the category of the slicer items.
VALUES area
An area to position fields that contain data that is summarized in a PivotTable or PivotChart is called the ________.
COLUMN Area
An area to position fields that you want to display as columns in the PivotTable is called ________.
ROWS Area
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.
more than one argument
By using a PivotTable, you can show the same data in a table in ________.
field names
Excel uses the column titles as the ________ for the categories of data.
refresh
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.
field
In Microsoft Access, each column is called a ________.
record
In Microsoft Access, each row is called a ________.
Primary Key
In Microsoft Access, the field used to uniquely identify a record is called a ________.
field
In a PivotTable, a single piece of information for every record is called a ________.
ROWS Area
In the PivotTable field section, you can rearrange existing fields by using which of the following areas in the layout section?
PivotTable Field pane
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.
FILTERS Area
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.
Layout section
The area to rearrange and reposition fields in the PivotTable is called the ________.
source data
The data for a PivotTable formatted in columns and rows is called ________.
sum
The default calculation in a PivotTable Report is to ________ the numeric data.
filter
To limit the display of data to only specific information is called ________. Group of answer choices
VALUES Area
When a numeric field is added to a PivotTable, it is placed in the ________ area of the PivotTable field list.
name
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 ________ check box to select all of the tables in the database.
relationship
When you import data from Microsoft Access to Excel, the resulting association between tables of data that share a common field is called a ________.
PivotTable Fields pane
When you import data from Microsoft Access to a PivotTable Report, the ________ displays on the right side of the worksheet.
PivotTable
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.
VALUES Area
Which of the following areas of a PivotTable field list enables you to display average values?
Field Button
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?
PivotTable Report
Which of the following is a report that is useful when you want to analyze related totals, such as when you have a long list of numbers to sum and you want to compare several facts about each total? Group of answer choices
PivotTable
Which of the following is an interactive Excel report that summarizes and helps analyze large amounts of data?
PivotTable Style
You can apply a ________ to the entire PivotTable report.
filtering
You can limit the display of data to specific information by using ________.
Slicers
________ are filtering controls with buttons that enable you to drill down through large amounts of data.
