Can anyone help me with this excel homework, instructions are attached in the word file. Thank you!

 

Ofce 2013 – myitlab:grader – InstructionsExploring - Excel Chapter 2: Homework Project 1Formulas and FunctionsProject Description:In the following project, you will perform preliminary work on the gym worksheet. You will thencalculate cost, annual total, and total due. You will also determine the down payment and balanceof gym membership. Your last steps will be to calculate the monthly payment and Fnalized theworkbook.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Download and open the ²le namedexploring_e02_grader_h1.xlsx, and then savethe ²le asexploring_e02_grader_h1_LastFirst. Click OK in the messageregarding the circular re±erence.02Create a named range ±or cells A18:C20 namedMembership.53Insert a ±unction to enter the current date in cell B2.54In cell C5, insert a lookup ±unction to display the basic annual membership cost ±orthe ²rst client.55Insert a ±unction in cell E5 to calculate total amount. The ±unction should add thecost o± membership plus, i± applicable, the locker ±ee. The locker column displaysYes±or clients that rent lockers.76In cell G5, calculate the total due based on the annual total and years o±membership in column F.57Copy the three ±ormulas down their respective columns.58Insert a ±unction in cell H5 to display the amount o± down payment ±or the ²rstclient.59Locate and correct the circular re±erence ±or the balance in cell I5. The balanceshould be calculated as the di³erence between total due and the down payment.710Copy the two ±ormulas down their respective columns.5Updated: 12/09/20151E_CH02_EXPV1_H1_Instructions.docx

Buff and Tuff GymDate Prepared:ClientMembershipCostLockerAnnual Total YearsTotal DueDown PaymentAndrewsDeluxeYes1BakerIndividualYes2CarterFamilyNo3DudleyDeluxeNo2EvansDeluxeYes3FoustIndividualNo1GardnerIndividualNo2HartIndividualNo3IvansIndividualYes3TotalsMembershipCostown PaymentSummary StatisticsDeluxe$575 $250Number of New MembersFamily$1,500 $700Lowest Monthly PaymentIndividual$300 $150Average Monthly PaymentMaxium Monthly PaymentLocker Fee$75Median Monthly PaymentInterest Rate5.75%Months Per Year12

• 1494565064-exploring_e02_grader_h1.xlsx
• 1494565066-E_CH02_EXPV1_H1_Instructions.docx

ComputerScienceExpert

(11)

Status NEW Posted 12 May 2017 04:05 AM My Price 11.00

-----------

Attachments

file 1494565069-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer