Page 23 - Trackpad_V1_Book 7_Flipbook
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 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 temporarily data from the set of data.
                 To apply filters, follow the steps given below:


                                 1  Select the data to be filtered and 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 see the records of
                          all the girls of the class.



                                                                                            4  Tick the desired
                                                                                            checkbox.










                                                                               5  Click OK button.





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