A teacher wants to view only students who scored above 75 marks without deleting other records. Which Excel tool is best?

Question

A teacher wants to view only students who scored above 75 marks without deleting other records. Which Excel tool is best?

1. A. Freeze Panes
2. B. Sort
3. C. Remove Duplicates
4. D. Filter (Correct answer)

Correct Answer

Option D — Filter

Detailed Solution & Explanation

The correct answer is Filter.

Key Points

• Filter temporarily hides rows that do not meet a condition, showing only the matching records while leaving all data intact.
• For this case a number filter of "greater than 75" displays just those students, and clearing the filter restores the full list.
• The alternatives do not fit: Sort reorders rows without hiding any, Remove Duplicates permanently deletes data, and Freeze Panes merely keeps headings visible while scrolling.

Additional Information

• AutoFilter is applied with Ctrl + Shift + L and offers number, text and date filters plus "Top 10" and colour-based options.
• Advanced Filter allows complex multi-condition criteria and can copy the results to another location.
• Filtering is non-destructive, which is exactly why it suits the requirement here — the key phrase in the question is "without deleting other records".
• Note that SUBTOTAL ignores hidden rows while SUM does not, so aggregating filtered data requires the former.