Restricting entries in a cell, such as allowing only whole numbers 0–100, is done with:

  1. Paste Special
  2. Freeze Panes
  3. Data Validation
  4. Conditional Formatting
Answer

C) Data Validation

Data → Data Validation.

Computer Science MCQ · More Lab: MS Excel MCQs · Practise