If you select the Custom option in the Allow list box in the Data Validation dialog box the validation rule will be based on an Excel logistical formula.
Correct Answer:
Verified
Q17: If you change the definition of a
Q18: Q19: The frequency of error alert determines what Q20: Defined names are automatically substituted for the Q21: When you lock a workbook you control Q23: To open the Data Validation dialog box Q24: One way to run a macro is Q25: When Excel creates a macro button the Q26: A range name is more descriptive than Q27: Applications typically include an interface to assist
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