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.
