use an IF function in cell E5 to calculate the annual total amount

ffice 2016-myitab grader-Insts EX16 XL CH02 GRADER CAP AS Gym Management 1.7 Project Description You are a sales representative at the local fitness center, Health Samp; Fitness Gym. Your manager expects each representative to track weekly new membership data, so you created a spreadsheet to store data. Membership costs are based on membership type. Clients can rent a locker for an additional annual fee. You are required to olect a down payment based on membership type, determine the balance, and then calculate the monthy payment based on a standard interest rate. In addition, you calculate general statistics to summarize for your manager. Spot-check results to make sure you created formulas and functions correcty Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Points Open the downloaded file exploring 002 grader alxisx 0.000 Insert a lookup function in celi CS to display the basic annual membership cost for the first ient. 10.000 /3 | Insert a function n cell B2 to dsplay the current date. 5.000 Use an IF function in cell ES to calculate the annual total amount, which is the sum of the basic cost and locker fees for those who rent a locker. For people who do not rent a locker the annual cost is only the cost shown in column C. The Locker column displays Yes for cients who rent a locker and No for those who don't 10.000 es for clents In cell G5, enter a formula to calculate the total amount due for the first cient based on the annual total and the number of years in the contract. Copy t G, and E down their respective columns the three formulas in columns C 5.000 6Insert a lookup function in cell H5 to display the amount of down payment for the first clent on the membership type. 0.000 Insert a formula in cell 15 to calculate the balance due on the membership. Copy the formulas for the rest of the dients. 5.000 Insert the PMT function in cell J5 to calculate the first dlient's monthly payment, using appropriate relative and absolute cell references. Copy the formula 15.000 Calculate totals for Annual Total, Total Due, Down Payment, Balance, and Monthly Payment on row 14 10.000 Updated: 08/28/2017 Current Instruction.docx