USING MICROSOFT EXCEL
USING DATA VALIDATION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
File
|
|
|
Home
|
|
|
Data
|
|
|
Insert
|
Detailed explanation-1: -To find the cells on the worksheet that have data validation, on the Home tab, in the Editing group, click Find & Select, and then click Data Validation.
Detailed explanation-2: -In Excel, data validation is found on the “Data” ribbon, under “Data Validation.” Once clicked, the data validation window will pop up. It will show three tabs: Settings, Input Message, and Error Alert.
Detailed explanation-3: -Add data validation to a cell or a range Select one or more cells to validate. On the Data tab, in the Data Tools group, click Data Validation.
Detailed explanation-4: -Go to the Data tab on the Ribbon, then click Data Validation . On the Settings tab, in the Allow box, click List . If it’s OK for people to leave the cell empty, check the Ignore blank box.