Exam 5: Subtotals, Pivottables, and Pivotcharts

Given a list of candy bars in a field called Item and their prices in a field called Price on an empty PivotTable, how would you find out how many of each type of candy bar you have?

The ________ area is replaced with the AXIS (CATEGORY)in PivotChart task pane.

What field is in the ROWS area of the PivotTable that built this PivotChart?

A PivotChart ________.

Auto Outline creates an outline based on the data structure.

Which of the following is true about creating a blank PivotTable?

________ is the process of analyzing large amounts of data to identify trends and patterns in the data.

Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function?

Which option would clear a PivotTable filter on a State field?

You would like to see both average sales and total sales for a category in a pivot table.Which of these would best accomplish both a Total and an Average column on the field Sales?

A(n)________ associates matching fields between 2 tables.

A calculated field must be built in the original data set.

What does applying a banded row format do to a Pivot Table?

A primary benefit of creating a PivotTable is that you can rearrange or ________ fields to view and summarize data from different perspectives.

Which is not true about Slicers?

What does a + button indicate to the left of a row heading in an outline?

A PivotChart has live updates as you change the PivotTable.

Grouping is ________.

A(n)________ is a collection of related tables forming a database.