Answers
A setting that prevents invalid data from being entered at all, so the entry is refused.
A rule type that checks a value is between two limits or meets a greater or less condition.
A rule type that turns a cell into a drop-down menu of allowed choices.
A setting that allows invalid data to be entered but marks the cell as having a problem.
Entries recorded in mismatched formats, for example a birthday written in several different ways.
A spreadsheet tool that sets rules to check entries as they are typed, showing an error if broken.
A single condition applied to a cell that an entry must meet before it is accepted.
A rule type that checks what is typed in a cell, such as containing or matching a phrase.
A rule type that checks an entry is a real calendar day, after today or within a range.
An entry that cannot be true, such as an age of minus ten in a spreadsheet.