Data validation in a spreadsheet model

Data validation is a tool in spreadsheets that controls what kind of data can be entered into a cell. It is used to help prevent mistakes, such as typing the wrong word or entering numbers outside a set range. Various types of criteria can be used in data validation, such as text, dates and number ranges. Data validation can show helpful messages when users make an error. Using data validation helps keep data accurate and consistent.