Data validation is a process through which restrictions are applied on the data to be entered in a cell. It is a simple rule, which is applied to a field or an attribute of a cell to validate the data to be entered. Validation ensures that no other content is inserted in the respective cell.
It is the process of ensuring that a program operates on clean, correct and useful data. It uses routines, often called “validation rules” or “check routines”, that check for correctness, meaningfulness, and security of data that are input to the system.
