Page 75 - TechPluse_C6_Flipbook
P. 75

Step 2    Click on the Data menu.

                 Step 3      Select the AutoFilter option. You will notice that small
                           arrows (     ) appear in front of all the column headers.

                 Step 4      Click on the arrow in front of the header Marks Obtained
                           to open a drop-down list. You will notice that all the entries
                           in the column are present in the list with small check boxes
                           in the beginning.
                                                                                                Using AutoFilter option
                 Step 5      Click some of the check boxes to uncheck them.

                 Step 6    Click on the OK button.






















                                                                            Filtered data



                            Using filter options

                 You will notice that the rows of unchecked data are removed from the list. You need not to worry
                 as the data is not lost. Notice the row headings. Some of the row headings are missing. The
                 unchecked rows have just been hidden from the display. To get the data back, open the filter list
                 again and check the unchecked entries. Suppose, you want to know the names of the students
                 who have scored more than 80 marks. Follow these steps to get the required information:

                 Step 1    Apply filters to the data.
                 Step 2    Click  on the  Marks Obtained
                           column header to open the filter
                           drop-down list.

                 Step 3    Place your mouse over Standard
                           Filter option to open Standard
                           Filter dialog box.
                 Step 4    Click on the Field Name
                           drop-down list and select the

                           Marks Obtained.                                       Using Standard Filter



                                                                        Formulas, Functions and Charts in Calc       73
   70   71   72   73   74   75   76   77   78   79   80