View the step-by-step solution to:


This question was created from EX2016-ChallengeYourself-8-4-instructions (1)


5. The data in the MPG Daf worksheet were downloaded from the Web site
http::// 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
SwartWay designation. Use custom filtering to find cars in this date set that meet your criteria and then
copy the smaller data set to another worksheet where you can work with it further.
a. Go to the MPG Data worksheet, and display the AutoFilter arrows for the data set.
b. Create a custom number filter to show only rows where the greenhouse gas score is greater than 8.
c. Create another custom number filter to show only rows where the highway MPG is greater than 35.
d. Create a custom text filter to show only rows where the Two column contains the word auto.
e. Create a custom text filter to show only rows where the value in the Fww/ column equals Electricity
or Gasoline.
f. At this point, the list of more than 2,000 cars should be filtered down to just 48 records.
g. Copy the filtered data to cell Al 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 column widths.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Accounting tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors