write down the steps to filter the data ?
Answers
Answer:
Begin with a worksheet that identifies each column using a header row.
Worksheet with header row
Select the Data tab, then locate the Sort & Filter group.
Click the Filter command.
Clicking the filter command
Drop-down arrows will appear in the header of each column.
Click the drop-down arrow for the column you want to filter. In this example, we'll filter the Type column to view only certain types of equipment.
Filtering a column
The Filter menu appears.
Uncheck the boxes next to the data you don't want to view, or uncheck the box next to Select All to quickly uncheck all.
Check the boxes next to the data you do want to view. In this example, we'll check Laptop and Projector to view only these types of equipment.
Selecting filter data
Click OK. All other data will be filtered, or temporarily hidden. Only laptops and projectors will be visible.
Filtered worksheet
Filtering options can also be found on the Home tab, condensed into the Sort & Filter command.
Explanation:
Answer:
1 .In order for filtering to work correctly, your worksheet should include a header row, which is used to identify the name of each column. In our example, our worksheet is organized into different columns identified by the header cells in row 1: ID#, Type, Equipment Detail, and so on.
2.Select the Data tab, then click the Filter command.
3.A drop-down arrow The drop-down arrow will appear in the header cell for each column.
4.Click the drop-down arrow for the column you want to filter. In our example, we will filter column B to view only certain types of equipment.
5.The Filter menu will appear.
6. Uncheck the box next to Select All to quickly deselect all data.
7.Check the boxes next to the data you want to filter, then click OK. In this example, we will check Laptop and Tablet to view only those types of equipment.
8.The data will be filtered, temporarily hiding any content that doesn't match the criteria. In our example, only laptops and tablets are visible .Filtering options can also be accessed from the Sort & Filter command on the Home tab.
pls mark me the brainiest!