Exam 18: Creating Pivottables and Pivotcharts

FIGURE EX 12-1 Item 1 in Figure EX 12-1 above shows a ____.

If you do not want the slicer to print, you can right-click it and choose ____ from the shortcut menu.

What is the relationship, in terms of the data, between a PivotTable and a PivotChart created from the PivotTable?

A PivotTable lets you twist or rearrange the data.

After you create the PivotTable, you can continue to rearrange the data.

Case EX 12-2 Joey has created a PivotTable that contains the financial data for his restaurant. If Joey wants to change the location of rows and columns in the PivotTable, he needs to use the ____ dialog box.

If a change is made to the PivotTable, the associated PivotChart changes as well.

Clicking selections on the ____ lets you filter your data in a PivotTable.

Each field (column of data) in a PivotTable can have its own PivotChart to filter data for the column.

The slicer includes ____ that you click to filter data in a PivotTable.

The Refresh button is located in the Data group on the ____ tab.

In a PivotTable, you can quickly change the format and calculation by redisplaying the ____________________ list and selecting another option.

When an item is highlighted in the ____, only the data for that item is displayed.

When there is more than one level in a PivotTable, the level of detail below the main row heading is called the ____________________.

The data that you choose to create a PivotTable needs to have ____.

If the data used to create a PivotTable is changed, click the ____ button to update the PivotTable to reflect this change.

PivotChart filters are located ____.

After you sort or filter the data, a graphic, like a ScreenTip, appears when you place your mouse pointer over the Column Labels and Row Labels down arrows.

The PivotTable and PivotChart are ____.

A ____ lets you rearrange worksheet data so you can analyze it in a variety of ways.