Multiple Choice
Named ranges that are to be used as lists of values for data validation ________.
A) must be in the same workbook where the validation is applied
B) must be in the same worksheet where the validation is applied
C) must be in a different workbook than where the validation is applied
D) must be in a different worksheet than where the validation is applied
Correct Answer:
Verified
Correct Answer:
Verified
Q44: The _ Formula tool shows exactly how
Q45: Macros can be run from the _
Q46: A _ Location is a folder that
Q47: To hide the horizontal scroll bar on
Q48: The Input Message and Error Message for
Q50: To select all cells that contain a
Q51: Excel protection features can be found in
Q52: Using named ranges to identify source data
Q53: The actual cells that _ macro references
Q54: Match the following terms to their description.<br>I.Data