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