Question 1

Match between columns
                        Premises: Anything that appears on the screen that you can select and work with as a whole.

Accepted Answer

The Answer of Sort and Comment and Conditional formatting and is...

Question 2

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

Accepted Answer

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

Question 3

Match between columns
                        Premises: Highlights worksheet data by changing the look of cells that meet a specified condition.

Accepted Answer

The Answer of Object and Filtering and Sort and Conditional is...

Question 4

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

Accepted Answer

The answer of You can choose a style for the...

Question 5

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

Slicer is a tool in Excel that allows you to filter data in a PivotTable or PivotChart. When you highlight a particular item in the slicer, only the data for that item is displayed. The Watch Window is used to monitor specific cells in a workbook. PivotChart is a chart that is based on a PivotTable. Designer is not a feature in Excel.

Question 6

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

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

Question 7

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

Accepted Answer

The answer of In a PivotTable, you can quickly change...

Question 8

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 9

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

Clicking on the minus sign will collapse the data and hide some of it, while clicking on the plus sign will expand the data and show more details. The pound sign and number sign are not related to PivotTable functionality.

Question 10

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 PivotTable Field List dialog box allows users to drag and drop fields to different areas of the PivotTable, such as rows, columns, values, and filters, enabling them to change the layout and arrangement of the data.

Question 11

Match between columns
                        Premises: A note attached to a cell that is usually used to explain or identify information contained in the cell.

Accepted Answer

The Answer of Comment and Object and Sort and Conditional is...

Question 12

Match between columns
                        Premises: Rearranging the data in a more meaningful order.

Accepted Answer

The Answer of Comment and Sort and Filtering and Conditional is...

Question 13

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

Accepted Answer

The answer of When there is more than one level...

Question 14

Match between columns
                        Premises: Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria.

Accepted Answer

The Answer of Sort and Conditional formatting and Comment and is...

Question 15

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

Accepted Answer

A slicer acts like a filter but is easier to use because it provides a visual way to filter data in a PivotTable or PivotChart.

Question 16

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

Jaime can filter the results using the "Shipped" column to only display orders that have not been shipped yet. This will allow him to easily see which orders need to be fulfilled. A pivot table/chart allows you to filter data based on certain criteria.

Question 17

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

Accepted Answer

The answer of When there is more than one level...

Question 18

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

PivotTable allows Jaime to easily rearrange and summarize the data in different ways, such as by bag type or by customer location. It also allows him to filter the data based on the shipped status or other criteria. Cluster chart is not applicable in this case as it is a visual tool used to display data in groups or clusters. Slicer is also not applicable as it is a filtering tool used in PivotTables and PivotCharts. Watch Window is not applicable as it is a tool used to monitor specific cells or formulas in a workbook.

Question 19

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

Accepted Answer

The answer of What is the relationship, in terms of...

Question 20

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...

Quiz 2: Microsoft Excel Basics

Identify the letter of the choice that best matches the phrase or definition.

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

Identify the letter of the choice that best matches the phrase or definition.

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

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

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

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

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

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.

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.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

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

Identify the letter of the choice that best matches the phrase or definition.

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

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

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

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