What is the purpose of data validation in Excel?

The correct answer is option 2- To define restrictions on the type of data entered into a cell.

Data validation is a feature to define restrictions on type of data entered into a cell. We can configure data validation rules for cells data that will not allow users to enter invalid data, There may be warning messages when users tries to type wrong data in the cell. The messages also guide users to what input is expected for the cell, and instructions to correct any errors.