Exam 5: Excell: Financial Functions, Data Tables, and Amortization Schedules Question

To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.

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

Discuss the options for when you can apply formatting to cells.

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

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

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

The ____ function returns the present value of an annuity.

____________________ portions of a workbook lets you show only the parts of the workbook that the user needs to see.

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

If you enter a formula using Point mode and tap and click a cell that has an assigned name, then Excel will insert the name of the cell rather than the cell reference.

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

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

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

To prevent round-off errors, use the ____ function.

Which of the following is the path to the Cell Styles button?

Critical Thinking Questions Case 4-2 Ruth has a home office that she shares with her husband, Barret. She keeps track of her business profits and expenses in several worksheets. Barret decides he wants to unprotect one of the protected cells so he can replace one of the formulas. What did Ruth do to cause an error message to appear when Barret tries to change the protection?

____________________ like the kind shown in the accompanying figure have one purpose: to organize the answers to what-if questions.