Excel Chapter 8
Which of the following is the path to the PivotChart menu?
(INSERT tab | Charts group)
The summary function that calculates the number of data values in a PivotTable report is ____.
Count
The summary function that calculates the smallest data value in a PivotTable report is ____.
Min
When creating a PivotTable report, the active cell should be positioned ____
anywhere in the range that contains the data
In PivotTables, ____ fields correspond to columns in the original data
category
The +/- buttons ____ a field across categories.
expand and collapse
You can add a trendline to all of the following EXCEPT a(n) ____ chart.
pie
Excel treats ____ as graphic objects that can be moved, resized, and formatted.
slicers
You can connect ____ to more than one PivotTable to filter the data.
slicers
A(n) ____ is most often thought about in terms of how a value changes over time, but can also describe the relationship between two variables.
trend
A ____ is a visual way to show how two variables relate to each other.
trendline
Which of the following is the path to the PivotTable button?
(INSERT tab | Tables group)
Which of the following is the path to the Field Buttons button?
(PIVOTCHART TOOLS ANALYZE tab | Show/Hide group)
Which of the following is the path to the 'Add Chart Element' button?
(PIVOTCHART TOOLS DESIGN tab | Chart Layouts group)
Which of the following is the path to the Move Chart button?
(PIVOTCHART TOOLS DESIGN tab | Location group)
Which of the following is the path to the Refresh button?
(PIVOTTABLE TOOLS ANALYZE tab | Data group)
Which of the following is the path to the +/- Buttons button?
(PIVOTTABLE TOOLS ANALYZE tab | Show group)
Which of the following is the path to the Field Headers button?
(PIVOTTABLE TOOLS ANALYZE tab | Show group)
Which of the following is the path to the Field List button?
(PIVOTTABLE TOOLS ANALYZE tab | Show group)
Which of the following is the path to the PivotChart button?
(PIVOTTABLE TOOLS ANALYZE tab | Tools group)
Which of the following is the path to the Report Layout button?
(PIVOTTABLE TOOLS DESIGN tab | Layout group)
Which of the following is the path to the PivotTable Styles gallery More button?
(PIVOTTABLE TOOLS DESIGN tab | PivotTable Styles group)
You can change the summary function in a PivotTable report by selecting a different summary function in the Value Field Settings dialog box
true
You can change the view of a PivotTable report depending on what you want to analyze.
true
You can remove a report filter from a PivotTable report by dragging the field outside of the PivotTable Fields task pane
true
PivotTable fields can be one of three types: data, summary, and category.
false
PivotTable rows are drawn from columns in the worksheet data
false
PivotTables automatically update when you change the underlying data for the PivotTable report
false
The default chart type for a PivotChart is a 2-D Line chart.
false
When you create a PivotTable report, Excel creates and associates a PivotChart with that PivotTable report
false
When you need to analyze the data presented in PivotTables and PivotCharts, use a trendline to select the data to display and summarize.
false
Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____.
filtering
With which of the following are any selected subgroups immediately identifiable, and able to be changed with the click of a button or buttons?
slicers
Before you add a trendline to a chart, you need to determine the data series to analyze.
true
Changes in the view of a PivotChart report are automatically reflected in the PivotTable report
true
Excel includes a number of preset PivotTable styles that function in similar fashion to Excel's table styles.
true
Excel needs the blank rows above a PivotTable to remain blank, for any filters added in the PivotTable Fields task pane.
true
To add data to a PivotTable, select field check boxes in the PivotTable Fields task pane.
true
Today, data are increasingly available from a wide variety of sources and gathered with much more ease.
true
Using a(n) trendline on certain Excel charts allows you to illustrate an underlying tendency of how one set of data is changing in relation to another set of data.
true
When analyzing a chart that contains a trendline, always check the axes to be sure that the differences shown in the chart are not being visually overstated.
true
When the data in a PivotTable report is changed, any PivotChart reports built upon that PivotTable report update to reflect those changes
true
When you add a trendline to a chart, you can set the number of periods to forecast forward or backward in time.
true
You can add data to a blank PivotTable by dragging fields from the 'Choose fields to add to report' area to the 'Drag fields between areas below' area.
true
In a PivotTable, ____ fields correspond to summary values of original data across categories.
Data
By default, a PivotChart report will be created on its own chart sheet in a workbook.
False
PivotChart reports often are used to represent changes in one set of data over time.
False
You can click the ____ button in the Filter group on the PivotChart Tools Analyze tab to display the Insert Slicer dialog box.
Insert Slicer
You can display the Move Chart dialog box by clicking the Move Chart button in the Location group on the ____.
PIVOTCHART TOOLS DESIGN tab
A ____ report is an interactive chart that allows users to change the groupings that graphically present data.
PivotChart
_____ reports are visual representations of PivotTables
PivotChart
Click the Options button in the ____ group on the PIVOTTABLE TOOLS ANALYZE tab to display the PivotTable Options dialog box.
PivotTable
A ____ is an interactive view of worksheet data.
PivotTable report
The ____ value is a number from 0 to 1 that measures the strength of a trend
R-squared
To create a PivotChart report directly from data, click the ____ button in the Charts group on the INSERT tab.
Recommended charts
You can filter the PivotTable report by ____.
Revenue Venue
You can change the height of a slicer by clicking the Height text box in the Buttons group on the ____ tab and then entering the desired height.
SLICER TOOLS OPTIONS
____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.
Slicers
The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report.
StdDev
To change the summary functions in a PivotTable, right-click a cell, point to ____, and click a command on the submenu.
Summarize Values By
Charts with ____ are often reformatted to start the vertical axis at a number other than zero.
Trendlines
PivotTables are ____ by nature.
dynamic
All summary functions are available from the shortcut menu of a cell in the PivotTable report.
false
All types of Excel charts can have a trendline added to them.
false
Filtering cannot happen independently of cell selection
false
Formatting techniques that work for regular tables of data behave in the same fashion in PivotTable reports.
false
