What formulas are required in the cells for the answers: 1 Class Sales Data 4567 8 9

What formulas are required in the cells for the answers:

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

2In cell F3 figure out how much the average Zumba class made in February We can use the AVERAGEIFS f... View the full answer