Excel Chapter 7
One possible source of data for a PivotTable is an
Access database file
Column 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.
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.
Slicer
Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data.
A tool that allows you to drill down through PivotTable data with a single click.
Quick Explore
Use PivotTable _________ and change field names to make the PivotTable easier to understand.
Syles
Associated PivotTable report
The PivotTable report in a workbook that is graphically represented in a PivotChart.
Using PowerPivot, a PivotChart does not have to be associated with a PivotTable.
True
The command to update a worksheet to reflect new data.
refresh
The _______ for a PivotTable must be formatted in columns and rows.
source data
In a PivotTable report, by default, the numeric data calculation performed is __________.
sum
Two ways to filter a PivotTable could be through using a search filter or using a _________?
slicer
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:
Filter area
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
Whenever the source data is changed, you will also need to _________ the PivotTable data to reflect the changes.
refresh
To work with multiple tables in Excel, a ________ must be created between the tables.
relationship
Field names
The column titles from source data that form the categories of data for a PivotTable.
Multiple Power View sheets can be created in a workbook.
True
When working with multiple tables in Excel, you must first establish a _________ betwee the tables.
relationship
Clear Filter
A button that removes a filter.
Quick Explore
A tool that allows you to drill down through PivotTable data with a single click.
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.
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.
The _______ is a report in w workbook that is graphically represented in a PivotChart.
Associated PivotTable
Area of a Power View worksheet that contains data visulizations.
Canvas
The ______ button removes a filter from a Slicer
Clear Filter
PivotTable reprts can only calculate sums of numerical data>
False
The background is the area of a Power View worksheet that contains data visulizations.
False
The only way to place field data on a PivotTable report is to drag the field names into the layout section.
False
The source data used to create a PivotTable report can be noncontiguous data in multiple and varying cells.
False
You can change the data displayed in the PivotChart by double clicking the vertical axis.
False
Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are:
Field buttons
The column titles from source data that form categories of data for a PivotTable.
Field name
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.
Field section
A process by which you can limit the display of data to only specific information.
Filter
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
An Excel BI tool that allows you to create and interact with multiple charts, slicers and other data visulaizations in a single sheet.
Power View
Tool used to create dashboards with multiple data visualizations in a single sheet
Power View
By default, non-numeric fields are added to the _____ box of the PivotTable Field task pane, and numeric fields are added to the _____ box.
Rows areas
Easy-to-use filtering controls with buttons that enable you to drill down through large amounts of data in an interactive way.
Slice
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.
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.
The area in the layout section of the PivotTable Field List where data is summarized is the:
Values area
PivotTable field names are formed from the source data's:
column titles
Use the PivotChart _______ to choose a filter.
field buttons
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.
In the PivotTable Fields pane, there are two tabs: ACTIVE AND ________.
ALL
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.
Use _________ to easily drill down through the PivotTable data with a single click.
Quick Explore
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.
Using PowerPivot, you can import multiple table data from Access.
True
__________ Tools can be used to perform data analysis and create sophisticated charts and reports
.Business Intelligence
Filtering button
A button on a slicer which you use to select the item by which to filter.
data model
A method of incorporating data from multiple, related tables into an Excel worksheet.
PowerPivot
An Excel BI tool that allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables.
Relationship
An association that you establish between two tables based on common fields.
Add-in
An optional command or feature that is not immediately available; you must first install and/or activate an add-in to use it.
Tools that can be used to perform data analysis and create sophisticated charts and reports.
Buisiness Intelligence tools
A _________ is a method of incorporating data from multiple, related tables into an Excel worksheet.
Data Model
A method of incorporating data from multiple, related tables into an Excel worksheet.
Data Model
You can import multiple table data from an Access database into the _________ by using PowerPivot.
Data Model
Data from an Excel workbook, and 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 _______.
Data model
If PowerPivot is not enabled, you will need to enable it from the _______ dialog box.
Excel options
The lower portion of the PivotTable Field List where you build the PivotTable report by rearranging and repositioning fields.
Layout section
A graphical representation of the data in a PivotTable.
PivotChart report
An interactive, Excel report that summarizes and analyzes large amounts of data.
PivotTable
An Excel BI tool that allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables.
PowerPivot
The tables in the __________ window do not contain row and column headings like an Excel worksheet, but rather field names like a database.
PowerPivot
Tool used to create relationships between multiple tables.
PowerPivot
Slicers display as movable floating objects on a worksheet.
True
The Insert Slicers dialog box displays all the field names from your PivotTable report.
True
Slicers are used to
filter data
The data for a PivotTable should be in the format of a:
list
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.
PivotChart report
A graphical representation of the data in a PivotTable report.
PivotTable
An interactive Excel report that summarizes and analyzes large amounts of data.
Data in a worksheet or from an external source, arranged in rows and columns suitable for a PivotTable.
Source data
canvas
The area of a Power View worksheet that contains data visualizations.
