Question

What is data validation? How to apply it on the selected column of data?

Answer 1

Answer:

Data validation means checking the accuracy and quality of source data before using, importing or otherwise processing data. Different types of validation can be performed depending on destination constraints or objectives. Data validation is a form of data cleansing.

Add data validation to a cell or a range

1. Select one or more cells to validate.

2. On the Data tab, in the Data Tools group, click Data Validation.

3. On the Settings tab, in the Allow box, select List.

4. In the Source box, type your list values, separated by commas.

5. Make sure that the In-cell dropdown check box is selected.

Answer 2

Answer:

Here Is the prooved /verified answer that will clear all of the doubts