Computer Science, asked by vijayant3423, 11 months ago

Using filter you can extract data based on.

Answers

Answered by Dksahoo222
16

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.

Answered by smartbrainz
17

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.

Similar questions