Page 47 - Digicode_AI_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.




                  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.





                                             TeCh Ready





            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