Ch. 10 Macros

ways to protect workbook

- lock cells so that users cannot change their contents - hide cells so that users cannot see them - restrict actions users can perform on specified portions of specified worksheets - prevent a worksheet from being deleted from a workbook

formula auditing tools

- permits review of structure and behavior of formula - may display tracer arrows - results in false positive and false negatives

validation rule

- specifies type of data that is appropriate - specifies range of acceptable values

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

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

To display the formulas on the worksheet, press_____.

Ctrl + ` (Ctrl + Left quote)

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

False

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

False

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

False negatives; 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).

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 strongProtect Workbook/strong (not Protect Sheet).nbsp;/p

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.

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

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

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

Data validation rules can contain formulas.

True

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

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

circle invalid data

a part of data validation where circles appear around any cells containing data that violates their specific data validation rule

watch window

allows you to keep track of cell properties, such as name, value, and formula, even if the cell is out of view

circular references

allows you to step through a set of cells that directly or indirectly refer to themselces

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

any value

error checking

checks for errors in the worksheet

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

comment

Data validation tool

creates rules that define what data is valid in a particular cell

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

error alert

displays a message of varying severity

trace dependents

displays tracer arrows that indicate which cells are affected by the value of the currently selected cell

trace precedents

displays tracers arrows that indicate which cells affect the value of the currently selected cell

The Circle Invalid Data button circles cells that _____.

don't meet their data validation criteria

input message

identifies kind of data user should enter

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

red tracer arrows

point to cells related to a cell that contain errors

blue tracer arrows

points to cells that provide data for the formula in a particular cell

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

precedent

workbook protection

protect a workbook to protect anyone from inserting, deleting, or renaming worksheets or from changing the size and position of the worksheet window. the protect workbook dialog box protects the worksheet structure (insert, delete, or rename worksheets) or its windows (same size and position)

worksheet protection

protect the contents of a worksheet to prevent anyone from changing, moving, or deleting its data. be certain the cells you want to protect are locked, unlock the cells you want users to be able to access, and then use the protect sheet dialog box to select the actions users can still take after worksheet protection is enabled. specifying a password that users must enter before unprotecting the worksheet is optional

file protection

protect the entire workbook file with a password for optimal security. securing a file means only authorized users can open a workbook and use its data. While the Save As dialog box is open, you can protect a file by clicking the Tools button, clicking General Options, and then using the General Options dialog box t o specify a password that users must enter to open and view a workbook file; the passwords helps you prevent unauthorized users from viewing your workbook

remove arrows menu

provides options to remove all tracer arrows, or just precedent or dependent tracer arrows

documentation sheet

records that describe how and why a system has been developed and how it should be used

remove arrows

removes all displayed tracer arrows

what are macros?

series of commands that you store and then run when you need to perform a task. the steps are stores as VBA commands in the macro and are performed in sequence when the macro is run.

set of acceptable values

should be a range of cells rather than actual values separated by commas

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

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

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

error alert style: information

the entry does not conform to the data validation rules and is either accepted or canceled

error alert style: warning

the entry does not conform to the validation rule, and can be canceled, corrected, or accepted. If accepted, the entry overrides the validation rule for the cell

error alert style: stop

the entry is incorrect and must be canceled or corrected before continuing. this is the default setting

trace error

traces errors in the active cell

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

A validation rule can specify _____.

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

"in-cell dropdown"

when selected, a drop-down arrow will appear in the cell so users can select from a list of acceptable values

"ignore blank"

when selected, the validation rule won't apply if the cell is blank