Question 1

The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report.

Accepted Answer

A)   Sum
B)   Varp
C)   StdDev
D)   Product C

Question 2

Which of the following is the path to the PivotTable Styles gallery More button?

Accepted Answer

A)   (INSERT tab | Table Styles group) 
B)   (PIVOTTABLE TOOLS DESIGN tab | PivotTable Styles group) 
C)   (HOME tab | Paint Styles group) 
D)   (PIVOTTABLE TOOLS LAYOUT tab | PivotTable Layout group)  B

Question 3

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

Accepted Answer

A)   (PIVOTTABLE TOOLS ANALYZE tab | Data group) 
B)   (PIVOTTABLE TOOLS DESIGN tab | Data group) 
C)   (PIVOTTABLE TOOLS FORMAT tab | Data group) 
D)   (PIVOTTABLE TOOLS LAYOUT tab | Data group)  A

Question 4

You can change the summary function in a PivotTable report by selecting a different summary function in the Value Field Settings dialog box.

Accepted Answer

A) True 
 B)False

Question 5

Clicking the _________________________ command on a shortcut menu displays the Expand/Collapse menu.

Accepted Answer

The answer of Clicking the _________________________ command on a shortcut...

Question 6

When the data in a PivotTable report is changed, any PivotChart reports built upon that PivotTable report update to reflect those changes.

Accepted Answer

A) True 
 B)False

Question 7

You can display a PivotTable report in one of four layouts: Compact Form, Outline Form, Tabular Form, and Landscape Form.

Accepted Answer

A) True 
 B)False

Question 8

____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.

Accepted Answer

A)   Slicers
B)   Trenders
C)   Charters
D)   Markers

Question 9

Formatting techniques that work for regular tables of data behave in the same fashion in PivotTable reports.

Accepted Answer

A) True 
 B)False

Question 10

The ____ value is a number from 0 to 1 that measures the strength of a trend.

Accepted Answer

A)   A-squared
B)   P-squared
C)   R-squared
D)   T-squared

Question 11

You can filter only one PivotTable at a time, whereas you can connect _________________________ to more than one PivotTable to filter data.

Accepted Answer

The answer of You can filter only one PivotTable at...

Question 12

Which of the following is the path to the 'Insert Line Chart' button?

Accepted Answer

A)   (INSERT tab | Charts group) 
B)   (HOME tab | Charts group) 
C)   (VIEW tab | Data group) 
D)   (INSERT tab | Images group)

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Predicting data values that are outside the data set.

Accepted Answer

A)  trendline
B)  PivotTable report
C)  PivotChart report
D)  slicers
E)  forecastingF) R-squared valueG) row fieldsH) PivotTable fieldsI) calculated fieldJ) column fields

Question 14

Describe planning considerations for adding a trendline to a chart.

Accepted Answer

The answer of Describe planning considerations for adding a trendline...

Question 15

A ____ is a visual way to show how two variables relate to each other.

Accepted Answer

A)   pivotline
B)   guideline
C)   timeline
D)   trendline

Question 16

To change the summary functions in a PivotTable, right-click a cell, point to ____, and click a command on the submenu.

Accepted Answer

A)   Subtotal Values By
B)   Summarize Values By
C)   Total Values By
D)   Calculate Values By

Question 17

With which of the following are any selected subgroups immediately identifiable, and able to be changed with the tap or click of a button or buttons?

Accepted Answer

A)   autofilters
B)   slicers
C)   filters
D)   pivots

Question 18

To add data to a PivotTable, select field check boxes in the PivotTable Fields task pane.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is the path to the Field Headers button?

Accepted Answer

A)   (PIVOTTABLE TOOLS DESIGN tab | Show group) 
B)   (PIVOTTABLE TOOLS LAYOUT tab | Show group) 
C)   (PIVOTTABLE TOOLS ANALYZE tab | Show group) 
D)   (PIVOTTABLE TOOLS DESIGN tab | Fields group)

Question 20

_________________________ helps predict data values that are outside of a data set.

Accepted Answer

The answer of _________________________ helps predict data values that are...

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

The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report.

Which of the following is the path to the PivotTable Styles gallery More button?

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

You can change the summary function in a PivotTable report by selecting a different summary function in the Value Field Settings dialog box.

Clicking the _________________________ command on a shortcut menu displays the Expand/Collapse menu.

When the data in a PivotTable report is changed, any PivotChart reports built upon that PivotTable report update to reflect those changes.

You can display a PivotTable report in one of four layouts: Compact Form, Outline Form, Tabular Form, and Landscape Form.

____ are a visual filter used to make PivotCharts and PivotTables easier to interpret.

Formatting techniques that work for regular tables of data behave in the same fashion in PivotTable reports.

The ____ value is a number from 0 to 1 that measures the strength of a trend.

You can filter only one PivotTable at a time, whereas you can connect _________________________ to more than one PivotTable to filter data.

Which of the following is the path to the 'Insert Line Chart' button?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Predicting data values that are outside the data set.

Describe planning considerations for adding a trendline to a chart.

A ____ is a visual way to show how two variables relate to each other.

To change the summary functions in a PivotTable, right-click a cell, point to ____, and click a command on the submenu.

With which of the following are any selected subgroups immediately identifiable, and able to be changed with the tap or click of a button or buttons?

To add data to a PivotTable, select field check boxes in the PivotTable Fields task pane.

Which of the following is the path to the Field Headers button?

_________________________ helps predict data values that are outside of a data set.