ITE 140 module 4
Use the (blank) dialog box to change the calculation used in a PivotTable.
Value Field settings
An area to position fields that contain data that is summarized in a PivotTable or PivotChart is called the (blank)
Values area
Which of the following areas of the PivotTable Fields pane enables you to find the average of numbers in a PivotTable?
Values area
A (blank) can import data from an Excel workbook a Microsoft Access database, or an external source such as a corporate database, a public data field, or an analysis service.
data model
A method of incorporating data from multiple, related tables into an Excel worksheet is called a (blank).
data model
A Microsoft Access database can contain only one table.
false
A line chart shows the relationship of each part to a whole.
false
In a Microsoft Access table, a single piece of information for every record is called a (blank).
field
In a Microsoft Access table, each column is called a (blank).
field
A PivotChart displays (blank) 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 (blank) for the categories of data in a PivotTable.
field names
You can create a PivotChart from the data in a data model, and then (blank) the PivotChart to best represent your data.
filter
You can limit the display of data in a PivotTable to specific information by using (blank).
filtering
A chart that illustrates the relationship of each part to a whole is called a (blank).
pie chart
The Axis (Categories) area in the PivotChart Fields pane corresponds to the legend in a pie chart.
true
To best represent you data, it is often helpful to filter a PivotChart.
true
When importing Access data, the Navigator dialog box displays the database name and the tables included in the database.
true
The area to rearrange and reposition fields in the PivotTable is called the (blank).
Area section
If the Recommended PivotTables dialog box does not provide an appropriate layout for your data, you can create a custom PivotTable by clicking (blank).
Blank PivotTable
A section to position fields that you want to display as columns in a PivotTable is called the (blank).
Columns area
In the PivotTable Fields pane, you can use check boxes to add fields to and remove fields from a PivotTable in the (blank).
Fields section
Use the (blank) are of the PivotTable Fields pane to position fields to use for displaying a subset of the data in the PivotTable report.
Filters
Which of the following enables the selection of more than one filtering button in a slicer?
Multi-select button
When you import data from Microsoft Access to and Excel data model, the (blank) dialog box displays.
Navigator
You can use multiple, related tables from an Access database to create PivotTables and (blank) in Excel.
PivotCharts
In a PivotChart, the field buttons correspond to the fields used in the (blank)
PivotTable
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?
PivotTable
Which of the following is an interactive Excel report that summarizes and helps analyze large amounts of data.
PivotTable
The (blank) is a window that lists all the fields from the source data in a PivotTable and provides an area in which you can arrange the fields in the PivotTable.
PivotTable Fields pane
You can apply a (blank) to the entire PivotTable report.
PivotTable Style
By default, when a nonnumeric field is added to a PivotTble, it is placed in the (blank) area of the PivotTable Fields pane.
Rows
A section to position fields that you want to display as rows in a PivotTable is called the (blank)
Rows area
(Blank) are filtering controls with buttons that enable you to drill down through large amounts of data.
Slicerss
The default calculation in a PivotTable report is to (blank) the numeric data.
Sum
By default, when a numeric field is added to a PivotTable, it is placed in the (blank) area of the PivotTable Fields pane.
Value
A field that is being removed from the PivotTable report is indicated by an (blank) attached to the pointer as you drag.
X
In a Microsoft Access table, the field used to uniquely identify a record is called a (blank).
primary key
In a Microsoft Access table, each row is called a (blank).
record
If you change the underlying data on which a PivotTable report is based, you must also (blank) 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 a called a (blank).
relationship
A slicer includes a (blank) that indicates the category of the slicer items.
slicer header
The data for a PivotTable that must be formatted in columns and rows is called (blank).
source data
In a Microsoft Access table, the field that uniquely identifies a record is the primary key.
true
You can create a data model by getting external data from Microsoft Access.
true
You can format a PivotChart using the same techniques that you use to format a Chart.
true
You can modify the data that displays in a PivotChart by dragging the fields between areas in the PivotChart Fields pane.
true
