Page 55 - 2501_KVS_C-6
P. 55

Sort descending
                      1.  Select the columns you want to sort in descending order.

                      2.  Click on the Data à Sort Descending.
                      3.  In the fig. 3.29, you can see an option to sort the data in descending order.

                      4.  The data is sorted in descending order.


























                                                               Fig. 3.29
                 3.3.2 AutoFilter

                     Aryan: I want to display records of students who like pizza and pasta.

                     Gowri: You can apply filters to the data by selecting the AutoFilter option to view specific data.
                     It then hides other data.
                      1.  Select the columns on which you want to apply AutoFilter.

                      2.  Click on the Data à AutoFilter.
                      3.  In the fig. 3.30, you can see an option to apply filter on the data.



























                                                               Fig. 3.30


                                                                               LibreOffice Calc                     53
   50   51   52   53   54   55   56   57   58   59   60