Question

Which option in MS Excel restricts the type of data that can be entered in a cell?

• A. Conditional Formatting
• B. Data validation
• C. Workbook statistics
• D. Add-ins

Answer 1

Answer:

B. Data validation

Data Validation

• Data Validation restricts the type of data that can be entered in a cell.

- Method: Select the cell or range, go to the "Data" tab, click "Data Validation," and set the criteria.

- Example: To restrict a cell to accept only whole numbers between 1 and 10, select the cell, go to "Data > Data Validation," choose "Whole number" from the "Allow" dropdown, and set the minimum and maximum values to 1 and 10.