Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Invoked by clicking the Error Checking button.

Accepted Answer

A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking 
A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking

Question 2

You should ____________________ all other cells (non data entry) in a worksheet from input by the user of the worksheet.

Accepted Answer

The answer of You should ____________________ all other cells (non...

Question 3

The spell checker examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.

Accepted Answer

A) True 
 B)False

Question 4

If you click the ____, Excel displays a menu; the first item in the menu identifies the error and the remainder of the menu contains commands from which you can choose.

Accepted Answer

A)  cell boundary 
B)  Error Checking button 
C)  fill handle 
D)  Trace Error button 
A)  cell boundary 
B)  Error Checking button 
C)  fill handle 
D)  Trace Error button

Question 5

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A name assigned to a cell or range in one worksheet can be used to reference the cell or range on other worksheets in the same workbook.

Accepted Answer

A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking 
A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking

Question 6

You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.

Accepted Answer

A)  Page 
B)  Sheet 
C)  Margins 
D)  Header/Footer 
A)  Page 
B)  Sheet 
C)  Margins 
D)  Header/Footer

Question 7

You can name a range by ____.

Accepted Answer

A)  selecting a cell or range, typing the name in the Name box, and pressing the ENTER key 
B)  selecting a cell or range, tapping or clicking the Define Name button (FORMULAS tab | Define Names group) 
C)  selecting a cell or range, typing the name in the formula bar, and pressing the ENTER key 
D)  selecting a cell or range, and pressing CTRL+SHIFT+F3 
A)  selecting a cell or range, typing the name in the Name box, and pressing the ENTER key 
B)  selecting a cell or range, tapping or clicking the Define Name button (FORMULAS tab | Define Names group) 
C)  selecting a cell or range, typing the name in the formula bar, and pressing the ENTER key 
D)  selecting a cell or range, and pressing CTRL+SHIFT+F3

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Can be applied to only one formula.

Accepted Answer

A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking 
A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Speeds up printing when it contains a check mark.

Accepted Answer

A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking 
A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking

Question 10

You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected.

Accepted Answer

A)  password 
B)  authorized user 
C)  manager account 
D)  administrative account 
A)  password 
B)  authorized user 
C)  manager account 
D)  administrative account

Question 11

An amortization schedule shows the ____ of a loan, and the amount of payment that applies to the principal and interest for each year over the life of the loan.

Accepted Answer

A)  daily income 
B)  beginning balance 
C)  ending balance 
D)  daily cost 
A)  daily income 
B)  beginning balance 
C)  ending balance 
D)  daily cost

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Can be used to determine the monthly payment for a loan.

Accepted Answer

A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking 
A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Showing only the parts of a worksheet that the user needs to see.

Accepted Answer

A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking 
A) hiding 
B) periods and underscore characters 
C) global 
D) PMT 
E) PV
F)two-input data table
G)ROUND
H)Draft quality check box
I)formula checker
J)background formula checking

Question 14

Discuss the reasons and the two-step process for protecting a worksheet.

Accepted Answer

When building a worksheet for novice use

Question 15

____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.

Accepted Answer

A)  The Range Finder 
B)  The formula checker 
C)  A data table 
D)  An amortization schedule 
A)  The Range Finder 
B)  The formula checker 
C)  A data table 
D)  An amortization schedule

Question 16

To control the color and thickness of a border, Excel requires that you use the Border sheet in the ____________________ dialog box.

Accepted Answer

The answer of To control the color and thickness of...

Question 17

To use a name that consists of two or more words in a formula, you should replace any space with the ____________________ character.

Accepted Answer

The answer of To use a name that consists of...

Question 18

Once you set a print area, Excel will continue to print the specified range, rather than the entire worksheet.

Accepted Answer

A) True 
 B)False

Question 19

Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.

Accepted Answer

A)  repetitiveness 
B)  brevity 
C)  violations 
D)  consistency 
A)  repetitiveness 
B)  brevity 
C)  violations 
D)  consistency

Question 20

With a(n) ____ data table you can vary the value in one cell.

Accepted Answer

A)  one-input 
B)  two-input 
C)  three-input 
D)  unlimited-input 
A)  one-input 
B)  two-input 
C)  three-input 
D)  unlimited-input

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Invoked by clicking the Error Checking button.

You should ____________________ all other cells (non data entry) in a worksheet from input by the user of the worksheet.

The spell checker examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.

If you click the ____, Excel displays a menu; the first item in the menu identifies the error and the remainder of the menu contains commands from which you can choose.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A name assigned to a cell or range in one worksheet can be used to reference the cell or range on other worksheets in the same workbook.

You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.

You can name a range by ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Can be applied to only one formula.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Speeds up printing when it contains a check mark.

You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected.

An amortization schedule shows the ____ of a loan, and the amount of payment that applies to the principal and interest for each year over the life of the loan.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Can be used to determine the monthly payment for a loan.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Showing only the parts of a worksheet that the user needs to see.

Discuss the reasons and the two-step process for protecting a worksheet.

____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.

To control the color and thickness of a border, Excel requires that you use the Border sheet in the ____________________ dialog box.

To use a name that consists of two or more words in a formula, you should replace any space with the ____________________ character.

Once you set a print area, Excel will continue to print the specified range, rather than the entire worksheet.

Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.

With a(n) ____ data table you can vary the value in one cell.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters

Exam 5: Working With Multiple Worksheets and Workbooks

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Invoked by clicking the Error Checking button.

You should ____________________ all other cells (non data entry) in a worksheet from input by the user of the worksheet.

The spell checker examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.

If you click the ____, Excel displays a menu; the first item in the menu identifies the error and the remainder of the menu contains commands from which you can choose.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A name assigned to a cell or range in one worksheet can be used to reference the cell or range on other worksheets in the same workbook.

You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.

You can name a range by ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Can be applied to only one formula.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Speeds up printing when it contains a check mark.

You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected.

An amortization schedule shows the ____ of a loan, and the amount of payment that applies to the principal and interest for each year over the life of the loan.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Can be used to determine the monthly payment for a loan.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Showing only the parts of a worksheet that the user needs to see.

Discuss the reasons and the two-step process for protecting a worksheet.

____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.

To control the color and thickness of a border, Excel requires that you use the Border sheet in the ____________________ dialog box.

To use a name that consists of two or more words in a formula, you should replace any space with the ____________________ character.

Once you set a print area, Excel will continue to print the specified range, rather than the entire worksheet.

Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.

With a(n) ____ data table you can vary the value in one cell.

Essential Concepts and Skills

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters