Matching
Match each of the following errors to the problems which causes it:
Premises:
#NUM
#VALUE
#NAME?
#REF
#DIV/0
Responses:
Invalid numerical value in a function or invalid arguments used in a function
Formula encounters a text value instead of a numerical value.
A cell was deleted or contents were changed.
Function or range name misspelled, missing quotation marks
Formula attempts to divide by zero or an empty cell.
Correct Answer:
Premises:
Responses:
#NUM
#VALUE
#NAME?
#REF
#DIV/0
Premises:
#NUM
#VALUE
#NAME?
#REF
#DIV/0
Responses:
Related Questions
Q73: Hyperlinks must link to websites.
Q74: _ cells are referenced by a formula
Q75: A(n)_ is best suited to monitor the
Q76: A(n)_ error alert accepts invalid data but
Q77: Which of the following is not an
Q79: Match each of the following concepts to
Q80: In a 3-D Reference, the _ name
Q81: '[StPaul.xlsx]Qtr3'!A3 is an example of a(n)_.
Q82: The worksheet name in a 3-D reference
Q83: Validation _ are the rules that dictate