FUNDAMENTALS OF COMPUTER

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?
A
Number
B
Settings
C
Input Message
D
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.