Page 47 - CG_v2.1_flipBooks_class_6
P. 47
The sorting can also be done through the Sort & Filter group under the Data tab
by selecting and commands for sorting in ascending and descending
order, respectively. To create a custom sort, click on command.
Let's REFRESH
Charts make it easier to draw comparisons, analyse growth and relationships among the values.
Excel can arrange the selected data in either ascending or descending order. This is called sorting
of data.
eXERCISE
A. Tick ( ) the correct option.
1. Which of the following is also known as a vertical axis?
(i) Bar (ii) Value axis
(iii) Data (iv) Category axis
2. Under which tab is the Sort & Filter command present?
(i) Home tab (ii) Formula tab
(iii) Insert tab (iv) View tab
3. What can be sorted by using the Sort A to Z option?
(i) Numbers (ii) Symbols
(iii) Text (iv) All of these
B. Fill in the blanks using the words given below.
Plot area Column Scatter charts
1. The chart usually displays the data in the form of vertical bars.
2. are also known as XY 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.
3. You cannot sort more than one column at a time in a selected range of cells.
4. 'My data has headers' checkbox needs to be selected if columns have a heading
at the top.
Charts in Excel 45

