Excel Ch 7

Data Model

A method of incorporating data from multiple, related tables into an Excel worksheet.

In the PivotTable Fields pane, there are two tabs: ACTIVE and _____.

ALL

Business Intelligence tools

Can be used to perform data analysis and create sophisticated charts and reports.

You can import multiple table data from an Access database into the __________ by using PowerPivot.

Data Model

If PowerPivot is not enabled, you will need to enable it from the __________ dialog box.

Excel Options

In a PivotTable report, you cannot change a column field to display as a row field.

False

PivotTable reports can only calculate sums of numerical data.

False

The background is the area of a Power View worksheet that contains data visualizations. T/F

False

The only way to place field data on a PivotTable report is to drag the field names into the layout section. T/F

False

The source data used to create a PivotTable report can be noncontiguous data in multiple and varying cells. T/F

False

You can change the data displayed in the PivotChart by double clicking the vertical axis.

False

Use the PivotChart __________ to choose a filter.

Field buttons

Use __________ to easily drill down through the PivotTable data with a single click.

Quick Explore

By default, non-numeric fields are added to the _____.

ROWS area

Whenever the source data is changed, you will also need to __________ the PivotTable data to reflect the changes.

Refresh

Two ways to filter a PivotTable could be through using a search filter or using a __________.

Slicer

The _____________ for a PivotTable must be formatted in columns and rows.

Source data

Use PivotTable __________ and change field names to make the PivotTable easier to understand.

Styles

In a PivotTable report, by default, the numeric data calculation performed is __________.

Sum

Multiple Power View sheets can be created in a workbook. T/F

True

Slicers display as movable floating objects on a worksheet.

True

The Insert Slicers dialog box displays all the field names from your PivotTable report.

True

Using PowerPivot, a PivotChart does not have to be associated with a PivotTable.

True

Using PowerPivot, you can import multiple table data from Access.

True

FILTERS area

is an area to position fields by which you want to filter the PivotTable report.

VALUES area

is an area to position fields that contain data that is summarized in a PivotTable report or PivotChart report.

PivotTable report

is an interactive Excel report that summarizes and analyzes large amounts of data

When working with multiple tables in Excel, you must first establish a __________ between the tables.

relationship

Field section

the upper portion of the PivotTable Fields pane containing the column titles from your source data.