Data validation can verify data that was entered into a worksheet before the validation criteria were applied.

Question

Quizplus · Accepted Answer

Data validation is a process of defining rules or criteria for data that can be entered into a cell or range of cells. Data validation criteria must be defined before data entry takes place, and the validation process is applied when data is entered. Therefore, data validation cannot verify data that was entered into a worksheet before the validation criteria were applied.

Data Validation Can Verify Data That Was Entered into a Worksheet