what is the use of validation in MS Excel ?
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Verified answer
Answer:
[tex]\Huge{\textbf{\textsf{{\purple{Ans}}{\pink{wer}}{\color{pink}{:}}}}} \\ [/tex]
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.
[tex]\huge \star{\underline{\mathtt{\red{A}\pink{N}\green{S}\blue{W}\purple{E}\orange{R}}}} \star[/tex]
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.