This is a question from Management Information System.
this is in excel sheet you only have...
Totally Fit Gym Membership Totally Fit Gym-New Members I Total Yeams Tetal ue Payment Salane Pamen Clent Membership Cost Locker Annual Total Years Total Due Deluxe Individual Family Deluxe Deluxe ndividual individual 9 Groves 10 Paul 11 Pinder 12 Wiggins Yes Totals Down Membership Cost PaymentSummary Statistics 17 Delure 18 Family 19 Indiidual $500$250 $1,250$500 290$200 Number of New Members Lowest Monthly Payment Awerage Monthly Payment Maximum Pa 21 Locker Fee 22 Interest Rate $75 500% The health club: The worksheet in the figure displays a list of new members in the Totally Fit Gym. You do not have to match my formatting exactly, but you are required to duplicate the functionality. Proceed as follows: A. Click in Cell C4 and enter the appropriate VLOQKUP function to determine the cost of the individual's membership. Your formula should contain an absolute reference to the table of membership costs that is contained in cells A17 through MacBook Air 寮 FI F2 F5 FT F8