Which Excel feature allows you to set criteria for data entry in a cell, thereby preventing the entry of invalid data?

Correct option is D

Data Validation in Excel allows you to define specific criteria for what can be entered into a cell. This helps ensure that only valid data is entered, reducing the chances of errors in the data entry process.
Important Key Points:
1. Data Validation: With Data Validation, you can set rules such as limiting entries to a certain range of numbers, dates, or even restricting entries to specific text values.
2. Preventing Invalid Data: It ensures data integrity by restricting users from entering invalid or incorrect data, such as letters in a phone number field or numbers outside a specified range.
3. Customizable Rules: Data Validation offers a variety of options, including input messages, error alerts, and drop-down lists, providing flexible control over data entry.
Knowledge Booster:
· Conditional Formatting: This feature is used for changing the appearance of cells based on their content (such as changing color for values above or below a certain threshold), but it does not prevent invalid data entry.
· Filtering: Filtering is used to display only certain rows of data based on specific criteria but does not restrict or validate data entry in cells.
· Custom Views: Custom Views are used to save different display settings of a worksheet, but they do not control or restrict data entry.