Page 33 - Trackpad_ipro 4.1_Class8
P. 33
The chart will change to a Line Chart similar to this.
SORTING DATA
Excel can arrange the selected data in either ascending or descending order. This is called sorting
of data. To sort data, follow these steps:
3 Click on the Sort & Filter command.
2 Click on
4 Select Sort
Home tab.
A to Z (for text)
or Sort Smallest
to Largest (for
numbers) to
sort the data in
ascending order.
1 Select
the data to
be sorted.
The selected data gets arranged in ascending order.
Custom Sort
If you need to sort multiple columns such that the first column is in ascending order and, for
rows with identical data in the first column, the second column is sorted in descending order.
You can do this in Excel using Custom Sort.
To use Custom Sort, follow these steps:
3 Click on the Sort & Filter command.
2 Click on
Home tab.
4 Click on
the Custom
Sort option.
1 Select
the range of
columns to
be sorted.
Spreadsheet—Functions and Charts 31

