Chapter 10 Quiz
A validation rule can specify _____. values, such as those between 1 and 100 dates All of the answers listed. decimal numbers
All of the answers listed.
By changing the Error Checking Rules, you can specify that Excel will alert you about the following: _____. Unlocked cells containing formulas Cells containing years represented as 2 digits All of the answers listed. Formulas which omit cells in a region
All of the answers listed.
You can try to prevent an inexperienced Excel user from "messing up" a workbook by _____. locking cells so that users cannot change their contents All of the answers listed. hiding cells so that users cannot see them specifying which actions users can perform
All of the answers listed.
To display the formulas on the worksheet, press_____. Ctrl + ` (Ctrl + Left quote) Alt + ` (Alt + Left quote) Ctrl + End Alt + ! (Alt + Exclamation)
Ctrl + ` (Ctrl + Left quote)
The data validation tool restricts data being entered and the data already stored in the worksheet. True False
False
When a worksheet is protected, by default, all cells in the worksheet are unlocked. True False
False
_____ are items that are, in fact, incorrect, but are not flagged as such. Negatives False negatives False positives Positives
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 Data Validation menu/window Record Macro menu/window Scenarios menu/window
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. Critical Stop Information Warning
Information
A macro can be tested one step at a time by clicking the _____ button in the Macro dialog box. Options Step Into Run Test
Step Into
The Error Alert Style of _____ indicates the entry is incorrect and must be canceled or corrected before continuing. Warning Critical Information Stop
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 Trace Precedents Error Checking Trace Error
Trace Dependents
Use the _____ button on the Formula Auditing toolbar to display tracer arrows that indicate which cells the formula references. Trace Errors Trace Precedents Error Checking Trace Dependents
Trace Precedents
Data validation rules can contain formulas. True False
True
The Error Alert Style of _____ indicates the entry does not conform to the data validation rules, and can be canceled, corrected, or accepted. Stop Critical Warning Information
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 Circle Invalid Data Evaluate Formula Trace Error
Watch Window
_____ prevents inserting, deleting, or renaming worksheets. Worksheet protection File protection Data validation Workbook protection
Workbook protection
_____ prevents changing, moving, or deleting data. Worksheet protection Workbook protection Data validation File protection
Worksheet protection
The data validation default (list box) option is _____. any value whole number custom list
any value
A _____ is a note that you attach to a cell, separate from other cell content. comment format document theme
comment
The data validation tool restricts the _____. protected data data being entered data already stored in the worksheet both data already stored in the worksheet AND data being entered
data being entered
A(n) _____ cell uses the value in the active cell in its formula. active dependent independent precedent
dependent
After you create and test a macro, you can attach a _____ to vouch for its authenticity. password security authentication digital signature digital certificate
digital certificate
The Circle Invalid Data button circles cells that _____. don't meet their data validation criteria All of the answers listed. have errors are in the wrong format
don't meet their data validation criteria
By choosing Protect Sheet, you can prevent a worksheet from being deleted from a workbook. true false
false
The name of a macro can contain letters, numbers, spaces, and the underscore symbol. true false
false
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. formula macro comment function
macro
A(n) _____ cell contains a value that is used in a formula. dependent independent precedent active
precedent
After summing cell to calculate total income, an error message of ########## is shown in one of your cells. What does this indicate? an incorrect formula an incorrect number the cell is too small to display the contents an incorrect position
the cell is too small to display the contents
Locking cells or hiding formulas has no effect unless the worksheet is protected. true false
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 false
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 scenario macro formula
validation rule
