Matching
Match the following terms with the corresponding description:
Premises:
IFERROR
#N/A
#VALUE!
#REF!
#NUM!
Responses:
A logical function that checks a cell to determine if that cell contains an error or if a formula will result in an error
Reference to cell that contains no data or deleted data
Incorrect type of data used in an argument,such as referring to a cell that contains text instead of a value
Invalid arguments used in a function
Function is missing one or more required argumentsKL
Correct Answer:
Premises:
Responses:
IFERROR
#N/A
#VALUE!
#REF!
#NUM!
Premises:
IFERROR
#N/A
#VALUE!
#REF!
#NUM!
Responses:
Related Questions
Q54: To group adjacent worksheets:<br>A)click Group on the
Q55: Which of the following functions does not
Q56: Which of the following would cause the
Q57: A 3-D reference is a pointer to
Q58: What are the benefits of grouping worksheets?
Q60: Which of the following is not a
Q61: If the formula =B2*B3 is located in
Q62: Images can be used as hyperlinks
Q63: In Excel,hyperlinks appear as:<br>A)blue text with a
Q64: The Watch Window will update as user