Chapter 7 Excel
data visualization
An object such as a chart or map on a Power View sheet is a ____
Add-in
An optional command or feature that is not immediately available and must be installed and/or activated use is a(n)
row labels
By default, when a non-numeric field is added to a Pivot Table, it is placed in the ______area
more than one arrangement
By using a Pivot Table report, you can show the same data in a table in ____
Business Intelligence Tools
Excel includes several ____that can be used to perform data analysis and create sophisticated charts and reports.
field names
Excel uses the column title as the _____for the categories of data
Row labels
In the Pivot Table Field list, you can rearrange existing fields or reposition fields by using which of the following areas at the bottom of the layout section.
column labels
In the Pivot Table 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
Bing
Power View can use the ____ map service if your data contains location information
Pivot Table Styles
Preformatted Pivot Tables that are arranged in a gallery are called ____
field buttons
The Pivot Chart displays ____that you can click to choose a filter and change the data displayed in the chart.
Quick explore
The ___tools allows you to drill down through Pivot Table data with a single click
slicer header
The category of slicer items is indicated by the ____
Power View
The charts and other objects created on a _____worksheet are related and can be cross-filtered
Sum
The default summary function for a data fields containing numbers in an Excel Pivot Table is____
Power View canvas
The part of a Power View worksheet where the data visualization displays is the ____
Switch visualization
To create a column chart visualization on a Power View sheet, first drag the fields to the Fields area, and then click the Column chart arrow in _____
Layout
To format the elements of a Power View object, select the object and then click the _____format tab.
edit cells in the source list and then refresh the Pivot Table
To make changes to Pivot Table data, you must
Values
When a numeric field is added to a Pivot Table, it is placed in the ___area of the Pivot Table field list
Power View Fields pane
When creating a Power View sheet, multiple tables are visible in the ____
Values
Which of the following areas of a Pivot Table field list allows you to display average values
data markers
Which of the following is a bar, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell.
field button
Which of the following is a button that identifies a field in a Pivot Table or Pivot Chart report
Pivot Table report
Which of the following is a report that provides interactive analysis of data, where you can change views of data, see different levels of details, or reorganize the chart layout by dragging fields and showing or hiding items in fields
Pivot Table report
Which of the following is an interactive Excel report that summarizes and analyzes data, such as database records from various sources external to Excel
External data
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
Summary calculation
Which of the following is the method of summarizing values in the data area of a Pivot Table report by using the values of other cells in the data area
PowerPivot
With ___ you can analyze data from multiple sources, work with multiple data tables, and create relationships between tables
filters
You can limit the display of data to specific information by using___
PowerPivot
You must use _____to create Pivot Tables using the data from multiple, related tables
Power View
_______allows you to create and interact with multiple charts, slicers, and other data visualization in a single sheet
Power View
____is a data visualization tool that can be used to create interactive dashboards and reports
refresh
If you change the underlying data on which a Pivot Table report is based, you must also ___or update the Pivot Table to reflect the new data.
field
In a Pivot Table or Pivot Chart Report, data is derived from a _____in the source data
Pivot Table Style
You can apply a _____to the entire Pivot Table report
combine and compares
A Pivot Table report ____large amounts of data so you can analyze related totals.
Data Model
A ___ is a method of incorporating data from multiple, related tables, into Excel worksheet.
Data Model
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.
X
A field that is being removed from the Pivot Table is indicated by a(n)