Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What formulas are required in the cells for the answers: 1 Class Sales Data 4567 8 9 10 11 12 Zumba. 13 Kickboxing 14 Aerobics
What formulas are required in the cells for the answers:
1 Class Sales Data 4567 8 9 10 11 12 Zumba. 13 Kickboxing 14 Aerobics 15 Cardio Strength 16 Cycle 17 Zumba 18 Sports Conditioning 19 Pilates 20 Yoga 21 Water Aerobics 22 PiYo 23 Weight Training 24 25 26 27 28 29 Location Northville January U D February March 680.00 670.00 690.00 656.00 672.00 712.00 700.00 0.00 0.00 596.00 592.00 632.00 372.00 696.00 668.00 685.00 556.00 568.00 552.00 652.00 632.00 640.00 612.00 632.00 628.00 624.00 632.00 628.00 424.00 452.00 464.00 628.00 636.00 624.00 668.00 704.00 Average Sales Revenue Average revenue in February, for Zumba classes Number of times Revenue is above average Minimum Revenue in January, for Aerobics classes Maximum revenue in March, for Pilates classes Total Revenue for Sports Conditioning classes
Step by Step Solution
★★★★★
3.52 Rating (162 Votes )
There are 3 Steps involved in it
Step: 1
2In cell F3 figure out how much the average Zumba class made in February We can use the AVERAGEIFS f...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