Question 1

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

Accepted Answer

The minus sign is used to collapse or hide a particular level of data in a PivotTable with two or more levels of fields. Clicking on the minus sign will collapse the data for a particular field and show only the subtotals or totals for that field.

Question 2

A(n) ____ acts like a filter, but it is easier to use.
A) slicer
B) PivotTable
C) PivotChart
D) axis

Accepted Answer

The answer of A(n) ____ acts like a filter, but...

Question 3

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

Accepted Answer

The answer of Case EX 12-2 Joey has created a...

Question 4

FIGURE EX 12-1  Item 2 in Figure EX 12-1 above shows a ____.
A) slicer
B) PivotTable
C) Watch Window
D) ViewTable

Accepted Answer

The answer of FIGURE EX 12-1  Item 2 in...

Question 5

When you create a PivotChart with worksheet data, a ____ is created at the same time.
A) sparkline
B) slicer
C) PivotTable
D) design studio

Accepted Answer

When you create a PivotChart with worksheet data, a PivotTable is created at the same time. The PivotTable provides the data source for the PivotChart.

Question 6

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

Accepted Answer

Filtering allows Jaime to only display the bags that have not been shipped yet, making it easier for him to keep track of his orders. The other options (hiding, rearranging, joining) do not specifically address the need to display only certain data based on a criteria.

Question 7

The PivotTable and PivotChart are ____.
A) linked
B) hidden
C) protected
D) distributed

Accepted Answer

The PivotTable and PivotChart are linked, as the PivotTable serves as the source data for the PivotChart. Any changes made in the PivotTable will be reflected in the PivotChart.

Question 8

When a PivotChart is selected, additional ____ appear on the Ribbon.
A) designs
B) tabs
C) outlines
D) clusters

Accepted Answer

When a PivotChart is selected, additional tabs appear on the Ribbon. These tabs include the Analyze and Design tabs, which allow for further customization and analysis of the PivotChart.

Question 9

FIGURE EX 12-1  Item 1 in Figure EX 12-1 above shows a ____.
A) slicer
B) PivotTable
C) Watch Window
D) ViewTable

Accepted Answer

Item 1 in Figure EX 12-1 is a PivotTable.

Question 10

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

Accepted Answer

The answer of When you add levels of fields, ____...

Question 11

The Refresh button is located in the Data group on the ____ tab.
A) Data
B) Insert
C) View
D) Options

Accepted Answer

The answer of The Refresh button is located in the...

Question 12

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

Accepted Answer

Jaime needs to use a PivotTable to easily rearrange and summarize the data and view it in different ways. A Cluster chart is used to display data in groups, a slicer is used to filter data, and a Watch Window is used to monitor the value of specific cells. None of these options meet Jaime's needs as well as a PivotTable.

Question 13

Clicking selections on the ____ lets you filter your data in a PivotTable.
A) filter
B) slicer
C) Watch Window
D) PivotChart

Accepted Answer

Slicers are used to filter data in a PivotTable by clicking on the desired criteria. The Filter option refers to the overall filtering of data in a PivotTable, which includes slicers and other filtering options. The Watch Window and PivotChart do not relate to filtering data in a PivotTable.

Question 14

When an item is highlighted in the ____, only the data for that item is displayed.
A) Watch Window
B) PivotChart
C) slicer
D) designer

Accepted Answer

When a user interacts with a slicer, only data corresponding to the selected value(s) is displayed, making it easy to analyze subsets of data quickly.

Question 15

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

Accepted Answer

The Calculations button allows you to change how the values in a PivotTable are calculated, such as applying different mathematical operations or displaying percentages instead of actual numbers. The other options listed (Display, View, and Arrange) do not offer the same level of control over the values in the PivotTable.

Question 16

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

Accepted Answer

The Refresh button is used to update a PivotTable when the underlying data has been changed. This ensures that the PivotTable reflects the most current information available.

Question 17

Each PivotChart type (with the exception of pie charts) typically has ____.
A) one axis
B) two axes
C) three axes
D) four axes

Accepted Answer

PivotCharts, except for pie charts, typically have two axes. One axis is for categories and the other is for the numerical values.

Question 18

PivotChart filters are located ____.
A) in the chart
B) outside the chart
C) in the PivotTable
D) in the slicer

Accepted Answer

The answer of PivotChart filters are located ____.
A) in the...

Question 19

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

Accepted Answer

The answer of If you do not want the slicer...

Question 20

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

Accepted Answer

The answer of The ____________________ dialog box is used to...

Quiz 18: Creating Pivottables and Pivotcharts

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(n) ____ acts like a filter, but it is easier to use.

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.

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

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

The PivotTable and PivotChart are ____.

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

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

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

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

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

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

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

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

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

PivotChart filters are located ____.

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

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