If marks in a spreadsheet need to be arranged from highest to lowest and no data should be hidden, which feature is correct?
Advertisement
Answer and explanation
Correct answer: Sorting
Sorting rearranges records according to a selected field, such as marks in descending order, while keeping the records visible. Filtering instead hides rows that do not meet a condition. Recycle Bin and Bcc belong to file recovery and email addressing, so they cannot arrange spreadsheet values.
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 descending order, while keeping the records visible. Filtering instead hides rows that do not meet a condition. Recycle Bin and Bcc belong to file recovery and email addressing, so they cannot arrange spreadsheet values.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
Advertisement