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

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

A) (PIVOTTABLE TOOLS DESIGN tab | Create Chart group)
B) (PIVOTTABLE TOOLS ANALYZE tab | Tools group)
C) (PivotChart Tools Options tab | Show group)
D) (PIVOTCHART TOOLS DESIGN tab | Create Chart group)

Correct Answer

verified

Show Answer

Question 22

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

You can create PivotTable and PivotChart...

View Answer

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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. -An interactive chart that graphically presents data.

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

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

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.

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

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

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

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

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.

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.

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

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.

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

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.

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

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