BUSI 520 - Chapter 10

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

Any value

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

Comment

To display the formulas on the worksheet, press_____.

Ctrl + ` (Ctrl + Left quote)

The data validation tool restricts the _____.

Data being entered

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

Dependent

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

Digital Certificate

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

FALSE

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

FALSE - In order to prevent a worksheet from being deleted from a workbook, you must choose Protect Workbook (not Protect Sheet).

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

FALSE - The data validation tool does NOT restrict data already stored in the worksheet. The data validation tool only restricts new data being entered

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

FALSE - When a worksheet is protected, by default, all cells in the worksheet are locked.

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

False Negative - The "positive" and "negative" refer to the actual flagging of the errors. A positive flag, is one that has been flagged as an error. Whereas a "negative" would indicate that a cell has not been flagged as an error. The False implies that the cells were incorrectly flagged (or not flagged).

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

Format Cells menu/window

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

Information

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.

Macro

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

Precedent

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

Step Into

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

Stop

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.

TRUE

Data validation rules can contain formulas.

TRUE - You can use a formula in Data Validation rules by choosing a Validation criteria of "Custom."

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

Trace Dependents - These formulas are "dependent" on the active cell

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

Trace Precedents

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

True

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).

Validation Rule

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

Warning

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.

Watch Window

_____ prevents inserting, deleting, or renaming worksheets.

Workbook Protection

_____ prevents changing, moving, or deleting data.

Worksheet Protection

A validation rule can specify _____.

dates; decimal numbers; range of values

The Circle Invalid Data button circles cells that _____.

don't meet their data validation criteria

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

formulas that omit cells in a region cells containing years represented as 2 digits unlocked cells containing formulas

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

hiding cells so users can't see them specifying actions that users can perform locking cells so the content can't be changed

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

the cell is too small to display the contents