Excel Chapter 8

10 September 2022
4.7 (114 reviews)
66 test answers

Unlock all answers in this set

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