Named ranges that are to be used as lists of values for data validation $\_\_\_\_\_\_\_\_.$

Named ranges that are to be used as lists of values for data validation $\_\_\_\_\_\_\_\_.$

must be in the same workbook where the validation is applied

must be in a different workbook than where the validation is applied

must be in the same worksheet where the validation is applied

must be in a different worksheet than where the validation is applied