chapter 4, 5 & 6 quizzes combined
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:
Filters area
The command to move to a specific cell or range of cells in a large worksheet:
Go to
The command that totals several rows of related data together:
Subtotal
One possible source of data for a PivotTable is a(n):
Access database file
A chart that is inserted into the same worksheet that contains the data used to create the chart:
Embedded chart
Colored and underlined text that you can click to go to a file, a location in a file, a webpage on the Internet, or a webpage on your organization's intranet:
Hyperlink
Column and row headings that describe the values and help the reader understand the chart:
Labels
A widely used file format developed by Adobe Systems that lets you create a representation of electronic paper that displays your data on the screen as it would look when printed:
The Excel View in which you can adjust paging in a worksheet:
Page Break Preview
A(n) _____ displays data series, categories, data markers, and axes in the same manner as a standard chart:
PivotChart
An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data:
Recommended charts
A policy within an organization that all forms created within the organization will have a uniform appearance; the data will always be organized in the same manner:
Standardization
The area in the layout section of the PivotTable Fields pane where data is summarized is the:
Values Area
PivotTable field names are formed from the source data's:
column titles
A file type that saves the contents of the cells by placing commas between them and an end-of-paragraph mark at the end of each row:
csv
A command that displays only the rows that meet a criteria:
filter
The data for a PivotTable should be in the format of a:
list
A command that organizes data in a particular order:
sort
Before subtotaling a list, the list must be:
sorted
A filter that uses more than one condition or that uses comparison operators:
Compound filter
The _____ is a report in a workbook that is graphically represented in a PivotChart:
PivotChart report
This prevents anyone from altering the formulas or changing other template components:
Protection
A special workbook that may include formatting, formulas, and other elements and is used as a pattern for creating other workbooks:
Template
Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart area:
Field buttons
A line that serves as a frame of reference for measurement and that borders the chart plot area:
Axis
Slicers are used to:
C. Slicers are used to: lter data
Objects that make up a chart:
Chart elements
A workbook sheet that contains only a chart:
Chart sheet
The _____ button removes a filter from a slicer:
Clear Filter
Tiny charts that fit within a cell and give a visual trend summary alongside data:
Sparklines
