Need questions 4-18 answered, spreadsheet is below. Excel class. Please help. TH

Question

Need questions 4-18 answered, spreadsheet is below. Excel class. Please help. THANKS!

Health &Fitness; Gym 2 Date Prepared: 1/2/18 6:42 PM Membership Cost Annual Total Years Total Due Down Payment Balance Payment Type Message 5 Andrews 6 Baker 7 Carter 8 Dudley 9 Evans 10 Foust 11 Gardner 12 Hart 13 Ivans 14 Totals 15 16 17 18 Deluxe 19 Famiy 20 Individual Yes Yes 75.00 75.00 Family No Yes 75.00 No Yes 75.00 Membership Down Payment Cost 250 $ 700 $ 150 $ 575 1,500 Number of New Members Lowest Balance Average Balance Maxium Balance Median Balance 24 Locker Cost 75 700.00 28 29 30 31

Explanation / Answer

4. Click and drag your mouse cursor across the cells B to name
and right click any selected cell and Click "Name a Range.." or Define Name
there you can asssign name Locker_Cost
5. =VLOOKUP(B5,A18:C20,3,True)
6. Now, Select the cell C5 and drag the cursor from C5:C13 to copy the formula

7. Formula to calcualte the annual total at cell E5 is

=SUM(C5,IF(EXACT(D5,"Yes"),$B$22,0))

8. Now, Select the cell E5 and drag the cursor from E5:E13 to copy the formula.

9.

Formula to calculate the Total Due at cell G5 is,

=E5*F5.

10. Select the cell G5 and drag the cursor from G5:G13 to copy the formula.

11. Formula to calculate the Down Payment at cell H5 is,

=VLOOKUP(B5, Membership, 2,TRUE )

12.Select the cell H5 and drag the cursor from H5:H13 to copy the formula.

13. Formula to calculate the Balance Due at cell I5 is,

=G5-H5

14. Select the cell I5 and drag the cursor from I5:I13 to copy the formula.

15.

=IF(I7>=$B$27,"No Checks. Only Cash","Checks or Cash")

16. Select the cell J5 and drag the cursor from J5:J13 to copy the formula.

17.

Total Cost : at C14 formula =SUM(C5:C13)
Total for Annal Total : at E14 formula =SUM(E5:E13)
Total for Total Due : at G14 formula =SUM(G5:G13)
Total for Down Payment : at H14 formula =SUM(H5:H13)
Total for Balance : at I14 formula =SUM(I5:I13)

18.

No of New Members(at cell H18) =COUNT(A5:A13)
Lowest Balance (at cell H19) =MIN(I5:I13)
Average Balance (at cell H20) =AVERAGE(I5:I13)
Maximum Balance (at cell H21) =MAX(I5:I13)
Medium Balance (at cell H22) =MEDIAN(I5:I13)

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.