Question: Please answer questions 7-10 Answer questions 7-10 using the data shown below: Sweat Junkie is Chicago's newest Hot Yoga studio located in Evanston, Illinois. Sweat

Please answer questions 7-10

Please answer questions 7-10 Answer questions 7-10 using the data shown below:Sweat Junkie is Chicago's newest Hot Yoga studio located in Evanston, Illinois.Sweat Junkie offers a variety of classes for all fitness levels and

Answer questions 7-10 using the data shown below: Sweat Junkie is Chicago's newest Hot Yoga studio located in Evanston, Illinois. Sweat Junkie offers a variety of classes for all fitness levels and abilities, from hot yoga (flexibility \& meditation) to hot pilates (strength \& conditioning), and Hot Barre Intensity. The table below show customers who registered for the Hot Barre class for the month of May. The cost per class, which depends on whether the attendee is a youth (15-18), a student, or a regular member, is shown in column C. The number of classes attended by each customer is shown in column D. Empty cells mean the registered customer did not attend any classes in May. 7. Which formula would tell us the number of registered customers? =COUNT(D4:D20) =COUNT(A4:A20) =COUNT(C4:C20) =COUNT(B4:B20) 8. Which formula would tell us the number of Hot Barre attendees in May? = COUNTA(D4:D20) = COUNTA(B4:B20) = COUNTA(A4:A20) =COUNTA(C4:C20) 9. Which formula would tell us the number of customers who did not attend any classes in May? =COUNTBLANK(B4:B20)=COUNTBLANK(C4:C20)=COUNTBLANK(A4:A20)=COUNTBLANK(D4:D20) 10. Which formula would tell us the total revenue earned in May? =SUMPRODUCT(C4:C20,D4:D20)=SUMPRODUCT(C4:C20D4:D20)=SUM(C4:C20,D4:D20)=SUM(C4:C20)SUM(D4:D20)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!