Question

What is data validation? How is it used to enter valid ce
What are the benefits of using conditional formatting?​

Answer 1

Data validation is a feature in Excel used to control what a user can enter into a cell. For example, you could use data validation to make sure a value is a number between 1 and 6, make sure a date occurs in the next 30 days, or make sure a text entry is less than 25 characters.