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



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
Get step-by-step solutions from verified subject matter experts
