Exam 5: Working With Multiple Worksheets and Workbooks

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

In the Varying Interest Rate Schedule created in this chapter, the series of interest rates in column B are called ____________________.

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

Which of the following is the path to the Financial button and the PMT function?

The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed copy or when previewed.

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

Which of the following is the path to the Protect Sheet button?

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

You can add only a maximum of five conditional formats to a range.

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

When you format a cell to display percentages, Excel assumes that whatever you enter into that cell in the future will be a percentage. Thus, if you enter the number .5, Excel translates the value as ____________________.

When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ____ in the upper-left corner of the cell assigned the formula.

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

What is the path to the What-If Analysis button?

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 should create a(n) ____________________ when you want to keep others from changing the worksheet from protected to unprotected.

Spreadsheet specialists usually format a worksheet before they enter any data.

You should protect cells only after the ____________________ has been tested fully and the correct results appear.

The first step in protecting a worksheet is to select the cells you want to leave unprotected and then change their cell protection settings to a(n) ____________________ status.

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