Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 46 - 2632_CodeMind
P. 46

    The sorting can also be done through the Sort & Filter group under the Data tab

                              by selecting      and     buttons for sorting in ascending and descending order,
                              respectively. To create a custom sort, click on      button.

                           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 button 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.

                                                                                                  More on Excel   45

| 41 42 43 44 45 46 47 48 49 50 51 |