Page 73 - TechPluse_C6_Flipbook
P. 73

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)


                 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.

                 To use Sort, follow these steps:
                 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 check box under the Options tab.

                 Step 4      Click on the Sort Key 1 box to open list of column headers under the Sort Criteria tab.
                           Select a column head, for example ‘Marks Obtained’.
                 Step 5      Click on the Ascending radio button for Sort Key 1.

                 Step 6      Repeat steps 4 and 5 to sort ‘Marks in Previous Term’ 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.





                                                                        Formulas, Functions and Charts in Calc       71
   68   69   70   71   72   73   74   75   76   77   78