Data validation

Where can this fucntion be used

1 Answer(s)


- You use data validation to control the type of data or the values that users enter into a cell.

- Data Validation is used to check whether data entered is acceptable/ reasonable/ within a given range of values.

- For example, you may want to restrict data entry to a
- certain range of dates,
- limit choices by using a list,
- make sure that only positive whole numbers are entered,
- create a drop down list of items in a cell,
- create custom rules for what can be entered