Page 22 - TP_Prime_V2.2_Class7
P. 22
The chart will change to Line Chart similar to this.
Prime (Ver. 2.2)-VII Sorting Data Line chart
Every day, you deal with a lot of data. It is easier to work with sorted data. Sorting of data
means to organise the data in ascending or descending order. Excel allows you to sort both
numeric and textual data. You can sort the data according to a particular column as well as
20 a range of data. You can sort the data according to a particular column as well as a range
of data.
To sort data, follow these steps:
Step 1: Select a column or range of data to be
sorted. In this case, we have selected
the range A3:D8. Selected data
Step 2: Click on the Sort & Filter command from the Editing group under
the Home tab. A drop-down list appears.
Step 3: Click on the Sort A to Z (for text) and Sort Smallest to Largest
(for numbers) to sort the data in ascending order.
The selected data will be sorted according to the names in ascending order.
Sorting data
Custom Sorting
In case, more than one columns are to be sorted in such a way that the first column is in
ascending order and if some data is same for more than one rows then the second column
of such rows gets sorted in descending order. You can do this in Excel using Custom Sort.
To use C ustom Sorting, follow these steps:
Step 1: Select the range of columns to be sorted.
Step 2: Click on the Sort & Filter
command from the Editing
group under Home tab. A
drop-down list appears. Selected data Custom sorting
Step 3: Click on the Custom Sort option from the drop-down list.

