View the step-by-step solution to:


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


7. Format the filtered data set (cells A56:P72) as a table. Use Table Style Light 1 (the first table style in the
gallery). Be careful mor to include row 55 in the table data range.
8. Insert a new column to the left of the Greenhouse Gas Score coloma. Hint: Be sure to add a column to
the worksheet, not just the table.
a. Copy the values from cells M57:M72 to N57:N72.
b. Type this column label in cell N56: Cmb MPG Icon
9. Apply a new custom conditional formatting rule to cells N57:N72 to show the 4 Ratings icon set. Show
the icon only.

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