Skip to content

Menu

Game modes

Account

← Office Applications
GK QUESTION#1308

A teacher wants to display only the students who scored more than 75 marks without deleting or altering the remaining records. Which Excel feature is most appropriate for this task?

  1. ARemove Duplicates
  2. BFreeze Panes
  3. CSort
  4. DFilterCorrect answer
Show AnswerHide Answer

Answer

D. Filter

Show ExplanationHide Explanation

Explanation

Filter. The Filter tool displays only records that meet specific criteria, such as marks above 75. It hides other data temporarily without deleting it. Remove Duplicates deletes data, and Sort only rearranges records.

Sign in to report a question issue

Explore this topic

In Microsoft Word, the Mail Merge Wizard is located under the _________ tab.In MS-Excel 365, you can use _________ when you want to change a cell reference within a formula…Consider the following statements about MS PowerPoint: 1. The slide number can be added to each slide of…