If only failed students must be shown in a large table and the other rows must be hidden temporarily, which feature is correct?
Answer and explanation
Correct answer: Filtering
Filtering displays only the records that satisfy a selected condition, such as marks below the passing level, while temporarily hiding the remaining rows. Sorting only changes the order of records and normally keeps them visible. Printing and spell check do not select rows by marks. Therefore filtering is the appropriate spreadsheet feature.
Frequently asked questions
What is the correct answer to this question?
Filtering
Why is this the correct answer?
Filtering displays only the records that satisfy a selected condition, such as marks below the passing level, while temporarily hiding the remaining rows. Sorting only changes the order of records and normally keeps them visible. Printing and spell check do not select rows by marks. Therefore filtering is the appropriate spreadsheet feature.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
