Page 23 - Trackpad_V5_Book 7
P. 23

4  Click on the Add
                      Level button to add
                      another column to sort.


                       5  Click on Then by
                      down arrow in the                                                  6  Click on OK.
                      Column section. Select
                      Name in this case.

            Further, more levels can be added to the Sort dialog box for sorting the given data in a spreadsheet.



                      FILTERING DATA IN EXCEL

            Excel allows us to see the important data and hide the rest data temporarily from the set of data.
            To apply filters, follow the steps given below:



                                                                                           1  Click on the
                                                                                          Sort & Filter
                                                                                          command.


                                                                                           2  Select the
                                                                                          Filter option.











            The list appears with the drop-down controls or the Filter switches on the right side of the column
            headings.


                      3  Click on Filter Switch. Here, we want to see the
                     records of all the girls of the class.





                                                                                       4  Tick the desired
                                                                                       checkbox.










                                                                    5  Click on the OK button.



                                                                                    Advanced Features of Excel  21
   18   19   20   21   22   23   24   25   26   27   28