Exam 15: Financial Functions, Data Tables, and Amortization Schedules Question

Which of the following is the path to the Borders button?

You can use ____________________ to separate sections of a worksheet.

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

You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.

Discuss the reasons and the two-step process for protecting a worksheet.

Periods and underssare characters are allowed in, but cannot begin, cell ____________________.

In a process called ____, Excel santinually reviews the workbook for errors in formulas as you create or manipulate it.

The ____ function returns the present value of an annuity.

To hide an entire workbook on an unattended samputer, click the Hide button on the ____.

Names are ____ to the workbook.

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

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

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

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

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.

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

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

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

You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.

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