Page 36 - Touchpad_Plus_V3.2_Class 7
P. 36

3                             More on Calc
















                                     Your Aim


                                     to learn about:
                                             Sorting Data                  Filtering Data
                                              Conditional Formatting           Goal Seek
                                              Printing a Worksheet


                  In the previous class, you have learnt how to format a Calc worksheet. Suppose, you have to highlight
                  cells that contain values greater than a particular value or sort data in ascending or descending
                  order. Calc provides you easy options for doing these types of formatting on a worksheet.

                      SORTING DATA

                  Calc can arrange the selected data in ascending or descending order. This is called sorting of
                  data. Perform the following steps to sort data:
                  Step 1  Select the data to be sorted.

                  Step 2  Click on the Data menu.
                  Step 3   Select the Sort Ascending or Sort Descending option to sort the data in ascending or
                           descending order respectively. In case of numbers, the ascending order is from 0 to 9
                           and in case of letters the ascending order is from A to Z. The data gets arranged in the
                           selected order.

























                               Unsorted data                Using Data menu            Sorted data (ascending)


               34       Plus (Ver. 3.2)-VII
   31   32   33   34   35   36   37   38   39   40   41