Page 34 - iPlus_Ver_2.0_class_8
P. 34

The chart will change to a Line Chart similar to this.
















                                                                                             #Digital Literacy

                        Let’s CatCh Up


                    State whether these statements are True or False.
                    1. Area chart displays the data trends over a period of time.                    ..........................

                    2. A chart helps us represent data pictorially.                                  ..........................

                    3. Plot area contains the actual chart and its other components.                 ..........................
                    4. Excel provides only two types of charts.                                      ..........................




                   i +  SORTING DATA

                  Sorting of data refers to the process of arranging data in ascending or descending order based
                  on a certain criteria. To sort data, follow the given steps:

                                                                  3  Click on the Sort & Filter command.



                     2  Click on
                    Home tab.                                                                          4  Select Sort
                                                                                                      A to Z (for
                                                                                                      text) or Sort
                                                                                                      Smallest to
                                                                                                      Largest (for
                       1  Select                                                                      numbers) to
                      the data                                                                        sort the data
                      to be                                                                           in ascending
                      sorted.                                                                         order.

                  The selected data gets arranged in ascending order.
                  Custom Sort


                  In case more than one column is to be sorted in such a way that the first column is in ascending
                  order and if some data is the same for more than one row, then the second column of such rows
                  gets sorted in descending order. You can do this in Excel using Custom Sort.
                  To use Custom Sort, follow the given steps:




                    32
                         iPlus (Ver. 2.0)-VIII
   29   30   31   32   33   34   35   36   37   38   39