Page 224 - CA_165_V2.0_C9_Flipbook
P. 224

FILTER

                  Filtering is a quick and easy way to get required information from a subset of data in a range of cells. A
                  filtered range displays only the data that meet the criteria specified for a field. In OpenOffice Calc, there
                  are three options that help in filtering the range of data:

                          Filter Type                                      Description
                   AutoFilter                It filters data according to specific value or string.

                   Standard Filter           It filters the data according to a given condition.
                   Advanced Filter           It does more advanced filtering, on the basis of specific criteria.

                  Unlike sorting, filtering does not rearrange a range of cells. Filtering temporarily hides the rows that
                  are not required to be displayed. It allows you to edit, format, and even print the range subset without
                  rearranging or moving it.

                  To filter a range of data, follow these steps:
                  Step 1:   Select the entire data range that you want to filter, including headers.

                  Step 2:   Click the Data menu on the menu bar.

                  Step 3:   Click the Filter option from the drop-down menu. A submenu will appear.
                  Step 4:   In the submenu, select the AutoFilter option. Drop-down arrows will appear in front of all the
                            column headers or the column header range of the selected data.



                                                                                                      2

                                  3                                                                  4






                                  1


                  Step 5:   Click the drop-down arrow in front of the Grade column header.

                  Step 6:   Select All or the required criteria A, B, or C. The rows that satisfy the criteria will be visible, and
                            the rest of the rows will be hidden.









                                                                                                     5
                                                                                                     6










                   222   Touchpad Computer Applications (Ver. 2.0)-IX
   219   220   221   222   223   224   225   226   227   228   229