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

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

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

The FV function returns the future value of an investment based on periodic,constant payments and a constant interest rate.

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._________________________

You can start over with formatting a range by clicking the Cell Styles button (Home tab | Styles group)and tapping or clicking ____________________ in the Cell Styles gallery.

When you create a new worksheet,all the cells are assigned a(n)____________________ status.

An amortization schedule summarizes loan information over the life of the loan.

An alternative to a one-input data table is a three-input data table.

-In the accompanying figure,the Print area box accepts a name or a ____ to print.

Assigning names to a cell or range of cells allows you to select them quickly.

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

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

If you click the ____,Excel displays a menu; the first item in the menu identifies the error and the remainder of the menu contains commands from which you can choose.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Returns the present value of an investment or annuity.

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

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

Ruth has a home office that she shares with her husband, Barret. She keeps track of her business profits and expenses in several worksheets. -Ruth has fully tested all of the formulas in her worksheet and the correct results appear.Ruth provides a copy of the worksheet file to Barret so he can use it for his business calculations.As a user,Barret can make changes only to certain cells.What did Ruth do to ensure the other cells cannot be altered by user Barret?

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

Rather than manually setting a print area each time you want to print a range,you can ____ the range.

In general,all cells in a worksheet should be ____________________ except those that require an entry by the user of the worksheet.