SSC CGL 2025 Tier-II · Paper-I, 19 January 2026 · Computer Knowledge Test · Question 9 of 150

We transcribed this text from the pictures of a candidate's response sheet for this paper; the answer is the key SSC marked with a green tick on that sheet. Solution last reviewed 11 September 2026.

Where this paper and its answers come from

SSC does not publish CGL question papers or a public answer key. This paper reaches us as a candidate's response sheet saved as pictures, so we transcribed the text from those pictures, and a second reader checked every question against them; where the layout carries meaning, we show the picture too. Each answer is the key SSC marked with a green tick on that sheet. SSC released a tentative key for challenge and later its final one, both only to candidates behind a login, and the sheet does not say which of the two it carries. UnlockIAS wrote the solutions.

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

(a)Remove Duplicates
(b)Freeze Panes
(c)Sort
(d)Filter

Answer

Why

Correct — D. The teacher needs two things: see only students above 75, and keep every record.

Excel's Filter does both. Filtered data displays only the rows that meet your criteria and hides the rest, which stay in the sheet. A "greater than" comparison on the marks column shows just the students above 75.

Hide, don't delete → option (d).

Why the others are wrong

(a)
Remove Duplicates — Remove Duplicates deletes repeated values, and Microsoft warns that the duplicate data is permanently deleted. It removes rows instead of hiding them, and it tests for repeats, not marks above 75.
(b)
Freeze Panes — Freeze Panes keeps chosen rows or columns on screen while you scroll, such as a header row. It hides nothing, so every student stays visible.
(c)
Sort — Sort reorders rows, for example marks from largest to smallest. Every student stays visible, and those at or below 75 are simply lower down.

Concept

Filter (Data > Filter) shows only the rows that meet criteria you set and temporarily hides the others. Filters include built-in comparisons such as greater than and top 10. Clear the filter and the hidden rows return.

Three look-alike tools do different jobs. Sort reorders rows but keeps them all. Freeze Panes (View tab) locks rows or columns on screen while you scroll. Remove Duplicates (Data tab) permanently deletes repeated data.

Sorting marks largest first brings the students above 75 to the top, which is why Sort tempts. It still leaves everyone else on screen, so it fails the stem's "view only".

Key facts

Filter shows only the rows that meet your criteria and hides the rest without deleting them.
Filters offer built-in comparisons such as greater than and top 10.
Remove Duplicates permanently deletes the duplicate data.
Freeze Panes (View tab) keeps chosen rows or columns visible while you scroll.

Study next

Clearing a filter from a columnCounting rows that meet a condition with COUNTIFSorting by numbers, text and dates, ascending and descending

Common traps

Choosing Sort because it groups the high scorers together, when it still shows every row.
Treating Remove Duplicates as a harmless clean-up, when it deletes data permanently.

The same kind of "greater than" condition is counted rather than displayed at 19 Jan 2026, 11:00 AM, Computer Knowledge Q.4, where COUNTIF(A1:A10, ">10") is keyed.

Related PYQs

No directly related past PYQ was found.

Topic: Software — all 6 SSC CGL questions on it, every solved shift.