"What MS Excel feature restricts entries in a sheet, such as a date range or whole numbers only?"Conditional formattingSummationData validationData sort

Break Down the Problem

1. Identify the purpose of the features listed in the question.
2. Determine which feature is specifically designed to restrict entries based on specified criteria.

Relevant Concepts

1. Conditional Formatting: This feature is used to change the appearance of cells based on certain conditions, but it does not restrict data entry.
2. Summation: This refers to the process of adding numbers together and does not impose any restrictions on data entry.
3. Data Validation: This feature allows you to set rules for what data can be entered into a cell, such as limiting entries to a specific range of dates or whole numbers.
4. Data Sort: This feature organizes the data in a particular order but doesn’t restrict entry.

Analysis and Detail

• Data Validation is the only feature among the options provided that specifically restricts entries based upon defined criteria. This allows users to enforce rules regarding what type of data can be entered into a cell, such as enforcing date ranges or allowing only whole numbers.

Verify and Summarize

After analyzing the functions of each feature, it is clear that Data Validation is the correct answer, as it directly relates to restricting the type and range of data entries in an Excel sheet.

Final Answer

Data validation is the MS Excel feature that restricts entries in a sheet, such as a date range or whole numbers only.