If students' marks must be arranged from lowest to highest and no row should be hidden, which feature is suitable?
Answer and explanation
Correct answer: Sorting
Sorting rearranges records according to a selected field and order, such as marks from smallest to largest. It does not select records for temporary hiding, so all student rows can remain available. Filtering would show only records meeting a condition, while the other two options are unrelated. Hence sorting is the correct feature.
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 and order, such as marks from smallest to largest. It does not select records for temporary hiding, so all student rows can remain available. Filtering would show only records meeting a condition, while the other two options are unrelated. Hence sorting is the correct feature.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
