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