Question

Drag each tile to the correct box click the filter option in the submenu of data, click the data option in the menu of the spreadsheet , select the header row of the data sort , in the filter dialog box enter the filter criteria, click ok
Which Order do they go in

Answer 1

Filters can be used to narrow down the data in the worksheet .It is a method to show only the qualitative data.Filters are used to show the data that is only required to be displayed

Explanation:

Following are the steps in filteration

• Begin with a worksheet that identifies each column using a header row.
• Select the Data tab, then locate the Sort & Filter group.
• Click 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.
• 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.
• Click OK. All other data will be filtered, or temporarily hidden. Only laptops and projectors will be visible.