9. What does Excel data validation do? a. Restricts user input b. Allows unlimited data entry c. Automatically fills cells d. Suggests corrections
Answer (2)
The correct answer is a. Restricts user input.Excel data validation is a feature that controls and restricts the type or range of data users can enter into a cell or group of cells. It ensures that only acceptable or predefined values are input, helping to prevent errors and maintain data accuracy and consistency.
The correct answer is A. Restricts user inputExplanationExcel Data Validation is used to control what kind of data or values users can enter into a cell. It helps restrict input to specific types, ranges, or formats to prevent errors and maintain data accuracy.
