Question

25. Define sorting data in spreadsheet​

Answer 1

Answer:

Sorting determines the order of the data that is displayed in a spreadsheet. ... Different sorting options are available for the different types of data columns (text, date, and numeric). After you select a sorting option, the spreadsheet display is dynamically updated. You can also filter spreadsheet data.

Answer 2

Answer:

It means to arrange data either in ascending or descending order.

Explanation:

Sorting data in excel is arranging or rearranging a given set of data in a defined order, maybe in the form of a single column or a set of columns. Two types of sorting can be done in excel.

1. Single level Sorting  - Marks in ascending/descending order, Names in alphabetical order.

2. Multi-level Sorting -  This database management tool is a type of sort operation that uses more than two data fields in order to determine the order of records. In a normal sort, data may be arranged by Last Name, while in a multilevel sort, it could be ordered by Last Name as well as First Name.