Question

Write any two data validations conditions (MS Excel)

Answer 1

What is data validation in Excel?

• Allow only numeric or text values in a cell.

• Allow only numbers within a specified range.

• Allow data entries of a specific length.

• Restrict dates and times outside a given range.

• Restrict entries to a selection from a drop-down list.

• Validate an entry based on another cell.