Question 1

If the worksheet or workbook is saved in PDF format, it can be e-mailed or uploaded to a Web site.

Accepted Answer

A) True 
 B)False

Question 2

Discuss the situations in which you would choose a combination chart and the situations in which you would choose a gauge chart.

Accepted Answer

You would create a combination chart whe

Question 3

You can quickly choose a layout and styles for a selected chart from the Ribbon. Click the ____ tab under Chart Tools on the Ribbon. In the Chart Layouts group, click the chart layout you want to use.

Accepted Answer

A)  Format 
B)  Edit 
C)  Styles 
D)  Design 
A)  Format 
B)  Edit 
C)  Styles 
D)  Design

Question 4

A ____ is a reference in a worksheet that opens another file or page when you click it.

Accepted Answer

A)  hyperlink 
B)  button 
C)  transporter 
D)  pop-up cell 
A)  hyperlink 
B)  button 
C)  transporter 
D)  pop-up cell

Question 5

You can edit macros by working with the code in ____.

Accepted Answer

A)  HTTP 
B)  HTML 
C)  JPS 
D)  VBA 
A)  HTTP 
B)  HTML 
C)  JPS 
D)  VBA

Question 6

Adding data validation to your worksheet cells helps you monitor the accuracy of the data that's being entered.

Accepted Answer

A) True 
 B)False

Question 7

Before you export a workbook, you may want to use the ____ to locate possible hidden and personal information.

Accepted Answer

A)  Property Inspector 
B)  Export Checker 
C)  Document Inspector 
D)  Download Checker 
A)  Property Inspector 
B)  Export Checker 
C)  Document Inspector 
D)  Download Checker

Question 8

A(n) ____________________ is a group of related information in a column or row of a worksheet that is plotted on the chart.

Accepted Answer

The answer of A(n) ____________________ is a group of related...

Question 9

FIGURE EX 9-1   In Figure EX 9-1 above, you need to click the Format button to open the ____ dialog box.

Accepted Answer

A)  Formatting 
B)  Format Cells 
C)  AutoFilter format 
D)  Fill 
A)  Formatting 
B)  Format Cells 
C)  AutoFilter format 
D)  Fill

Question 10

The Data Validation button is found on the ____ tab on the Ribbon.

Accepted Answer

A)  Home 
B)  Data 
C)  Review 
D)  View 
A)  Home 
B)  Data 
C)  Review 
D)  View

Question 11

The SUMIF function will only total data that meets a certain condition.

Accepted Answer

A) True 
 B)False

Question 12

A 3-D reference lists the worksheet range, an exclamation point, and a cell or range.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

Worksheet users frequently need to add long columns or rows of numbers. The ____________________ button, makes this operation simple.

Accepted Answer

The answer of Worksheet users frequently need to add long...

Question 15

You can add emphasis to a cell by placing a(n) ____________________ (or line) around its edges.

Accepted Answer

The answer of You can add emphasis to a cell...

Question 16

Case EX 11-2 Sharon has a large collection of books at her home and she has catalogued them and stored that information in a worksheet titled Books in a workbook that also contains other worksheets. Sharon wants to make sure that whenever she enters the information for a new book in her worksheet, it is entered in the correct format and as accurately as possible. She needs to use the ____ feature.

Accepted Answer

A)  Subtotal 
B)  Data Validation 
C)  Watch Window 
D)  Data Checking 
A)  Subtotal 
B)  Data Validation 
C)  Watch Window 
D)  Data Checking

Question 17

If data is formatted with different font or fill colors, you can sort the data by color.

Accepted Answer

A) True 
 B)False

Question 18

When Track Changes is enabled, cells that have been changed appear with a(n) ____.

Accepted Answer

A)  shadow 
B)  information icon 
C)  border 
D)  error message 
A)  shadow 
B)  information icon 
C)  border 
D)  error message

Question 19

FIGURE EX 7-1   The area indicated by #1 in Figure EX 7-1 above is ____.

Accepted Answer

A)  Sheet tabs for the inactive worksheets 
B)  Sheet tabs for the active worksheets 
C)  Tab scrolling buttons 
D)  Custom sheet tabs 
A)  Sheet tabs for the inactive worksheets 
B)  Sheet tabs for the active worksheets 
C)  Tab scrolling buttons 
D)  Custom sheet tabs

Question 20

In a shared workbook, changes are marked with a border as they are when the Track Changes feature is used.

Accepted Answer

A) True 
 B)False

If the worksheet or workbook is saved in PDF format, it can be e-mailed or uploaded to a Web site.

Discuss the situations in which you would choose a combination chart and the situations in which you would choose a gauge chart.

You can quickly choose a layout and styles for a selected chart from the Ribbon. Click the ____ tab under Chart Tools on the Ribbon. In the Chart Layouts group, click the chart layout you want to use.

A ____ is a reference in a worksheet that opens another file or page when you click it.

You can edit macros by working with the code in ____.

Adding data validation to your worksheet cells helps you monitor the accuracy of the data that's being entered.

Before you export a workbook, you may want to use the ____ to locate possible hidden and personal information.

A(n) ____________________ is a group of related information in a column or row of a worksheet that is plotted on the chart.

FIGURE EX 9-1 In Figure EX 9-1 above, you need to click the Format button to open the ____ dialog box.

The Data Validation button is found on the ____ tab on the Ribbon.

The SUMIF function will only total data that meets a certain condition.

A 3-D reference lists the worksheet range, an exclamation point, and a cell or range.

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

Worksheet users frequently need to add long columns or rows of numbers. The ____________________ button, makes this operation simple.

You can add emphasis to a cell by placing a(n) ____________________ (or line) around its edges.

If data is formatted with different font or fill colors, you can sort the data by color.

When Track Changes is enabled, cells that have been changed appear with a(n) ____.

FIGURE EX 7-1 The area indicated by #1 in Figure EX 7-1 above is ____.

In a shared workbook, changes are marked with a border as they are when the Track Changes feature is used.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

If the worksheet or workbook is saved in PDF format, it can be e-mailed or uploaded to a Web site.

Discuss the situations in which you would choose a combination chart and the situations in which you would choose a gauge chart.

You can quickly choose a layout and styles for a selected chart from the Ribbon. Click the ____ tab under Chart Tools on the Ribbon. In the Chart Layouts group, click the chart layout you want to use.

A ____ is a reference in a worksheet that opens another file or page when you click it.

You can edit macros by working with the code in ____.

Adding data validation to your worksheet cells helps you monitor the accuracy of the data that's being entered.

Before you export a workbook, you may want to use the ____ to locate possible hidden and personal information.

A(n) ____________________ is a group of related information in a column or row of a worksheet that is plotted on the chart.

FIGURE EX 9-1 In Figure EX 9-1 above, you need to click the Format button to open the ____ dialog box.

The Data Validation button is found on the ____ tab on the Ribbon.

The SUMIF function will only total data that meets a certain condition.

A 3-D reference lists the worksheet range, an exclamation point, and a cell or range.

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

Worksheet users frequently need to add long columns or rows of numbers. The ____________________ button, makes this operation simple.

You can add emphasis to a cell by placing a(n) ____________________ (or line) around its edges.

If data is formatted with different font or fill colors, you can sort the data by color.

When Track Changes is enabled, cells that have been changed appear with a(n) ____.

FIGURE EX 7-1 The area indicated by #1 in Figure EX 7-1 above is ____.

In a shared workbook, changes are marked with a border as they are when the Track Changes feature is used.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters