ITE Chapter 4
A PivotTable report ________ large amounts of data so you can analyze related totals.
Combines and compares
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 a ________.
Data model
A method of incorporating data from multiple, related tables into an Excel worksheet is called a ________.
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
A Microsoft Access database can contain only one table.
False
A line chart shows the relationship of each part as a whole.
False
The source data for a PivotTable can come from any external source in any format.
False
In a PivotTable, a single piece of information for every record is called a ________.
Field
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
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
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 not a benefit to organizations of using Power BI?
It focusses on one data source
The area to rearrange and reposition fields in the PivotTable is called the ________.
Layout section
A chart that illustrates the relationship of each part to a whole is called a ________.
Pie chart
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 in a PivotTable and provides an area 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
You can apply a ________ to the entire PivotTable report.
PivotTable Style
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 report
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 rows in the PivotTable reports is called the ________.
ROWS Area
In the PivotTable field section, you can rearrange existing fields by using which of the following areas in the layout section?
ROWS Area
In Microsoft Access, each column is called a ________.
Record
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
By default, when a non-numeric field is added to a PivotTable, it is placed in the ________ area.
Rows area
A slicer includes a ________ that indicates the category of the slicer items.
Slicer header
________ are filtering controls with buttons that enable you to drill down through large amounts of data.
Slicers
The default calculation in a PivotTable Report is to ________ the numeric data.
Sum
A PivotChart usually has an associated PivotTable and the two are interactive.
True
A PivotTable is an interactive Excel report that summarizes large amounts of data, allowing you to more easily analyze it.
True
A graphical representation of the data in a PivotTable report is a PivotChart report.
True
A row label corresponds to a data series in a PivotTable report.
True
A slicer includes a slicer header that specifies the category of the slicer items.
True
From a PivotTable report, you can double-click a total to display the data on a new worksheet.
True
In Microsoft Access, the field that uniquely identifies a record is the primary key.
True
In a PivotTable report, the calculations can be modified.
True
In the PivotTable Field List, you can rearrange existing fields by using one of the four areas at the bottom of the layout section.
True
Most of the formatting that has been practiced in standard charts works the same way in a PivotChart.
True
Power BI can display data on pre-built dashboards.
True
A field that is being removed from the PivotTable report is indicated by a(n) ________ attached to the pointer as you drag.
X
By using a PivotTable, you can show the same data in a table in ________.
more than one arrangement
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
The data for a PivotTable formatted in columns and rows is called ________.
source data
Power BI is a business analytics service that organizations use to transform and analyze data.
True
Power BI is designed to be used primarily by organizations.
True
Slicers are easy-to-use filtering components that enable you to quickly filter data in a PivotTable report.
True
Slicers display as movable objects on your worksheet in the same manner as charts and shapes.
True
The Clear Filter command removes a filter.
True
To best represent large amounts of data, it is often helpful to filter the PivotTable.
True
You can create a data model by getting external data from Microsoft Access.
True
You can format a 3-D Pie PivotChart using the same techniques that you use to format a chart.
True
You update or refresh PivotTable report data.
True
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