Write any two data validations conditions (MS Excel)

1.	Write any two data validations conditions (MS Excel)
Answer» 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.

Answer»

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.

Discussion