DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which tab in the Data Validation dialog box is used to specify the validation criteria?
|
|
Number
|
|
|
Settings
|
|
|
Input Message
|
|
|
Error Alert
|
Explanation:
Detailed explanation-1: -As you already know, the validation criteria are defined on the Settings tab of the Data Validation dialog box (Data tab > Data Validation).
Detailed explanation-2: -Example of Data Validation in Excel It will show three tabs: Settings, Input Message, and Error Alert.
Detailed explanation-3: -On the Settings tab of the Data Validation dialog window, select Custom in the Allow box, and enter your data validation formula in the Formula box. Click OK.
There is 1 question to complete.