Question 1

Numbers will sort lowest to highest in descending order.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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.

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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 6

The slicer will print when you print the worksheet .

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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 9

You can create a PivotChart to graphically display a PivotTable.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The ____ looks like a free-floating note pad.

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Match between columns
                        Premises: Usually plots the categories along the bottom of the chart.
A visual representation of the data in a PivotTable.
A visual control that looks like a note pad.
A structure in which the data can be rearranged and summarized in different ways so that you can view the data from various perspectives.
Usually plots values, such as dollar amounts, along the left side of the chart.

Accepted Answer

The Answer of slicer and horizontal axis and vertical axis is...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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.

Accepted Answer

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

Question 18

You can filter PivotChart data.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

Exam 18: Creating Pivottables and Pivotcharts

Numbers will sort lowest to highest in descending order.

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

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.

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

The slicer will print when you print the worksheet .

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

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

You can create a PivotChart to graphically display a PivotTable.

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

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

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

The ____ looks like a free-floating note pad.

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

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

You can filter PivotChart data.

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

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

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters