Question 1

Adding a ____ allows you to set parameters for worksheet cells where values will be entered.

Accepted Answer

A)  guideline 
B)  validation rule 
C)  validation text 
D)  check list 
A)  guideline 
B)  validation rule 
C)  validation text 
D)  check list

Question 2

Adding data labels allows you to see the value for each data marker in the chart.

Accepted Answer

A) True 
 B)False

Question 3

The y-axis on the left side of a combination chart is called the secondary axis.

Accepted Answer

A) True 
 B)False

Question 4

You can create a PivotChart to graphically display a PivotTable.

Accepted Answer

A) True 
 B)False

Question 5

FIGURE EX 9-1   The dialog box in Figure EX 9-1 above allows you to use a formula to apply ____.

Accepted Answer

A)  filtering 
B)  trace formatting 
C)  banding 
D)  conditional formatting 
A)  filtering 
B)  trace formatting 
C)  banding 
D)  conditional formatting

Question 6

When formatting tables, you should be sure that there are no blank columns or rows .

Accepted Answer

A) True 
 B)False

Question 7

Format codes are simply strings of characters that represent the actual data.

Accepted Answer

A) True 
 B)False

Question 8

To filter for number data that is not already defined in the Number Filters menu, create a ____.

Accepted Answer

A)  UserFilter 
B)  CustomFilter 
C)  custom AutoFilter 
D)  secondary AutoFilter 
A)  UserFilter 
B)  CustomFilter 
C)  custom AutoFilter 
D)  secondary AutoFilter

Question 9

In a worksheet range, as in a cell range, a ____ separates the names of the first worksheet and the last worksheet in the group.

Accepted Answer

A)  period 
B)  colon 
C)  comma 
D)  semicolon 
A)  period 
B)  colon 
C)  comma 
D)  semicolon

Question 10

To unhide a worksheet, right-click any sheet tab, and then click Unhide on the shortcut menu.

Accepted Answer

A) True 
 B)False

Question 11

The easiest way to change the active cell in a worksheet is to click Cell on the Ribbon and type in the cell's location.

Accepted Answer

A) True 
 B)False

Question 12

After you copy and paste, the ____ button appears next to the cell or range with the pasted item.

Accepted Answer

A)  Paste Parameters 
B)  Paste Format 
C)  Paste Options 
D)  Paste Selection 
A)  Paste Parameters 
B)  Paste Format 
C)  Paste Options 
D)  Paste Selection

Question 13

The ____ feature quickly calculates subtotals and grand totals, but they can be removed when you're finished viewing or printing the data.

Accepted Answer

A)  Reporting 
B)  Formulas 
C)  Temp View 
D)  Subtotal 
A)  Reporting 
B)  Formulas 
C)  Temp View 
D)  Subtotal

Question 14

The Charts group, which allows you to create a chart, is found on the Insert tab on the Ribbon.

Accepted Answer

A) True 
 B)False

Question 15

You can create hyperlinks to ____.

Accepted Answer

A)  another Web page 
B)  a specific location in the current workbook 
C)  an e-mail address 
D)  all of the above 
A)  another Web page 
B)  a specific location in the current workbook 
C)  an e-mail address 
D)  all of the above

Question 16

Press the Ctrl+B keys to apply bold.

Accepted Answer

A) True 
 B)False

Question 17

Case EX 1-1 Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking. When Nicole moves the pointer to a button on the Ribbon, the pointer changes to a ____.

Accepted Answer

A)  white arrow 
B)  thick white plus sign 
C)  black arrow 
D)  thick black plus sign 
A)  white arrow 
B)  thick white plus sign 
C)  black arrow 
D)  thick black plus sign

Question 18

You can use a shortcut key combination to run a macro.

Accepted Answer

A) True 
 B)False

Question 19

If you discover that you need to make a correction, you can edit the formula. Click the cell with the formula you want to edit. Press the ____ or double-click the cell to enter editing mode.

Accepted Answer

A)  F1 
B)  F2 
C)  F3 
D)  F4 
A)  F1 
B)  F2 
C)  F3 
D)  F4

Question 20

In the Document Inspector dialog box, you can add and remove check marks in order to define what you would like to search for with the Document Inspector.

Accepted Answer

A) True 
 B)False

Adding a ____ allows you to set parameters for worksheet cells where values will be entered.

Adding data labels allows you to see the value for each data marker in the chart.

The y-axis on the left side of a combination chart is called the secondary axis.

You can create a PivotChart to graphically display a PivotTable.

FIGURE EX 9-1 The dialog box in Figure EX 9-1 above allows you to use a formula to apply ____.

When formatting tables, you should be sure that there are no blank columns or rows .

Format codes are simply strings of characters that represent the actual data.

To filter for number data that is not already defined in the Number Filters menu, create a ____.

In a worksheet range, as in a cell range, a ____ separates the names of the first worksheet and the last worksheet in the group.

To unhide a worksheet, right-click any sheet tab, and then click Unhide on the shortcut menu.

The easiest way to change the active cell in a worksheet is to click Cell on the Ribbon and type in the cell's location.

After you copy and paste, the ____ button appears next to the cell or range with the pasted item.

The ____ feature quickly calculates subtotals and grand totals, but they can be removed when you're finished viewing or printing the data.

The Charts group, which allows you to create a chart, is found on the Insert tab on the Ribbon.

You can create hyperlinks to ____.

Press the Ctrl+B keys to apply bold.

Case EX 1-1 Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking. When Nicole moves the pointer to a button on the Ribbon, the pointer changes to a ____.

You can use a shortcut key combination to run a macro.

If you discover that you need to make a correction, you can edit the formula. Click the cell with the formula you want to edit. Press the ____ or double-click the cell to enter editing mode.

In the Document Inspector dialog box, you can add and remove check marks in order to define what you would like to search for with the Document Inspector.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

Adding a ____ allows you to set parameters for worksheet cells where values will be entered.

Adding data labels allows you to see the value for each data marker in the chart.

The y-axis on the left side of a combination chart is called the secondary axis.

You can create a PivotChart to graphically display a PivotTable.

FIGURE EX 9-1 The dialog box in Figure EX 9-1 above allows you to use a formula to apply ____.

When formatting tables, you should be sure that there are no blank columns or rows .

Format codes are simply strings of characters that represent the actual data.

To filter for number data that is not already defined in the Number Filters menu, create a ____.

In a worksheet range, as in a cell range, a ____ separates the names of the first worksheet and the last worksheet in the group.

To unhide a worksheet, right-click any sheet tab, and then click Unhide on the shortcut menu.

The easiest way to change the active cell in a worksheet is to click Cell on the Ribbon and type in the cell's location.

After you copy and paste, the ____ button appears next to the cell or range with the pasted item.

The ____ feature quickly calculates subtotals and grand totals, but they can be removed when you're finished viewing or printing the data.

The Charts group, which allows you to create a chart, is found on the Insert tab on the Ribbon.

You can create hyperlinks to ____.

Press the Ctrl+B keys to apply bold.

Case EX 1-1 Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking. When Nicole moves the pointer to a button on the Ribbon, the pointer changes to a ____.

You can use a shortcut key combination to run a macro.

If you discover that you need to make a correction, you can edit the formula. Click the cell with the formula you want to edit. Press the ____ or double-click the cell to enter editing mode.

In the Document Inspector dialog box, you can add and remove check marks in order to define what you would like to search for with the Document Inspector.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters