If all students must remain visible while marks are arranged from low to high, 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 available while changing their sequence. Filtering has a different purpose: it displays only records that meet a condition and may hide the rest. BCC, the Recycle Bin, and email features are unrelated to arranging spreadsheet data.
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 available while changing their sequence. Filtering has a different purpose: it displays only records that meet a condition and may hide the rest. BCC, the Recycle Bin, and email features are unrelated to arranging spreadsheet data.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
