Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 25 - 2612_Digimind
P. 25

    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 the 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. Excel

                     allows us to see the important data and hide the rest data temporarily from the set of data. This
                     command is present in the Home tab under Editing group. To apply filters, follow the steps given below:

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

                                                                                             Advanced Features of Excel  23

| 20 21 22 23 24 25 26 27 28 29 30 |