pls help asap w question 15. what formulas do i use??

9 less than or equal to the total monthly amount available. b. Copy the formula to the appropriate cells for the other trucks. c. Display formulas and use the error checking skills learned in this lesson to track down and fix any errors. 15. Complete the Analysis section using formulas with statistical functions. Use named ranges instead of cell references in the formulas a. Price b.MPG City c.MPG Highway d. Horsepower e. Torque 1. Maintenance/Year Insurance/Year h. Amount to Borrow 1. APR 1. Years k Loan Payment 1. Gas m. Maintenance/Month n. Insurance/Month o. Total Monthly Hint: Select cells B6:F30 and use Excel's Create from Selection command to create named ranges for each row using the labels at the left side of the range as the names. Hint : Open the Name Manager and review the names Excel created, Notice that any spaces or special characters in the label names are converted to _characters in the names. Hint: To avoid typos as you create each formula, try using Formula AutoComplete to select the correct range name. 16. Before finishing the rinct check the workeheat for armre Excel Fle Edit View Insert Format Tools Data Window Help Auto Nahomi. Rodriguez-EX2019-Challenge Yourself-3-3-ALT (1) f fx 2.9.2. A Deine Name Am recently Financial Logo Used Test Due tookup Math & More Time Reference Trig Functions Precedent grace Dependents Show Err Watch Remove Arons Formule Checking Window Create from Selection Celcom 16 XFx . E Analysis Truck Purchase Truck 1 Truck 2 2019 Chevrolet Colorado 2019 Dodge Ram 1500 Truck 3 Truck 4 Description 2019 Toyota Tacoma 2019 Chevrolet Silverado de $34.990 dealer $13.990 AN High pesce $22.097 re $12.995 & Prie MGC WOW Horp Tor Tour Weets G C WHO MO Vebidelety Rating scade 308 275 GOO to 18 17 Rinde. 195 410 6500 15 21 18 AL 159 180 3800 19 24 215 A scinde 150 260 5500 10 22 19 Maintenance Insurance Year 16 ABOW AP Years Yearly Costs Mance 18 3700 180 31,200 5600 $560 SROO $200 $360 5600 $500 $160 5950 ves ce Need Loan? Ana Bot AR VALUE VALUE con Paper 6 Man Mo IM TM $27.990 260 5 $22.097 5. 3 $13,995 5.SON 2 3 1 Monthly Costs 10 Lant Gas anch ranca Manth Tot MON 522835 500LT 36.8 50.00 $7,202.04 VALLE WALUE $50.00 $66.62 WATULI 55.746.42 $0.00 51667 $50.00 $5,7632 $8:37952 5000 541.62 3 $3.42113 Alto yes use Data 9 less than or equal to the total monthly amount available. b. Copy the formula to the appropriate cells for the other trucks. c. Display formulas and use the error checking skills learned in this lesson to track down and fix any errors. 15. Complete the Analysis section using formulas with statistical functions. Use named ranges instead of cell references in the formulas a. Price b.MPG City c.MPG Highway d. Horsepower e. Torque 1. Maintenance/Year Insurance/Year h. Amount to Borrow 1. APR 1. Years k Loan Payment 1. Gas m. Maintenance/Month n. Insurance/Month o. Total Monthly Hint: Select cells B6:F30 and use Excel's Create from Selection command to create named ranges for each row using the labels at the left side of the range as the names. Hint : Open the Name Manager and review the names Excel created, Notice that any spaces or special characters in the label names are converted to _characters in the names. Hint: To avoid typos as you create each formula, try using Formula AutoComplete to select the correct range name. 16. Before finishing the rinct check the workeheat for armre Excel Fle Edit View Insert Format Tools Data Window Help Auto Nahomi. Rodriguez-EX2019-Challenge Yourself-3-3-ALT (1) f fx 2.9.2. A Deine Name Am recently Financial Logo Used Test Due tookup Math & More Time Reference Trig Functions Precedent grace Dependents Show Err Watch Remove Arons Formule Checking Window Create from Selection Celcom 16 XFx . E Analysis Truck Purchase Truck 1 Truck 2 2019 Chevrolet Colorado 2019 Dodge Ram 1500 Truck 3 Truck 4 Description 2019 Toyota Tacoma 2019 Chevrolet Silverado de $34.990 dealer $13.990 AN High pesce $22.097 re $12.995 & Prie MGC WOW Horp Tor Tour Weets G C WHO MO Vebidelety Rating scade 308 275 GOO to 18 17 Rinde. 195 410 6500 15 21 18 AL 159 180 3800 19 24 215 A scinde 150 260 5500 10 22 19 Maintenance Insurance Year 16 ABOW AP Years Yearly Costs Mance 18 3700 180 31,200 5600 $560 SROO $200 $360 5600 $500 $160 5950 ves ce Need Loan? Ana Bot AR VALUE VALUE con Paper 6 Man Mo IM TM $27.990 260 5 $22.097 5. 3 $13,995 5.SON 2 3 1 Monthly Costs 10 Lant Gas anch ranca Manth Tot MON 522835 500LT 36.8 50.00 $7,202.04 VALLE WALUE $50.00 $66.62 WATULI 55.746.42 $0.00 51667 $50.00 $5,7632 $8:37952 5000 541.62 3 $3.42113 Alto yes use Data