Excel Module 4

A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.

• dialog box

• amortization schedule

• formula checker

• data table

____ ensures that users do not change values inadvertently that are critical to the worksheet.

• cell protection

• range finder

• formula checker

• data table

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

• The range finder

• The formula checker

• A data table

• An amortization table

You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.

• ALT

• CTRL

• TAB

• SHIFT

Cell names are ____ cell references.

• absolute

• mixed

• relative

• formatted

The ____ function returns the present value of an annuity.

• FV

• PMT

• PV

• PA

Cell ____ can be used to distinguish the different functional parts of a worksheet.

• ranges

• values

• indices

• borders

To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.

• ALT

• SHIFT

• TAB

• CTRL

If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.

• locked

• indexed

• unlocked

• unprotected

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

• password

• authorized user

• manager account

• administrative account