Matching
Match the following terms with the corresponding description:
Premises:
#VALUE!
#NUM!
IFERROR
#REF!
#N/A
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
Function is missing one or more required arguments
Invalid arguments used in a function
Incorrect type of data used in an argument,such as referring to a cell that contains text instead of a value
Correct Answer:
Premises:
Responses:
#VALUE!
#NUM!
IFERROR
#REF!
#N/A
Premises:
#VALUE!
#NUM!
IFERROR
#REF!
#N/A
Responses:
Related Questions
Q11: Visited hyperlinks in Excel appear as:<br>A)blue text.<br>B)black
Q12: When is the input message displayed in
Q18: Match the following terms with the corresponding
Q25: _ is/are not supported when worksheets are
Q32: To ungroup worksheets:<br>A)click a worksheet tab for
Q42: When a(n)_ style error alert is used,the
Q68: Which of the following is the proper
Q79: A _ is a file that that
Q85: The split bar gives the user the
Q92: When worksheets are grouped,which of the following