A teacher wants to view only students who scored above 75 marks without deleting other records. Which Excel tool is best?
Show answer & explanation
Correct answer: B
Explanation
The correct answer is Option 2, i.e., Filter.
In Microsoft Excel, the Filter tool is used to display only specific data based on conditions without deleting any records.
- You can set a condition like marks > 75
- Only matching rows will be shown
- All other data remains safe and hidden (not deleted)
- You can easily remove the filter to see all the data again