Ite 140 Ch04

Front 1

You use a(n) _____to automate data analyses.

Back 1

data table

Front 2

A(n)_____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest over a period.

Back 2

amortization schedule

Front 3

_____ ensures that users do notb change values inadvertently that are critical to the worksheet.

Back 3

Cell protection

Front 4

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

Back 4

The formula checker

Front 5

The data _____ section of a worksheet includes data items entered by a user of a worksheet.

Back 5

entry

Front 6

Cell _____ help to set off sections of a worksheet.

Back 6

borders

Front 7

To print individual sections of a worksheet, _____ these sections and then print them by _____.

Back 7

name, name

Front 8

When considering which cells another worksheet user should be able to manipulate, leave the cells _____.

Back 8

unprotected

Front 9

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

Back 9

SHIFT

Front 10

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

Back 10

name

Front 11

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

Back 11

(Home tab | Font group)

Front 12

You can select a cell or range by typing it's _____ in the Name Box and pressing the ENTER key.

Back 12

name

Front 13

Names are _____ cell references.

Back 13

absolute

Front 14

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

Back 14

(Formulas tab | Defined Names group)

Front 15

Names are _____ to the workbook.

Back 15

global

Front 16

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

Back 16

(Formulas tab | Function Library group)

Front 17

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

Back 17

one-input

Front 18

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

Back 18

unused

Front 19

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

Back 19

(Home tab | Editing group)

Front 20

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

Back 20

(Data tab | Data Tools group)

Front 21

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

Back 21

As many as you want

Front 22

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

Back 22

pressing the DELETE key

Front 23

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

Back 23

(Home tab | Styles group)

Front 24

The _____ function returns the present value of an annuity.

Back 24

PV

Front 25

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

Back 25

ROUND

Front 26

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.

Back 26

Page

Front 27

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

Back 27

Sheet

Front 28

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

Back 28

Draft quality

Front 29

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

Back 29

name

Front 30

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.

Back 30

protect

Front 31

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

Back 31

password

Front 32

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

Back 32

Hide

Front 33

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

Back 33

(View tab | Window group)

Front 34

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

Back 34

background formula checking

Front 35

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

Back 35

formula checker

Front 36

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.

Back 36

green triangle