Page 210 - CA 165 ver 1.0 Class 9
P. 210

Step 2:   Click on ‘Data’ menu and select ‘Filter’ option.

                  Step 3:   Click on ‘AutoFilter’.


                                                                                         2


                                                                                         3





















                                  1












                  A drop-down arrow appears in each column or field of selected range of data.

                  Step 4:   Click on the drop down arrow.

                  Step 5:     Select the desired criteria from the drop-down box. For example, to filter the data according to
                            name of the stream, select the criteria let’s say ‘Commerce’ from the ‘Stream’.
























                             Filtered
                              Table





                   208    Touchpad Computer Applications-IX
   205   206   207   208   209   210   211   212   213   214   215