Microsoft Excel Chapter 4

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

CTRL

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

FORMULAS tab / Dfined Names group

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

FORMULAS tab / Function Library group

Which of the following is the path to the Borders button

HOME tab / Font group

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

HOME tab / Styles group

The __ function returns the present value of an annuity.

PV

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

PV and FV

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.

Page Layout

To prevent round-off errors, use the _____ function

ROUND

Using the ____ function in Excel can prevent round-off errors.

ROUND

You can double-click a cell with a formula and Excel will use ___ to highight the cells that provide data for the formula.

Range Finder

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

Review tab / changes group

You can move from one unprotected cell to another unprotected cell in a worksheet by using the TAB and ___ keys

SHIFT+TAB

To assign formats to all the cells in all the worksheets in a workbook, click the Select All button, right click a sheet tab, and click ____ on the shortcut menu.

Select All Sheets

If you click the ____ button, 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.

Trace Error

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

View/Window tab/group

A _____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.

amortization schedule

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

as many as you want

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

background formula checking

An amortization schedule shows the ___ of a loan, and the amount of payment that applies to the principal and interest for each year over the life of the loan.

beginning balance and ending balance

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

borders

You use a _____ to automate data analyses

data table

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

format cells

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.

green triangle

The PV function returns the present value of an

investment

Which of the following are PMT function arguments?

monthly interest rate, number of payments and loan amount

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

name

With a ____ data table, you can vary the value in one cell.

one-input

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

protect

You can name a range by

selecting a cell or range, clicking the Define Name button (FORMULAS tab / Define Names group)

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

sheet

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

unhide

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

unprotected

Data tables must be built in an ____ area of a worksheet

unused

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

violations

You can create two kinds of data tables, but data tables have one purpose - to organize the answers to _____ questions.

what-if