Answered step by step
Verified Expert Solution
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.
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 12Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started