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

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.

(Multiple Choice)

4.8/5

(33)

Question 21

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

(True/False)

4.9/5

(35)

Question 22

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

(Multiple Choice)

4.8/5

(37)

Question 23

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

(Essay)

4.9/5

(38)

Question 24

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

(Multiple Choice)

4.7/5

(40)

Question 25

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

(Short Answer)

4.7/5

(38)

Question 26

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/False)

5.0/5

(42)

Question 27

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

(Multiple Choice)

4.9/5

(28)

Question 28

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

(Multiple Choice)

4.9/5

(42)

Question 29

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

(Multiple Choice)

4.7/5

(35)

Question 30

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/False)

4.8/5

(37)

Question 31

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.

(Multiple Choice)

4.8/5

(23)

Question 32

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

(Multiple Choice)

4.9/5

(32)

Question 33

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

(Multiple Choice)

4.8/5

(33)

Question 34

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

(True/False)

4.8/5

(38)

Question 35

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

(True/False)

4.9/5

(35)

Question 36

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.

(Multiple Choice)

4.8/5

(21)

Question 37

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

(True/False)

4.9/5

(34)

Question 38

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

(Essay)

4.8/5

(33)

Question 39

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

(True/False)

4.8/5

(34)

Question 40

Showing 21 - 40 of 112

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.

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

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

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

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.

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.

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

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

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

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.

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 PivotTable button?

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

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

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

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.

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

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

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters