Question

explain these option validation in Excel ?​

Answer 1

Answer:

$\Huge{\textbf{\textsf{{\purple{Ans}}{\pink{wer}}{\color{pink}{:}}}}}$

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.

• Warning: Warns users that data is invalid. The warning does nothing to stop invalid d...
• Stop: Stops users from entering invalid data in a cell. Users can retry, but must enter a ...
• Information: Informs users that data is invalid. This message does nothing to stop inv...
• Alert Style: Behavior

Answer 2

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.