Chapter 4

Question 1

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

Answer 1

range

Question 2

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

Answer 2

name

Question 3

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

Answer 3

draft quality

Question 4

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.

Answer 4

amortization schedule

Question 5

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

Answer 5

Borders

Question 6

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

Answer 6

unused

Question 7

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.

Answer 7

Trace error button

Question 8

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

Answer 8

unprotected

Question 9

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

Answer 9

background formula checking

Question 10

Names are ____ cell references.

Answer 10

absolute

Question 11

Names are ____ to the workbook.

Answer 11

global

Question 12

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

Answer 12

name

Question 13

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

Answer 13

violations

Question 14

The ____ function returns the present value of an annuity.

Answer 14

PV

Question 15

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

Answer 15

brackets

Question 16

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

Answer 16

(Viewtab | Window group)

Question 17

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

Answer 17

Round

Question 18

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

Answer 18

Hide

Question 19

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

Answer 19

CTRL

Question 20

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

Answer 20

(Data tab | Data tools group)

Question 21

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.

Answer 21

green triangle

Question 22

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.

Answer 22

protect

Question 23

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

Answer 23

as many as you want

Question 24

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

Answer 24

(Home tab | Font Group)

Question 25

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

Answer 25

(Home tab | Styles group)

Question 26

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

Answer 26

The formula checker

Question 27

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

Answer 27

Cell protections

Question 28

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

Answer 28

data table

Question 29

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

Answer 29

password

Question 30

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

Answer 30

Sheet

Question 31

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.

Answer 31

page

Question 32

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

Answer 32

Shift

Question 33

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

Answer 33

pressing the delete key

Question 34

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

Answer 34

Formulas

Question 35

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

Answer 35

Format cells

Question 36

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

Answer 36

one-input