Page 23 - Trackpad_V4.0_c7_Flpbook
P. 23
You have formatted the sheet well. Why don’t Oh, you mean sorting on the
you arrange them in the order of calendar? basis of Birthdays.
Yes, or alphabetically according to names!
Test Your Knowledge 21 st Century #Information Literacy
Skills
#Critical Thinking
State True or False.
1. A chart helps us represent data pictorially.
2. Area chart displays the data trends over a period of time.
3. Excel provides eight categories of charts.
4. Plot area contains the actual chart and its other components.
In the previous class, you learnt about different types of charts in Excel. In this chapter, you are going
to learn how to sort and filter data. You will also learn about conditional formatting.
SORTING DATA
Every day, you deal with a lot of data. It is easier to work with sorted data. Data sorting is the process
of organising the data in ascending or descending order. Ascending order means arranging the data in
increasing order, from the smallest to the largest value. Descending order means arranging the data
in decreasing order, from the largest to the smallest value. Excel allows you to sort both numeric and
textual data. You can sort the data according to a particular column as well as a range of data.
Advanced Features of Excel 21

