Automatically colouring cells that meet a condition (e.g. marks below 50) is called:

  1. filtering
  2. conditional formatting
  3. data validation
  4. AutoFill
Answer

B) conditional formatting

Home → Conditional Formatting.

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