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
Q5: Whole number validation is functionally identical to
Q6: A(n)_ informs a user when entered data
Q7: _ validation requires the specification of upper
Q8: Which of the following is NOT a
Q9: _ validation presents the user with a
Q11: The _ Formula tool shows exactly how
Q12: Any _ validation is a means of
Q13: All of the following statements are TRUE
Q14: The Excel _ Window feature is particularly
Q15: All of the following statements are TRUE
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents