Question

Using filter you can extract data based on.

Answer 1

Answer:Create a Unique list of items.

Add a drop-down filter to display these unique items.

Use helper columns to extract the records for the selected item.

Answer 2

Explanation:

The data filtering in a spreadsheet is to set criteria which enable to display only certain data to the user. This helps to focus on certain details in a huge dataset or table of data.

The filtering does not change or delete the data in the worksheet. This filtering just displays the rows or columns to appear in the active Excel worksheet. The filters enable to limit of viewing data in the worksheet by hiding the relevant portion of it from the user.