It specifies the type of data that is appropriate/allowed as content in a cell (...for example, whole numbers, decimal numbers, dates, time, or text).
100
What is an input message?
Identifies kind of data the user should enter
100
A(n) _____ cell contains a value that is used in a formula.
precedent
100
Data validation rules can contain formulas.
True
100
A macro can be tested one step at a time by clicking the _____ button in the Macro dialog box.
Step Into
200
What are trace precedents?
Displays tracer arrows that indicate which cells affect the value of the currently selected cell
200
You can try to prevent an inexperienced Excel user from "messing up" a workbook by _____.
1.locking cells so that users cannot change their contents
2.specifying which actions users can perform
3.hiding cells so that users cannot see them
200
A(n) _____ cell uses the value in the active cell in its formula.
dependent
200
The data validation tool restricts data being entered and the data already stored in the worksheet.
False - The data validation tool only restricts new data being entered
200
After you create and test a macro, you can attach a _____ to vouch for its authenticity
digital certificate
300
What is a macro?
series of commands that you store and run when you need to perform a task
300
A validation rule can specify:
1. values, such as those between 1 and 100
2. dates
3. decimal numbers
300
By changing the Error Checking Rules, you can specify that Excel will alert you about the following: _____.
1.Formulas which omit cells in a region
2. Cells containing years represented as 2 digits
3. Unlocked cells containing formulas
300
The Circle Invalid Data button circles cells that ___
don't meet their data validation criteria
300
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
400
What does workbook protection do?
It prevents inserting, deleting, or renaming worksheets
400
The name of a macro can contain the following:
Letters, numbers, and the underscore symbol
400
What is Watch Window?
It keeps track of cell properties such as name, value, and formula, even if the cell is out of view.
400
Trace Dependents
displays tracer arrows that indicate which cells are affected by the value of the currently selected cell
500
What does worksheet protection do?
It prevents changing, moving, or deleting data.
500
What are the error alert styles?
Stop: entry is incorrect and must be canceled or corrected before continuing – this is default setting.
Warning: entry does not conform to the validation rule and can be canceled, corrected, or accepted.
Information: entry does not conform to the data validation rules and is either accepted or canceled.