Page 35 - TP_iPlus_V2.1_Class8
P. 35
i + SORTING DATA
Sorting of data refers to the process of arranging data in ascending or descending order based
on a certain criteria. To sort data, follow the given steps:
3 Click on the Sort & Filter command.
2 Click on
the Home 4 Select Sort
A to Z (for
tab.
text) or Sort
Smallest to
Largest (for
1 Select numbers) to
the data sort the data
to be in ascending
sorted. order.
The selected data gets arranged in ascending order.
Custom Sort
In case more than one column is to be sorted in such a way that the first column is in ascending
order and if some data is the same for more than one row, then the second column of such rows
gets sorted in descending order. You can do this in Excel using Custom Sort.
To use Custom Sort, follow the given steps:
3 Click on the Sort & Filter command.
2 Click on the
Home tab.
4 Click on
the Custom
Sort option.
1 Select
the range of
columns to
be sorted.
33
Spreadsheet—Functions and Charts

