If all rows must remain visible while marks are arranged from highest to lowest, which feature is needed?
Answer and explanation
Correct answer: Sorting
Sorting rearranges records according to a selected field, such as marks, in ascending or descending order. It keeps the records in the table while changing their sequence. Filtering is used when only records meeting a condition should be displayed, so it is not the best match when every row must remain visible.
Frequently asked questions
What is the correct answer to this question?
Sorting
Why is this the correct answer?
Sorting rearranges records according to a selected field, such as marks, in ascending or descending order. It keeps the records in the table while changing their sequence. Filtering is used when only records meeting a condition should be displayed, so it is not the best match when every row must remain visible.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
