Matching
Match the following terms with the corresponding description:
Premises:
#NUM
#NAME?
#NULL!
#N/A
#DIV/0!
Responses:
Incorrect range separator Formula requires cell ranges to intersect and they do not
Function is missing one or more required arguments,or VLOOKUP,HLOOKUP,or MATCH functions do not return a match
Invalid arguments used in a function
Misspelled or invalid range name or function name
Formula attempts to divide a value by zero or an empty cell
Correct Answer:
Premises:
Responses:
#NUM
#NAME?
#NULL!
#N/A
#DIV/0!
Premises:
#NUM
#NAME?
#NULL!
#N/A
#DIV/0!
Responses:
Related Questions
Q48: What is indicated by red arrows when
Q49: What is the best method to consolidate
Q50: Which function is best used to return
Q51: Match the following terms with the corresponding
Q52: Worksheets can be hidden to help manage
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?