If all names must remain visible but arranged alphabetically, which feature is useful?
Answer and explanation
Correct answer: Sorting
Sorting rearranges records according to a selected field, such as the name column, while keeping all records visible. An alphabetical sort can be ascending from A to Z or descending from Z to A. Filtering has a different purpose: it displays only records that satisfy a condition. Recycle Bin and blind carbon copy are unrelated to spreadsheet organisation.
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 the name column, while keeping all records visible. An alphabetical sort can be ascending from A to Z or descending from Z to A. Filtering has a different purpose: it displays only records that satisfy a condition. Recycle Bin and blind carbon copy are unrelated to spreadsheet organisation.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
