Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

To determine the percent of sales for each customer, divide the sales for that customer by Total Sales for that medium. Use absolute addressing for

To determine the percent of sales for each customer, divide the sales for that customer by Total Sales for that medium. Use absolute addressing for Total Sales. Format each cell in Column G as a percentage with up to two decimal places.

For each type of Medium, create a Conditional Formatting rule for the percentages (column G) to highlight those percentages that exceed the average in dark green text on a light green fill.

I do not understand what it is asking me to do. I am working in Excel and using formulas.image text in transcribed

Ivertising Revenue Chart Company Porterhouse Molding, Inc. Round Candle Company McGregor & Sons Trash Removal Elegant Accents Uni Uni per unitTotal Sales ercentage 30 second commercia 30 second commercia 30 second commercia 60 second commercia 200.00 200.00 200.00 350.00 1,200.00 2,400.00 800.00 700.00 12 4 J & R Construction Miracle Redemption Bottle Store Maxell Manufacturing Pit Bakery 30 second commercia 60 second commercia 30 second commercia 60 second commercia 15 12 20 100.00 200.00 100.00 200.00 1,500.00 2,400.00 2,000.00 1,200.00 Advanced Plumbing & Heating Goldberg Collection Agency Chopping Insurance Co Rhine lake Hospital Full board per month Half board per month Half board per month Full board per month 350.00 200.00 200.00 350.00 4,200.00 1,200.00 2,400.00 2,100.00 12 12 Perfect Computer Consulting Gino's Auto Parts Pennywise Second-Hand Store Franklin Ford Dealership 5 sites per months 5 sites per months 10 sites per month 5 sites per months 150.00 150.00 275.00 150.00 900.00 1,800.00 3,300.00 900.00 12 12

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Audit Quality Developing A Quality Assurance And Improvement Program

Authors: Sally-Anne Pitt

1st Edition

1118715519, 978-1118715512

More Books

Students also viewed these Accounting questions

Question

Enhance the basic quality of your voice.

Answered: 1 week ago

Question

Describe the features of and process used by a writing team.

Answered: 1 week ago