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