Chapter 7 ITE 140
An optional command or feature that is not immediately available and must be installed and/or activated use is a(n):
Add-in
To format the elements of a PowerView object, select the object and then click the ________ tab.
LAYOUT
You can apply a ________ to the entire PivotTable report.
PivotTable Style
Which of the following is a report that provides interactive analysis of data, where you can change views of data, see different levels of detail, or reorganize the chart layout by dragging fields and showing or hiding items in fields?
PivotTable report
Which of the following is an interactive Excel report that summarizes and analyzes data, such as database records from various sources, including those that are external to Excel?
PivotTable report
With ________ you can analyze data from multiple sources, work with multiple data tables, and create relationships between tables.
PowerPivot
You must use ________ to create PivotTables using the data from multiple, related tables.
PowerPivot
The charts and other objects created on a ________ worksheet are related and can be cross-filtered.
PowerView
________ allows you to create and interact with multiple charts, slicers and other data visualizations in a single sheet.
PowerView
________ is a data visualization tool that can be used to create interactive dashboards and reports.
PowerView
When creating a PowerView sheet, multiple tables are visible in the:
PowerView Fields pane
The part of a PowerView worksheet where the data visualization displays is the:
PowerView canvas
A field that is being removed from the PivotTable report is indicated by a(n):
X
PowerView can use the ________ map service to generate a map if your data contains location information.
bing
Excel includes several ________ that can be used to perform data analysis and create sophisticated charts and reports.
business intelligence tools
In the PivotTable field list, you can rearrange existing fields or reposition those fields by using which of the following areas at the bottom of the layout section?
column labels
A PivotTable report ________ large amounts of data so you can analyze related totals.
combines and compares
Which of the following is a bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell?
data markers
A ________ can import data from an Excel workbook, from an Access database, or from an external source such as a corporate database, a public data feed, or an analysis service.
data model
A ________ is a method of incorporating data from multiple, related tables into an Excel worksheet.
data model
An object such as a chart or map on a PowerView sheet is a:
data visualization
To make changes to PivotTable data, you must:
edit cells in the source list and then refresh the PivotTable.
Which of the following is data that is stored outside of Excel and includes databases created in Access, dBase, SQL Server or on a Web server?
external data
In a PivotTable or PivotChart report, data is derived from a ________ in the source data.
field
Which of the following is a button that identifies a field in a PivotTable or PivotChart report?
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
You can limit the display of data to specific information by using:
filters
By using a PivotTable Report, you can show the same data in a table in:
more than one arrangement
Preformatted PivotTables that are arranged in a gallery are called:
pivot table styles
The ________ tool allows you to drill down through PivotTable data with a single click.
quick explore
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.
row labels
In PivotTable Field List, you can rearrange existing fields or reposition fields by using which of the following areas at the bottom of the layout section?
row labels
The category of slicer items is indicated by the:
slice header
The default summary function for a data fields containing numbers in an Excel PivotTable is:
sum
Which of the following is the method of summarizing values in the data area of a PivotTable report by using the values other cells in the data area?
summary calculation
To create a column chart visualization on a PowerView sheet, first drag the fields to the FIELDS are, and then click the Column Chart arrow in the ________ group.
switch visualization
When a numeric field is added to a PivotTable, it is placed in the ________ area of the PivotTable field list.
values
Which of the following areas of a PivotTable field list allows you to display average values?
values