MyLab IT Excel Chapter 4

Associated PivotTable report

The PivotTable report in a workbook that is graphically represented in a PivotChart.

Business Intelligence Tools

Used to perform data analysis and create sophisticated charts and reports

The area in the layout section of the PivotTable Fields pane where data is summarized is the: A. COLUMNS area B. ROWS area C. VALUES area

Values Area

Slicers are used to: A. apply labels to data B. filter data C. sort data

filter data

Relationship

An association between tables that share a common field.

The ____________ is a report in a workbook that is graphically represented in a PivotChart. A. Associated PivotTable B. PivotChart Report C. Report Filter

Associated PivotTable

list

The data for a PivotTable should be in the format of a:

Values area

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

ROWS area

An area to position fields that you want to display as rows in the PivotTable report. Field names placed here become row titles, and the data is grouped by these row titles.

VALUES area

The area in the layout section of the PivotTable Field List where data is summarized is the

Clear Filter

A button that removes a filter.

Field button

A button on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart.

PivotTable field names are formed from the source data's: A. column titles B. row titles C. sheet tab names

Column titles

Add-ins

Optional commands and features that are not immediately available; you must first install and/or active this before you can use it.

A(n) __________ chart illustrates the relationship of each part to a whole. A. column B. area C. pie

Pie

To work with multiple tables in Excel, a __________ must be created between the tables. A. Data Model B. PivotChart C. relationship

Relationship

filter data

Slicers are used to

Layout section

The lower portion of the PivotTable Field List where you build the PivotTable report by rearranging and repositioning fields.

Layout section

The lower portion of the PivotTable Fields pane containing the four areas for layout; use this area to rearrange and reposition fields in the PivotTable.

Slicer header

The top of a slicer that indicates the category of the slicer items

Filtering button

A button on a slicer which you use to select the item by which to filter.

PivotChart report

A graphical representation of the data in a PivotTable report.

PivotChart report

A graphical representation of the data in a PivotTable.

Data Model

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

Filter

A process by which you can limit the display of data to only specific information.

Field

A single piece of information for every record

PivotTable Fields Pane

A window that lists the fields from the source data and an area in which you can arrange the fields in the PivotTable.

PivotTable Fields pane

A window that lists, at the top, all of the fields—column titles—from the source data for use in the PivotTable report and at the bottom, an area in which you can arrange the fields in the PivotTable.

One possible source of data for a PivotTable is a(n): A. Access database file B. PowerPoint presentation file C. Word template file

Access database file

PowerPivot

Allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables

PowerView

Allows you to create and interact with multiple charts, slicers, and other data visualizations in a single worksheet

Quick Explore

Allows you to drill down through PivotTable data with a single click

FILTER area

An area in the lower portion of the PivotTable Fields pane to position fields by which you want to filter the PivotTable report, enabling you to display a subset of data in the PivotTable report.

PivotTable

An interactive Excel report that summarizes and analyzes large amounts of data.

PivotTable

An interactive, Excel report that summarizes and analyzes large amounts of data.

Canvas

Area of a Power View worksheet that contains data visualizations.

Field buttons

Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are:

The ____________ button removes a filter from a slicer. A. Clear Filter B. Remove Slicer C. Slicer Header

Clear filter

Data from an Excel workbook, an Access database, or imported from an external source such as a corporate database, a public data feed, or an analysis service can be incorporated in the ___________. A. Associated Reports B. Business Intelligence C. Data Model

Data Model

Source data

Data in a worksheet or from an external source, arranged in rows and columns suitable for a PivotTable.

Slicer

Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data.

Slicer

Easy-to-use filtering controls with buttons that enable you to drill down through large amounts of data in an interactive way.

Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are: A. Field buttons B. Slicer headers C. Quick Explore

Field Buttons

The area in the layout section of the PivotTable Fields pane where you position fields by which you want to filter the PivotTable report, thus enabling you to display a subset of data in the PivotTable report is the: A. FILTERS area B. ROWS area C. VALUES area

Filters Area

To import data from Access into an Excel Data Model, use the __________ command. A. Get External Data B. Get Data Model C. Open Relationship

Get Data

To prevent a user from making changes to an Excel worksheet, use the ___________ command so that the worksheet is not visible. A. Hide B. Protect C. Conceal

Hide

The data for a PivotTable should be in the format of a: A. chart B. file C. list

List

A ____________ displays data series, categories, data markers, and axes in the same manner as a standard chart. A. Associated PivotTable B. PivotChart C. Table

PivotChart

column titles

PivotTable field names are formed from the source data's

Field names

The column titles from source data that form categories of data for a PivotTable.

Field names

The column titles from source data that form the categories of data for a PivotTable.

refresh

The command to update a worksheet to reflect new data.

Refresh

The command to update a worksheet to reflect the new data.

Source data

The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source.

Primary key

The field used to uniquely identify a record in an Access table.

Slicer header

The top of a slicer that indicates the category of the slicer items.

Field section

The upper portion of the PivotTable Fields pane containing the fields—column titles—from your source data; use this area to add fields to and remove fields from the PivotTable.

Filter

To limit the display of data to only specific information.

VALUES area

An area to position fields that contain data that is summarized in a PivotTable report or PivotChart report. The data placed here is usually numeric or financial in nature and the data is summarized—summed. You can also perform other basic calculations such as finding the average, the minimum, or the maximum.

COLUMNS area

An area to position fields that you want to display as columns in the PivotTable report. Field names placed here become column titles, and the data is grouped in columns by these titles.

FILTER area

The area in the layout section of the PivotTable Field List where you position fields by which you want to filter the PivotTable report, thus enabling you to display a subset of data in the PivotTable report is the