On theMy Car Dataworksheet, use Advanced Filter to copy a subset of data to another location on this worksheet.

1. Copy cellsA1:P1and paste them below the data set in row52.
2. In cellA51, type:Criteria
3. Apply theAccent 4cell style to cellA51.
4. Set up the criteria in the row(s) below row 52. Find cars where the value in theFuelcolumn isGasolineandthe value in theHwy MPGcolumn isgreater than 35.
5. In cellA55, type:Filtered Data
6. Apply theAccent 4cell style to cellA55.
7. Autofit columnA.
8. Use Advanced Filter to find the rows that meet the criteria and copy the filtered data to another location beginning in cellA56.
9. Sixteen rows should have been copied from the main data set to cellsA57:P72.