Question

4. What are the data validation criteria?

___________________________________________________________________________

_____________________________________________________

5. Which tab is used to explain massage for users?

___________________________________________________________________________

___________________________________________________________________________

_____________

6. Mention one example of data validation.
______________________________________________________​

Answer 1

Answer:

4.What are the data validation criteria?

• Any Value - no validation is performed. ...

• Whole Number - only whole numbers are allowed. ...

• Decimal - works like the whole number option, but allows decimal values. ...

• List - only values from a predefined list are allowed. ...

• Date - only dates are allowed. ...

• Time - only times are allowed.

6.Mention one example of data validation.

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

Information: Informs users that data is invalid. ...

Stop: Stops users from entering invalid data in a ...