FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Select the Data tab on the Ribbon, then click the Filter command. A drop-down arrow will appear in the header cell for each column. Note: If you’ve already added filters to your worksheet, you can skip this step. Click the drop-down arrow for the column you want to filter.

Detailed explanation-2: -On the Data tab, in the Sort & Filter group, click Filter. in the column header to display a list in which you can make filter choices. Note Depending on the type of data in the column, Microsoft Excel displays either Number Filters or Text Filters in the list.

Detailed explanation-3: -Sort and filter command is available on the a) HOME tab. Go to the Home tab, and then click the arrow below the Sort & Filtering icon in the Editing Group under the home tab and choose Filter or Sort according to your needs. To clear under the same drop-down box, click on clear.

Detailed explanation-4: -The Home menu is the second menu in the Excel menu bar. The Home ribbon items include options for formatting font, color, conditional formatting, filter, number type, and more. All these functions help one in performing various effective calculations.