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.