Page 34 - iPlus_Ver_2.0_class_8
P. 34
The chart will change to a Line Chart similar to this.
#Digital Literacy
Let’s CatCh Up
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 represent data pictorially. ..........................
3. Plot area contains the actual chart and its other components. ..........................
4. Excel provides only two types of charts. ..........................
i + SORTING DATA
Sorting of data refers to the process of arranging data in ascending or descending order based
on a certain criteria. To sort data, follow the given steps:
3 Click on the Sort & Filter command.
2 Click on
Home tab. 4 Select Sort
A to Z (for
text) or Sort
Smallest to
Largest (for
1 Select numbers) to
the data sort the data
to be in ascending
sorted. order.
The selected data gets arranged in ascending order.
Custom Sort
In case more than one column is to be sorted in such a way that the first column is in ascending
order and if some data is the same for more than one row, then the second column of such rows
gets sorted in descending order. You can do this in Excel using Custom Sort.
To use Custom Sort, follow the given steps:
32
iPlus (Ver. 2.0)-VIII

