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