If a large marks table must show only students who scored below forty, which feature is most correct?
Answer and explanation
Correct answer: Filtering
Filtering applies a condition and temporarily displays only the rows that satisfy it, such as marks less than 40. The other rows remain in the table but are hidden from the current view. Sorting would merely change the order of all or selected rows; printing and spell check do not select records by a numeric condition. Therefore, filtering is correct.
Frequently asked questions
What is the correct answer to this question?
Filtering
Why is this the correct answer?
Filtering applies a condition and temporarily displays only the rows that satisfy it, such as marks less than 40. The other rows remain in the table but are hidden from the current view. Sorting would merely change the order of all or selected rows; printing and spell check do not select records by a numeric condition. Therefore, filtering is correct.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
