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

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

Names are ____ cell references.

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

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

Excel is case sensitive with respect to names of cells.

The ____ function returns the present value of an annuity.

You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.

Which of the following functions have these three arguments: rate,periods,payment?

A(n)index is a series of fixed payments made at the end of each of a fixed number of periods at a fixed interest rate._________________________

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

Which of the following are PMT function arguments?

You cannot use column and row titles within formulas when you want to refer to the related data by name.

Data tables must be built in a(n)____ area of a worksheet.

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

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

Smart worksheet design starts with visualizing the results you need._________________________

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

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.

The best alternative to define the formulas in a data table involves using the cell references preceded by an equal sign.

You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.