Page 22 - Plus V4 with Adobe class 7
P. 22
Take Off Century #Information Literacy
21 st
Skills #Critical Thinking
State whether these statements are True or False.
1. Area chart displays the data trends over a period of time.
2. A chart helps us to represent data pictorially.
3. Plot area contains the actual chart and its other components.
4. Excel provides eight categories of charts.
In the previous class, you have learned 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. 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 a range of data. To sort data,
follow these steps:
2
Click on the Sort & Filter command.
1 Select a column or range
of data to be sorted.
Click on the Sort A to Z (for text) or Sort
3 Smallest to Largest (for numbers) to sort
the data in ascending order.
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.
20 Plus (Ver. 4.0)-VII

