Site MapHelpFeedbackLesson 15 - Using Auditing Tools
Lesson 15 - Using Auditing Tools
(See related pages)

1
Which button, when clicked, will highlight cells that do not match existing data validation settings?
A)Circle Invalid Data
B)Circle Valid Data
C)Circle Data Validation
D)Circle Data List
2
Which error value is displayed if =B30/0 is keyed into a cell?
A)#DIV/0
B)#N/A
C)#NAME?
D)#NULL!
3
Which button on the Formulas tab, when clicked, points to cells that rely on the value in the active cell?
A)Trace Precedents
B)Trace Error
C)Evaluate Formula
D)Trace Dependents
4
Which Ribbon command tab includes the Data Validation button?
A)Formulas
B)Data
C)Validation
D)Review
5
Which command can be set to prohibit or allow a cell entry?
A)Background error checking
B)Data validation
C)Go to Special
D)Evaluate Formula
6
Which dialog box provides a way to check each part of a formula?
A)Data Validation
B)Evaluate Formula
C)Go To Special
D)Watch Window
7
If the formula is =IFERROR(C7*2,"Check formula.") and cell C7=January, what will result?
A)2
B)January
C)Check formula.
D)#VALUE!
8
What button appears when the cursor hovers over a cell with an error triangle?
A)Error Checking Options
B)Formula Auditing
C)Evaluate Formula
D)Show Formula
9
What is a probable cause of the #NAME? error value message?
A)The formula uses a value that is not available.
B)The formula is divided by zero.
C)The formula uses unrecognized text.
D)The formula refers to a cell reference that is not valid.
10
What does the error value message #DIV/0 indicate?
A)The formula uses a value that is not dividable.
B)The formula divides by zero.
C)The formula divides by text.
D)The formula divides by itself.





To learn more about the book this website supports, please visit its Information Center.
(c)2008 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Notice.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


PASOnline Learning Center

Home > Excel > Lesson 15 Quiz