Matching
Match each of the following errors to the problems which causes it:
Premises:
#NAME?
#VALUE
#NUM
#REF
#DIV/0
Responses:
A cell was deleted or contents were changed.
Function or range name misspelled:missing quotation marks
Formula encounters a text value instead of a numerical value.
Invalid numerical value in a function or invalid arguments used in a function
Formula attempts to divide by zero or an empty cell.
Correct Answer:
Premises:
Responses:
#NAME?
#VALUE
#NUM
#REF
#DIV/0
Premises:
#NAME?
#VALUE
#NUM
#REF
#DIV/0
Responses:
Related Questions
Q1: What is a 3-D reference?<br>A)A data cube
Q17: Which of the following functions does not
Q48: _ are the rules that dictate the
Q49: Match each of the following concepts to
Q49: What tool would you use to find
Q55: A hyperlink in an Excel worksheet can
Q77: Which of the following is not an
Q88: A(n)_ reference occurs when a formula uses
Q92: Which of the following is an example
Q98: _ is not supported in grouped worksheets,