What is the use of sorting data in a spreadsheet?
Answer and explanation
Correct answer: To arrange data from small to large or alphabetically
Sorting rearranges spreadsheet records according to a selected field or order, such as smallest to largest marks, oldest to newest dates, or alphabetical names. It makes patterns and entries easier to find, but the entire related table should be selected or the sort should be applied carefully so that rows do not become mismatched. Sorting does not delete data or control sound, so option A is correct.
Frequently asked questions
What is the correct answer to this question?
To arrange data from small to large or alphabetically
Why is this the correct answer?
Sorting rearranges spreadsheet records according to a selected field or order, such as smallest to largest marks, oldest to newest dates, or alphabetical names. It makes patterns and entries easier to find, but the entire related table should be selected or the sort should be applied carefully so that rows do not become mismatched. Sorting does not delete data or control sound, so option A is correct.
Which subject and chapter does this question cover?
This is a Class 10 Information Technology question. Chapter: Electronic Spreadsheet Advanced using LibreOffice Calc.
