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