Page 47 - Computer Genius Class 06
P. 47
The sorting can also be done through the Sort & Filter group under the Data tab
by selecting and commands or sorting in ascending and descending
order, respectively. To create a custom sort, clic on command.
Let's REFRESH
harts ma e it easier to dra comparisons analyse gro th and relationships among the alues.
Excel can arrange the selected data in either ascending or descending order. This is called sorting
o data.
eXERCISE
A. Tick ( ) the correct option.
1. hich o the ollo ing is also no n as a ertical a is
i ar ii alue a is
iii ata i ategory a is
2. Under which tab is the Sort & Filter command present?
i ome ta ii Formula ta
iii nsert ta i ie ta
3. What can be sorted by using the Sort A to Z option?
i um ers ii ym ols
iii Te t i ll o these
B. Fill in the blanks using the words given below.
lot area olumn Scatter charts
1. The chart usually displays the data in the orm o ertical ars.
2. are also no n as scatter plot charts.
3. is the rectangular area bounded by the two axis.
C. State whether these statements are true or false.
1. Excel can arrange selected data in ascending order only.
2. We cannot create a Bar chart in Excel.
. ou cannot sort more than one column at a time in a selected range o cells.
. y data has headers chec o needs to e selected i columns ha e a heading
at the top.
Charts in Excel 45

