When a workbook is protected, you can still _____.

Answer:

A.

delete worksheets

B.

save the workbook

C.

rename worksheet tabs

D.	move worksheets

Which statement about locking and unlocking cells is true?

Answer:

A.

A cell that has been locked cannot be unlocked.

B.

You cannot lock or unlock a range of cells simultaneously.

C.

Worksheet protection is not required to prevent users from unlocking cells.

D.	All worksheet cells are locked by default.

By default, what does Excel allow users to do in a protected worksheet?

Answer:

A.

Format cells

B.

Select locked cells

C.

Insert rows

D.	Delete columns

What information is not necessary to a bond amortization schedule?

Answer:

A.

Face value

B.

Life of the bond

C.

Frequency of interest payments

D.	Total value of other bonds issued by the company

What two arguments are required for the PMT, PV, and FV functions?

Answer:

A.

Rate and periods

B.

Payment and type

C.

Future value and rate

D.	Type and present value

A bond sold for more than its face value is said to have been sold at _____.

Answer:

A.

a premium

B.

a discount

C.

par

D.

a profit