MyLab IT Excel Chapter 4
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.
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.
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.
Clear Filter
A button that removes a filter.
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.
Layout section
The lower portion of the PivotTable Field List where you build the PivotTable report by rearranging and repositioning fields.
Source data
Data in a worksheet or from an external source, arranged in rows and columns suitable for a PivotTable.
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:
To work with multiple tables in Excel, a __________ must be created between the tables. A. Data Model B. PivotChart C. relationship
C
refresh
The command to update a worksheet to reflect new data.
The ____________ is a report in a workbook that is graphically represented in a PivotChart. A. Associated PivotTable B. PivotChart Report C. Report Filter
A
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
A
To import data from Access into an Excel Data Model, use the __________ command. A. Get External Data B. Get Data Model C. Open Relationship
A
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.
Quick Explore
A tool that allows you to drill down through PivotTable data with a single click.
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.
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.
Relationship
An association between tables that share a common field.
Canvas
Area of a Power View worksheet that contains data visualizations.
A ____________ displays data series, categories, data markers, and axes in the same manner as a standard chart. A. Associated PivotTable B. PivotChart C. Table
B
A(n) __________ chart illustrates the relationship of each part to a whole. A. column B. area C. pie
C
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
C
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
C
The data for a PivotTable should be in the format of a: A. chart B. file C. list
C
column titles
PivotTable field names are formed from the source data's
filter data
Slicers are used to
Associated PivotTable report
The PivotTable report in a workbook that is graphically represented in a PivotChart.
VALUES area
The area in the layout section of the PivotTable Field List where data is summarized is the
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
Refresh
The command to update a worksheet to reflect the new data.
list
The data for a PivotTable should be in the format of a:
Source data
The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source.
Slicer header
The top of a slicer that indicates the category of the slicer items
Filter
To limit the display of data to only specific information.
Business Intelligence tools
Tools that can be used to perform data analysis and create sophisticated charts and reports.
Business Intelligence Tools
Used to perform data analysis and create sophisticated charts and reports
The ____________ button removes a filter from a slicer. A. Clear Filter B. Remove Slicer C. Slicer Header
A
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
A
Add-ins
Optional commands and features that are not immediately available; you must first install and/or active this before you can use it.
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.
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
A
One possible source of data for a PivotTable is a(n): A. Access database file B. PowerPoint presentation file C. Word template file
A
PivotTable field names are formed from the source data's: A. column titles B. row titles C. sheet tab names
A
Filtering button
A button on a slicer which you use to select the item by which to filter.
PowerPivot
Allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables
PivotTable
An interactive, Excel report that summarizes and analyzes large amounts of data.
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.
PivotChart report
A graphical representation of the data in a PivotTable report.
PivotChart report
A graphical representation of the data in a PivotTable.
PowerPivot
An Excel BI tool that allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables.
Power View
An Excel BI tool that allows you to create and interact with multiple charts, slicers and other data visualizations in a single sheet.
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.
PivotTable
An interactive Excel report that summarizes and analyzes large amounts of data.
Slicers are used to: A. apply labels to data B. filter data C. sort data
B
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.