Deck 18: Creating Pivottables and Pivotcharts

Question 1

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.

Answer 1

True

Question 2

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

A) sparklines
B) charts
C) row headings
D) column headings

Answer 2

D

Question 3

You can create a PivotChart to graphically display a PivotTable.

Answer 3

True

Question 4

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

Question 5

The ____ looks like a free-floating note pad.

A) slicer
B) PivotTable
C) PivotChart
D) sparkline

Question 6

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

A) chart
B) sparkline
C) Watch Window
D) PivotTable

Question 7

A PivotTable lets you twist or rearrange the data.

Question 8

The slicer is professional in appearance, but difficult to use.

Question 9

The sort and filter options are displayed when you click the Column Labels down arrow or the Row Labels down arrow on the PivotChart.

Question 10

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

A) column headings
B) row headings
C) data validation
D) filtering

Question 11

The slicer will print when you print the worksheet .

Question 12

When you create a PivotTable, you need to use all of the data in the worksheet.

Question 13

A PivotTable must be placed on the same worksheet as the data used to create it.

Question 14

The PivotTable button is found on the ____ tab on the Ribbon.

A) Home
B) Insert
C) Page Layout
D) Data

Question 15

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

Question 16

You can filter PivotChart data.

Question 17

Data that is used to create a PivotTable can contain some blank columns or blank rows.

Question 18

When you filter data, the data you want to show is displayed and the rest of the data is hidden.

Question 19

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

Question 20

Numbers will sort lowest to highest in descending order.

Question 21

Case EX 12-2 Joey has created a PivotTable that contains the financial data for his restaurant. If Joey's PivotTable has two levels of fields, he can click on a ____ to hide some of the data.

A) plus sign
B) minus sign
C) pound sign
D) number sign

Question 22

A(n) ____ acts like a filter, but it is easier to use.

A) slicer
B) PivotTable
C) PivotChart
D) axis

Question 23

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.

A) PivotTable Field List
B) Column Type
C) Row Column Slicer
D) PivotTable Arrangement

Question 24

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

A) slicer
B) PivotTable
C) Watch Window
D) ViewTable

Question 25

When you create a PivotChart with worksheet data, a ____ is created at the same time.

A) sparkline
B) slicer
C) PivotTable
D) design studio

Question 26

Case EX 12-1 Jaime loves designing and making hand-made bags and he has started a small business selling his bags over the Internet. To keep track of the orders and their status, he uses a worksheet with the following columns: Order Number, Customer Name, Customer Address, Bag Ordered, and Shipped. Under the Shipped column, Jaime enters "Yes" or "No" based on whether the bag has been shipped or not. If Jaime creates a PivotChart for the data, he can ____ the results so that only the bags that are not shipped yet will be displayed.

A) hide
B) rearrange
C) filter
D) join

Question 27

The PivotTable and PivotChart are ____.

A) linked
B) hidden
C) protected
D) distributed

Question 28

When a PivotChart is selected, additional ____ appear on the Ribbon.

A) designs
B) tabs
C) outlines
D) clusters

Question 29

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

A) slicer
B) PivotTable
C) Watch Window
D) ViewTable

Question 30

When you add levels of fields, ____ buttons appear in the PivotTable so that you can show or hide these levels.

A) Levels
B) Show/Hide
C) Arrange
D) Outline

Question 31

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

A) Data
B) Insert
C) View
D) Options

Question 32

Case EX 12-1 Jaime loves designing and making hand-made bags and he has started a small business selling his bags over the Internet. To keep track of the orders and their status, he uses a worksheet with the following columns: Order Number, Customer Name, Customer Address, Bag Ordered, and Shipped. Under the Shipped column, Jaime enters "Yes" or "No" based on whether the bag has been shipped or not. Jaime wants to be able to easily rearrange and summarize the data and view it in different ways. He needs to use a ____.

A) Cluster chart
B) PivotTable
C) slicer
D) Watch Window

Question 33

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

A) filter
B) slicer
C) Watch Window
D) PivotChart

Question 34

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

A) Watch Window
B) PivotChart
C) slicer
D) designer

Question 35

You can change how the values in a PivotTable are displayed and calculated by using the ____ button.

A) Calculations
B) Display
C) View
D) Arrange

Question 36

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

A) Refresh
B) Update
C) Data
D) View

Question 37

Each PivotChart type (with the exception of pie charts) typically has ____.

A) one axis
B) two axes
C) three axes
D) four axes

Question 38

PivotChart filters are located ____.

A) in the chart
B) outside the chart
C) in the PivotTable
D) in the slicer

Question 39

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

A) Remove
B) Hide
C) Delete
D) Do not print

Question 40

The ____________________ dialog box is used to select the data for creating a PivotTable.

Question 41

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

Question 43

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

Question 44

You can choose a style for the slicer on the ____________________ tab.

Question 45

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

Question 46

When there is more than one level in a PivotTable, the main row heading is referred to as the ____________________.