Question

Which option up an editor where you can apply criteria to filter the desired records

Answer 1

Answer:

Option opens up an editor where you can apply criteria to filter the desired records Filter by Form. Filter by Section. Advanced filter.

Explanation:

I need support from you please follow me and mark me as brainliest also like me

Answer 2

Answer:

Filtering can give you more control over your list, particularly if your list contains a large number of records. For example, suppose you operate a small grocery store and have a master inventory of all the items in the store. Your list would include everything from dairy products to fresh vegetables to cookies. What if you suddenly needed to know how many types of cheese were on the shelf? You could scroll through the entire list, counting the cheeses as you go, but it would make more sense to filter the list so that it displays only dairy products, or better yet, only cheeses.

Filtering a list lets you find and work with a subset of the data in your list by displaying only the records that contain a certain value or meet specific criteria. The remaining records are hidden from view until you instruct Excel to display them again. You can then copy this filtered list to another location without disturbing the primary source list.

Explanation:

Method

To filter a list using AutoFilter:

Select a cell in the list you want to filter.

In the Sort and Filter group on the Home tab, click the Filter button.

In the desired column heading cell, from the AutoFilter drop-down list, select the desired items by selecting/deselecting.

Repeat step 3 to filter the list by other columns.

To deactivate AutoFilter:

In the Sort and Filter group on the Home tab, click the lit-up Filter button.

Exercise

In the following exercise, you will filter a list.

Make sure a cell in the Cars worksheet list is selected.

In the Sort and Filter group on the Home tab, click the Filter button. [The Filter is switched on and the Filter button is illuminated].

Look at the titles of the list of data. [The AutoFilter drop-down arrows appear in the headings of the list].

From the MAKE AutoFilter drop-down list, deselect Select All and click to select Ford. [Only records that contain Ford in the Make column are visible. All other records are hidden. The MAKE AutoFilter drop-down arrow and the row headings of the visible records are blue].

From the DOORS AutoFilter drop-down list, deselect Select All and click to select 2. [Only Ford cars with 2 doors are visible. The DOORS AutoFilter drop-down arrow is also blue].

From the MAKE AutoFilter drop-down list, select only Chevy. [Only Chevy cars with 2 doors are visible].

In the Sort and Filter group on the Home tab, click the Filter button. [The Filter dropdown arrows disappear].

Save and close the workbook.