Page 24 - TrackpadV2.1_Class8
P. 24

A Sort dialog box will open.


                            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 button.
                            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

                  The feature of viewing rows of data suiting a specified selection criterion is called filtering data. This
                  command is present in the Home tab under Editing group. 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  Select the data to be
                                                                                            filtered and click on the
                                                                                            Sort & Filter command.

                                                                                             2  Select the Filter
                                                                                            option from the
                                                                                            drop-down list.









                  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 OK button.




                   22   Trackpad (V2.1)-VII
   19   20   21   22   23   24   25   26   27   28   29