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
   42   43   44   45   46   47   48   49   50   51   52