One way to ensure that correct data is entered into a cell or range is to use the Excel data ____ feature.
A)validation
B)concatenation
C)security
D)index

Question

Quizplus · Accepted Answer

The Excel data validation feature allows users to set rules and restrictions for the data that can be entered into a cell or range, thus ensuring that only correct data is entered. This feature can be used to limit input to specific values, ranges of values, or even custom formulas.

One Way to Ensure That Correct Data Is Entered into a Cell