Matching
Match each of the following concepts to its best description:
Premises:
Circular Reference
Data validation
3-D Reference
Watch Window
IFERROR
Responses:
Determines if an error is present
Using the dependent cell in the formula
Provides a view on several cells at once
Cell Reference to a different worksheet in the same workbook
Specifications on what type of data is permissible
Correct Answer:
Premises:
Responses:
Circular Reference
Data validation
3-D Reference
Watch Window
IFERROR
Premises:
Circular Reference
Data validation
3-D Reference
Watch Window
IFERROR
Responses:
Related Questions
Q7: To set up a Watch Window, Click
Q8: A run-time error occurs because a formula
Q9: When worksheets are grouped, [Group} appears in
Q10: Excel determines the messages returned when a
Q11: To edit or remove a hyperlink _.<br>A)left-click
Q13: If all worksheets are grouped, how do
Q14: Sheet 1 and Sheet 2 are grouped.If
Q15: A logic error happens mostly because a
Q16: The #NAME? error means that at least
Q17: Which of the following functions does not