The data in the MPG Data worksheet were downloaded from the Web site $....$ The greenhouse gas scores range from $0$ to $10,$ where $10$ is best. The vehicles with the best scores on both air pollution and greenhouse gas receive the SmartWay designation. Use custom filtering to find cars in this data set that meet your criteria and then copy the smaller data set to another worksheet where you can work with it further.

Go to the MPG Data worksheet, and display the AutoFilter arrows for the data set.

Create a custom number filter to show only rows where the greenhouse gas score is greater than $8.$

Create another custom number filter to show only rows where the highway MPG is greater than $35.$

Create a custom text filter to show only rows where the Trans column contains the word auto.

Create a custom text filter to show only rows where the value in the Fuel column equals Electricity or Gasoline.

At this point, the list of more than $2,000$ cars should be filtered down to just $48$ records.

Copy the filtered data to cell A$1$ in the My Car Data worksheet. Be sure to include the heading row but do not include the All Models title. Paste keeping the source columns widths.