Matching
Match each of the following concepts to its best description:
Premises:
Watch Window
3-D Reference
IFERROR
Circular Reference
Data validation
Responses:
Specifications on what type of data is permissible
Using the dependent cell in the formula
Determines if an error is present
Provides a view on several cells at once
Cell Reference to a different worksheet in the same workbook
Correct Answer:
Premises:
Responses:
Watch Window
3-D Reference
IFERROR
Circular Reference
Data validation
Premises:
Watch Window
3-D Reference
IFERROR
Circular Reference
Data validation
Responses:
Related Questions
Q4: Match each of the following terms to
Q5: Hyperlinks can be used to build a
Q9: Match each of the following references to
Q30: To setup Split Windows, Synchronous Scrolling or
Q31: _ locks 2 windows together and enables
Q38: You can apply uniform page layouts to
Q42: A(n)_ is where you go when you
Q45: What is the feature that warns users
Q73: Hyperlinks must link to websites.
Q82: The worksheet name in a 3-D reference