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
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy