Question

explain the concept of filtirs to be applied to a worksheet

Answer 1

In addition to sorting, you may find that adding a filter allows you to better analyze your data. When data is filtered, only rows that meet the filter criteria will display, and other rows will be hidden. With data filtered, you can then copy, format, print, etc., your data, without having to sort or move it first. To use a filter,

   Go to the Home Ribbon, click the arrow below the Sort & Filtering icon in the Editing Group and choose Filter.

OR

   Go to the Data Ribbon, and then click Filter in the Sort & Filter Group.

You will notice that all of your column headings now have an arrow next to the heading name. Click on the arrow next to the heading by which you want to filter, and you will see a list of all the unique values in that column. Check the box next to the criteria you wish to match and click OK. Click on the arrow next to another heading to further filter the data.

To clear the filter, choose one of these options:

   Click on Filter icon next to the heading and choose Clear Filter From “Name of Heading”.

   Go to the Data Ribbon and click the Clear icon in the Sort & Filter Group.

   Go to the Home Ribbon, click the arrow below the Sort & Filtering icon in the Editing Group and choose Clear.