Default value
The value a system fills in when the person entering data supplies none, such as a country field that starts on the first item in its list.
A default looks exactly like a real answer. The usual sign is one value that is far more common than it should be, such as a birth date of January 1 on a large share of rows.
Where it comes up
- Defaults mistaken for dataA value that looks real was filled in automatically by a form or a system, and nobody actually chose it.
- Disguised missing valuesA cell is not empty, but what it holds means there is no value: N/A, a dash, 999, or the word none.
See also
- PlaceholderText entered to fill a field that had no real answer, such as N/A, TBD, unknown, a single dash, or test@test.com.
- Sentinel valueAn ordinary-looking value used as a code for something else, most often 999, -1, or 1900-01-01 standing in for unknown.
- Missing valueA cell where a value should exist and does not. The reason matters: not collected, not applicable, and lost are different situations.