BTW EB A Merge & Center - E $ Insert Delete Forcat % 8-23 Conditional formatas Cell Formatting Table Styles Format Painter Clipboard CORREL . X 101 f o VLOOKUP H 9 Family Individual B $ $ 1,500 300 S $ $ VLOOKUP lookup_value table array, colindex_num (range_lookupll LOWOst Monthly Payment 150 Average Monthly Payment Maxum Monthly Payment Median Monthly Payment $ 75 2 Locker Feo 3 Interest Rate 4 Months Per Year 575% Instructions In Cell C5 Use the Vlookup function to return the cost associated with each membership. The data for the Vlookup table starts in cell A18 Copy the Vlookup function to cells C6 to C13 In Cell Es create a formula to calculate the annual total which is the membership and the locker fee, Copy the formula to cell E13 In Cell G5 create a formula to calculate total due which is the annual total multiplied by the number of years. Copy the formula to cell G13 In Cell 15 create a formula to calculate the balance which is the annual total minus the the down payment. Cophy the formula to 113 In Cel J5 use the PMT function to calcuate the montly payment based on the balance and the data located in cells B23 and 24. Use absolute cel addresses In cells G18 - G22 use the appropriate functions to return the data requested Total Points for Question One Question Two Question Three Question four Question Five Question Six Question Seven F... I Question One Edt Chovlar References Type here to search