Quiz 10

Question 1

Locking cells or hiding formulas has no effect unless the worksheet is protected.

Answer 1

True

Question 2

The Circle Invalid Data button circles cells that _____.

Answer 2

don’t meet their data validation criteria

Question 3

The name of a macro can contain letters, numbers, spaces, and the underscore symbol.

Answer 3

False

Question 4

You can try to prevent an inexperienced Excel user from “messing up” a workbook by _____.

Answer 4

hiding cells so that users cannot see them

locking cells so that users cannot change their contents

specifying which actions users can perform

Question 5

By changing the Error Checking Rules, you can specify that Excel will alert you about the following: _____.

Answer 5

Cells containing years represented as 2 digits

Formulas which omit cells in a region

Unlocked cells containing formulas

Question 6

A(n) _____ cell uses the value in the active cell in its formula.

Answer 6

dependent

Question 7

A(n) _____ cell contains a value that is used in a formula.

Answer 7

precedent

Question 8

A validation rule can specify _____.

Answer 8

values, such as those between 1 and 100

decimal numbers

dates

Question 9

Use the _____ button on the Formula Auditing toolbar to keep track of cell properties such as name, value, and formula, even if the cell is out of view.

Answer 9

Watch Window

Question 10

_____ are items that are, in fact, incorrect, but are not flagged as such.

Answer 10

False negatives

Question 11

_____ prevents changing, moving, or deleting data.

Answer 11

Worksheet protection

Question 12

The data validation default (list box) option is _____.

Answer 12

any value

Question 13

A _____ specifies the type of data that is appropriate/allowed as content in a cell (…for example, whole numbers, decimal numbers, dates, time, or text).

Answer 13

validation rule

Question 14

After summing cell to calculate total income, an error message of ########## is shown in one of your cells. What does this indicate?

Answer 14

the cell is too small to display the contents

Question 15

The Error Alert Style of _____ indicates the entry does not conform to the data validation rules, and can be canceled, corrected, or accepted.

Answer 15

Warning

Question 16

Use the _____ button on the Formula Auditing toolbar to display tracer arrows that indicate which cells the formula references.

Answer 16

Trace Precedents

Question 17

_____ prevents inserting, deleting, or renaming worksheets.

Answer 17

Workbook protection

Question 18

A _____ is a note that you attach to a cell, separate from other cell content.

Answer 18

comment

Question 19

To unlock cells in a protected workbook, click the Locked box to remove the check mark on the Protection tab of the __________.

Answer 19

Format Cells menu/window

Question 20

The data validation tool restricts the _____.

Answer 20

data being entered

Question 21

To display tracer arrows that indicate which formulas use the value in the active cell, use the _____ button on the Formula Auditing toolbar.

Answer 21

Trace Dependents

Question 22

By choosing Protect Sheet, you can prevent a worksheet from being deleted from a workbook.

Answer 22

False

Question 23

The data validation tool restricts data being entered and the data already stored in the worksheet.

Answer 23

False

Question 24

Data validation rules can contain formulas.

Answer 24

True

Question 25

When a worksheet is protected, by default, all cells in the worksheet are unlocked.

Answer 25

False

Question 26

The Error Alert Style of _____ indicates the entry does not conform to the data validation rules, and is accepted or canceled.

Answer 26

Information

Question 27

To automate repetitive or difficult tasks, use a _____, which is a series of commands that you store and then run when you need to perform a task.

Answer 27

macro

Question 28

After you create and test a macro, you can attach a _____ to vouch for its authenticity.

Answer 28

digital certificate

Question 29

A macro can be tested one step at a time by clicking the _____ button in the Macro dialog box.

Answer 29

Step Into

Question 30

To display the formulas on the worksheet, press_____.

Answer 30

Ctrl + ` (Ctrl + Left quote)

Question 31

The Error Alert Style of _____ indicates the entry is incorrect and must be canceled or corrected before continuing.

Answer 31

Stop

Question 32

Macro viruses are viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open the infected document.

Answer 32

True