A teacher wants to view only students who scored above 75 marks without deleting other records. Which Excel tool is best?
Filter
The teacher wants to display only the students scoring above 75 while keeping every other record intact, so the tool must show a subset temporarily without deleting any data.
The Filter tool does exactly this: applying a filter with the criterion "greater than 75" hides the rows that do not qualify and shows only the matching students.
Filtering is non-destructive — the hidden rows are simply not displayed, and removing the filter instantly brings back all records, so nothing is lost.
Remove Duplicates permanently deletes repeated rows and does not select records by a score threshold, so it would both lose data and fail the requirement.
Freeze Panes only locks header rows or columns in place while scrolling; it does not choose records by value.
Sort merely reorders all the rows, so it still shows every student rather than only those above 75.
Because Filter shows the qualifying subset without deleting anything, the correct answer is Filter.
Similar Questions
A text box moves out of place when content is edited during a presentation. Which design mistake MOST likely caused this?
In Excel, which function would you use to count the number of cells in a range that meet a specific condition?
In Excel, which function would you use to count the number of cells in a range that meet a specific condition?
In Excel's "Edit Mode," which keyboard shortcut allows you to insert a manual line break within a single cell to manage long text strings or multi-line formulas?
A teacher wants to view only students who scored above 75 marks without deleting other records. Which Excel tool is best?
A text box moves out of place when content is edited during a presentation. Which design mistake MOST likely caused this?
Important Questions from Microsoft Office
Which of the following statement(s) about Quick Access Toolbar in MS-Word 2010 is/are incorrect?
P: The Quick Access Toolbar has Save, Undo, and Redo buttons by default.
Q: The Quick Access Toolbar has Cut, Undo, and Redo buttons by default.
R: You can place more buttons on the Quick Access toolbar.
S: There is no option on Quick Access toolbar for "show below the Ribbon".
Which of the following is Math and trigonometric functions available in MS-Excel 365?
Which of the following shortcut key is used to quickly create a new, blank workbook in MS-Excel 2010?
Consider the following statement about the MATCH () function of MS-Excel 2010:
P: It searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
Q: The MATCH function syntax is MATCH(lookup_value, lookup _array, [match_type])
R: All the arguments in a MATCH() function are required.
Which of the following statement(s) is/are true
In MS-Excel 365 which of the following appears across the top of the screen and below the title bar and contains all the commands, formulas and features needed to create data-intense spreadsheets?
