In a large marks table, only students with more than ninety marks must be shown. Which feature is most suitable?
Answer and explanation
Correct answer: Filtering
Filtering displays only the rows that satisfy a specified condition, such as marks greater than 90, while temporarily hiding rows that do not meet it. Sorting merely rearranges all or selected records into an order; it does not normally remove nonmatching records from view. Printing and spell check do not perform condition-based selection.
Frequently asked questions
What is the correct answer to this question?
Filtering
Why is this the correct answer?
Filtering displays only the rows that satisfy a specified condition, such as marks greater than 90, while temporarily hiding rows that do not meet it. Sorting merely rearranges all or selected records into an order; it does not normally remove nonmatching records from view. Printing and spell check do not perform condition-based selection.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
