Question 1

Which of the following is the path to the Name Manager button?

Accepted Answer

A)  (FORMULAS tab | Function Library group) 
B)  (FORMULAS tab | Defined Names group) 
C)  (FORMULAS tab | Names group) 
D)  (FORMULAS tab | Calculation group)

Question 2

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

Question 3

You can define descriptive names that are not column titles or row titles to represent cells,ranges of cells,formulas,or constants._________________________

Accepted Answer

A) True 
 B)False

Question 4

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

Question 5

You should create worksheets as if you are going to use them only once.

Accepted Answer

A) True 
 B)False

Question 6

The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed copy or when previewed.

Accepted Answer

A) True 
 B)False

Question 7

A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.

Accepted Answer

A)  Print titles 
B)  Black and white 
C)  Gridlines 
D)  Draft quality

Question 8

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

Question 9

In the Varying Interest Rate Schedule created in this chapter,the series of interest rates in column B are called ____________________.

Accepted Answer

The answer of In the Varying Interest Rate Schedule created...

Question 10

The PMT function has two arguments: rate and payment.

Accepted Answer

A) True 
 B)False

Question 11

The first step in protecting a worksheet is to select the cells you want to leave unprotected and then change their cell protection settings to a(n)____________________ status.

Accepted Answer

The answer of The first step in protecting a worksheet...

Question 12

To include additional formulas in a one-input data table,enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following are PMT function arguments?

Accepted Answer

A) formula name 
B) monthly interest rate 
C) number of payments 
D) loan amount

Question 14

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

Question 15

Bill has a bicycle repair shop in his basement. He would like a larger workshop so he investigates taking out a loan to convert his garage to a workshop. He uses Excel to create an amortization schedule.
-After Bill creates the amortization schedule,he decides to add a calculator section to the worksheet.How would he create a column border to separate the calculator from the amortization schedule section?

Accepted Answer

A)  add two different background colors to the edge of each section column 
B)  add two different background colors to the edge of each section row 
C)  reduce the height of an adjacent empty row 
D)  reduce the width of the adjacent empty columns

Question 16

Periods and underscore characters are allowed in,but cannot begin,cell ____________________.

Accepted Answer

The answer of Periods and underscore characters are allowed in,but...

Question 17

You should protect cells only after the ____________________ has been tested fully and the correct results appear.

Accepted Answer

The answer of You should protect cells only after the...

Question 18

Which of the following is the path to the Protect Sheet button?

Accepted Answer

A)  (VIEW tab | Protect Sheet group) 
B)  (HOME tab | Protection group) 
C)  (REVIEW tab | Changes group) 
D)  (VIEW tab | Protect group)

Question 19

In a data table,the ____________________ you are analyzing must include a cell reference to the input cell.

Accepted Answer

The answer of In a data table,the ____________________ you are...

Question 20

When you format a cell to display percentages,Excel assumes that whatever you enter into that cell in the future will be a percentage.

Accepted Answer

A) True 
 B)False

Exam 4: Financial Functions,Data Tables,and Amortization Schedules

Which of the following is the path to the Name Manager button?

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

You can define descriptive names that are not column titles or row titles to represent cells,ranges of cells,formulas,or constants._________________________

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.

You should create worksheets as if you are going to use them only once.

The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed copy or when previewed.

A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.

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

In the Varying Interest Rate Schedule created in this chapter,the series of interest rates in column B are called ____________________.

The PMT function has two arguments: rate and payment.

The first step in protecting a worksheet is to select the cells you want to leave unprotected and then change their cell protection settings to a(n)____________________ status.

To include additional formulas in a one-input data table,enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

Which of the following are PMT function arguments?

You can name a range by ____.

Periods and underscore characters are allowed in,but cannot begin,cell ____________________.

You should protect cells only after the ____________________ has been tested fully and the correct results appear.

Which of the following is the path to the Protect Sheet button?

In a data table,the ____________________ you are analyzing must include a cell reference to the input cell.

When you format a cell to display percentages,Excel assumes that whatever you enter into that cell in the future will be a percentage.