Exam 1 : Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

A(n)________ allows you to summarize and examine data such as analyzing book sales by categories.

To remove a field from a PivotTable,you select it and press Delete.

Changes made to the original worksheet are automatically reflected in the PivotTable.

________ is used to exclude particular categories or values from a PivotTable.

A ________ is used to graphically represent the data in a PivotTable.

To apply an outline to columns,you must ________ the desired columns.

When creating a calculated field in a PivotTable,range names and cell references outside the PivotTable CANNOT be used.

You can use a maximum of ________ numbered button(s)in addition to the + and - buttons to expand and collapse an outline.

You can move a field from one PivotTable area to another by just dragging it.

Which of the following is NOT an area used when creating a PivotTable?

PivotTable styles are located on the ________ tab.

Slicer styles are located on the ________ tab.

You can use subtotals in a dataset to calculate subtotals of groups such as sales of books within a discipline.

Changes made to a PivotChart are automatically reflected in the corresponding PivotTable.

A ________ is a series of buttons that allows users to filter a PivotTable.

To properly have two levels of subtotals,you must subtotal the secondary category first and then add a subtotal for your primary category.