Answered step by step
Verified Expert Solution
Link Copied!

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- In cell F2, calculate the average sales revenue in the dataset B12:D23. (3 Marks) 2- In cell F3, calculate the average rev

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

Introduction To Management Science A Modeling And Cases Studies Approach With Spreadsheets

Authors: Frederick S. Hillier, Mark S. Hillier

5th Edition

978-0077825560, 78024064, 9780077498948, 007782556X, 77498941, 978-0078024061

More Books

Students also viewed these Accounting questions

Question

What steps are required in the development of an ER diagram?

Answered: 1 week ago

Question

Be prepared to discuss your career plans.

Answered: 1 week ago