Excel: Module 4 Test

You use a(n) ____ to automate data analyses.

• data table

• formula checker

• amortization table

• IF Function

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 table

• formula checker

• data table

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

• Cell protection

• Range Finder

• The formula checker

• A 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 schedule

Names are ____ to the workbook.

• national

• international

• global

• inclusive

Names are ____ cell references.

• absolute

• mixed

• relative

• formatted

The arguments in ____ in the ScreenTip for a function are optional.

• brackets

• braces

• parentheses

• quotation marks

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

• one-input

• two-input

• three-input

• unlimited-input

Which of the following is the maximum number of active data tables per worksheet?

• 5

• 20

• 50

• As many as you want

The ____ function returns the present value of an annuity.

• FV

• PMT

• PV

• VDB