FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A number from 0 to 1 that measures the strength of a trend.

A) trendline
B) PivotTable report
C) PivotChart report
D) slicers
E) forecasting
F) R-squared value
G) row fields
H) PivotTable fields
I) calculated field
J) column fields

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

When you need to analyze the data presented in PivotTables and PivotCharts, use a trendline to select the data to display and summarize.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A visual way to relate two variables.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Changes to series fields in a PivotChart report appear as changes to these in the PivotTable report.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An interactive chart that graphically presents data.

Charts with ____ are often reformatted to start the vertical axis at a number other than zero.

You can change the view of a PivotTable report depending on what you want to analyze.

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.

The summary function that calculates the smallest data value in a PivotTable report is ____.

Changes in the view of a PivotChart report are automatically reflected in the PivotTable report.

A(n) _________________________ is the symbol in a chart that represents a single value from a worksheet cell.

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.

Which of the following is the path to the PivotChart button?

Do you always have to refresh the PivotTable when you make a change to the underlying data? Explain your response.

Which of the following is the path to the PivotTable button?

All types of Excel charts can have a trendline added to them.

You can apply a number format to cells in a PivotTable report using a shortcut menu.

How do you determine which fields to use in a PivotTable?

You can click the ____ button in the Filter group on the PivotChart Tools Analyze tab to display the Insert Slicer dialog box.