Question

______ is a rule concerning what kind of data be entered in a cell.

1. Data-validation rule
2. Transpose rule
3. Format rule
4. Boundary rule

Answer 1

Correct Answer - Option 1 : Data-validation rule

The correct answer is the Data-validation rule.

• The Data-validation rule is a rule concerning what kind of data be entered in a cell.

• Data-validation rule
  • It controls what kind of data can be entered into a certain cell.
  • It allows only-
    • numeric or text values
    • only numbers within a specified range
    • data entries of a specific length

• It restricts-
  • dates and times outside a given range.
  • entries to a selection from a drop-down list.