If a marks list must be arranged from highest to lowest and no row should be hidden, which feature is correct?
Answer and explanation
Correct answer: Sorting
Sorting rearranges records according to a selected field, such as marks, and can arrange numerical values in descending order. All records remain part of the list, although their order changes. Thus option B is correct. Filtering displays only selected records and may hide others, while Recycle Bin and blind carbon copy belong to different computer functions.
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, and can arrange numerical values in descending order. All records remain part of the list, although their order changes. Thus option B is correct. Filtering displays only selected records and may hide others, while Recycle Bin and blind carbon copy belong to different computer functions.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc. Topic: Analyse data using scenarios and goal seek.
