When a filter is applied, rows that do not meet the criteria are:

  1. hidden temporarily
  2. moved to another sheet
  3. coloured red
  4. deleted permanently
Answer

A) hidden temporarily

Clearing the filter shows them again.

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