Question

explain sorting and filtering​

Answer 1

Answer:

Sorting and Filtering Spreadsheet Data

Sorting determines the order of the data that is displayed in a spreadsheet. For example, do you want to display your data based on a birth date that is sorted in reverse chronological order? You can sort the data in a spreadsheet at any time—immediately after you create a spreadsheet, or after you query the spreadsheet data to retrieve a subset of the data. 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. Filters retrieve a specific subset of the spreadsheet data based on specific constraints (or filters) that you set. For example, you might want to filter spreadsheet data to show only those individuals that were born in the 1970s. You can set multiple filters for a spreadsheet. Multiple filters are mutually inclusive. Only those individuals, pedigrees, samples, or markers that meet all the filtering criteria are displayed in the spreadsheet. As with sorting, you can filter the data in a spreadsheet at any time—immediately after you create a spreadsheet, or after you query the spreadsheet data to retrieve an initial subset of the data.

Although sorting and filtering spreadsheet data are two completely separate actions, you can combine them as needed to produce a customized dataset that best fits your business needs. For example, you can sort spreadsheet data based reverse chronological birth dates, and you can then filter the sorted data to show only those individuals that were born in the 1970s.

Explanation:

make me brainlist