Question

What Excel Data Validation can do?

__________________________________​

Answer 1

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.

make me brilliant

Answer 2

• Explanation:
• 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.