BUSI 520 Chapter 10 Quiz

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

The data validation tool restricts the _____.

Data being entered

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

Digital Certificate.

The Circle Invalid Data button circles cells that _____.

Dont meet their data validation criteria

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

False - Cannot use spaces, periods, or special characters like !

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

False - all are locked by default

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 use protect workbook, not protect sheet

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

False - only restricts new data from being entered

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

False negatives

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

By changing the error checking rules, you can specify that Excel will alert you about the following:

Formulas which omit cells in a region, unlocked cells containing formulas, cells containing years represented as 2 digits

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.

Macros

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

Precedent

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

Specifying which actions users can perform, locking cells so that users cannot change their contents, hiding cells so users cannot see them.

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

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

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

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.

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(n) _____ cell uses the value in the active cell in its formula.

dependent

A validation rule can specify _____.

values such as those between 1 and 100, decimal numbers, dates