Page 19 - TP_V5.1_C7_fb
P. 19
In the previous class, we learned that Excel is a spreadsheet software used to work with numbers,
text, formulae and charts. Excel is used when there is a need to handle large sets of data that
require various calculations and in-depth analysis. Let's learn some more useful features of Excel.
SORTING DATA IN EXCEL
It is easy to maintain data in Excel as the sheet is divided into rows and columns but the data may
not be arranged in a specific order automatically as we enter it.
For such a purpose, Excel provides us with a feature called sorting. Sorting means arranging the
data either in ascending or descending order. Data can be sorted in two ways:
Ascending order: Arranging data in increasing order, for example, letters from A to Z, numbers
from lowest to highest, etc.
Descending order: Arranging data in decreasing order, for example, letters from Z to A,
numbers from highest to lowest, etc.
To sort the data, follow the given steps:
2 Click on the Sort & Filter command.
3 For ascending
order, select
the Sort A to Z
option and for
descending order,
select the Sort Z
to A option.
1 Select a column or range
of the data to be sorted.
CUSTOM SORTING
Even when the data is arranged in ascending or descending order, it can still be sorted again within
another column. For example, if Student’s mark list is sorted with respect to Roll No. column, we
can still sort it in the Name column. You can do this in Excel using Custom Sort.
Advanced Features of Excel 17

