CIS Chapter 4

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

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.

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

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

You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.

A cell ____ often is created from column or row titles.

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

Names are ____ to the workbook.

Names are ____ cell references.

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

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

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

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

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

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

Which of the following is the maximum number of active data tables per worksheet?

You can delete a data table by selecting the data table and then ____.

The ____ function returns the present value of an annuity.

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

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

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

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

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

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.

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

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

A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.

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

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

If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.

When building a worksheet for novice users, you should ____ the cells in the worksheet that you do not want changed, such as cells that contain text or formulas.

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

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

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

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

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

Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.

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.

You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.

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.

Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions.

You should create worksheets as if you are going to use them only once.

A cell name often is created from column and row titles.

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

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

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

When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.

When you format a cell to display percentages, Excel assumes that whatever you enter into that cell in the future will be a percentage.

Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.

Excel is case sensitive with respect to names of cells.

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.

The PMT function has two arguments: rate and payment.

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

You can double-tap or double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula.

When Range Finder is active, you can drag the outlines from one cell to another cell to change the cells referenced in the formula, provided the cells have not been named.

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

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

To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.

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

A column border is an unused column with a significantly reduced width.

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

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

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.

A name cannot be assigned to two or more nonadjacent ranges.

Once you set a print area, Excel will continue to print the specified range, rather than the entire worksheet.

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

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

Excel lets you format ____________________ before you enter data, when you enter data, incrementally after entering sections of data, and after you enter all the data.

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

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.