Page 37 - Touchpad_Plus_V3.2_Class 7
P. 37

Multiple Sort

                 If you want to sort more than one column in such a way that the first column is in ascending
                 order and if some data is same for more than one rows then the second column of such rows
                 gets sorted in descending order. You can do this in Calc using Sort option of Data menu.

                 Perform the following steps to sort multiple columns:

                 Step 1  Select the range of columns to be sorted.
                 Step 2   Select the Sort option from Data menu. The
                          Sort dialog box will open.

                 Step 3   Check  the  Range contains column labels
                          checkbox if your data includes column labels,
                          so the header row is not included in the sort.

                 Step 4   In the Sort Key 1 section, click on the Column
                          drop-down  list to  view  the  list of column
                          headers under the Sort Criteria  tab.  Select a
                          column header, for example, ‘Department.’

                 Step 5   Click on the Ascending radio button for Sort
                          Key 1.                                                          Using Data menu

                 Step 6   Repeat steps 4 and 5 to sort ‘First Name’ column in descending order  under
                          Sort Key 2.
                 Step 7  Click on the OK button. The data will be sorted according to the criteria defined.










                                   Unsorted data                                       Sorted data
                 Clickipedia



                   The sorting can also be done through Standard toolbar by selecting Sort Ascending              or
                   Sort Descending         tools for sorting in ascending and descending order respectively. To
                   sort multiple columns, click on the Sort tool      .


                     FILTERING DATA

                 You must have studied about filtration process which is used to separate unwanted material
                 from a mixture. Calc also provides you to filter unwanted data from a set of data. Perform the
                 following steps to apply AutoFilter:

                 Step 1  Select the range of columns to be filtered.




                                                                                                  More on Calc       35
   32   33   34   35   36   37   38   39   40   41   42