CUET Preparation Today
What is the purpose of data validation in Excel? |
To format text automatically To define restrictions on the type of data entered into a cell To protect worksheets from editing To apply conditional formatting |
To define restrictions on the type of data entered into a cell |
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. |
