Question

what is the use of validation in MS Excel ?​

Answer 1

Answer:

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

Introduction. 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...

Answer 2

$\huge \star{\underline{\mathtt{\red{A}\pink{N}\green{S}\blue{W}\purple{E}\orange{R}}}} \star$

Introduction. 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.