Please show me step by step. I want to understand this not just have answers. And show me the formulas please too.

1. Compute the monthly cost of maintenance.
   1. In cell C22, enter a formula to calculate the monthly maintenance cost: Divide cell C12 by 12.
   2. Copy the formula to the appropriate cells for the other vehicles.
2. Compute the monthly cost of insurance.
   1. In cell C23, enter a formula to calculate the monthly insurance cost: Divide cell C14 by 12.
   2. Copy the formula to the appropriate cells for the other vehicles.
3. In cells C24:F24, compute the total the monthly cost for each vehicle.
4. Determine which vehicles are affordable.
   1. In cell C26, enter a formula using the IF function to display "yes" if the total monthly cost (cell C24) is less than or equal to the total monthly amount available for vehicle expenses (Data sheet, cell A4). Display "no" if the total monthly cost is not less than or equal to the total monthly amount available.
   2. Copy the formula to the appropriate cells for the other vehicles.
   3. Display formulas and use the error checking skills learned in this lesson to track down and fix any errors.
5. Complete the Analysis section using formulas with statistical functions. Use named ranges instead of cell references in the formulas.
   1. Price
   2. MPG City
   3. MPG Highway
   4. Average MPG
   5. Maintenance/Year
   6. Registration Fee
   7. Insurance/Year
   8. Amount to Borrow
   9. APR
   10. Years
   11. Loan Payment
   12. Gas
   13. Maintenance/Month
   14. Insurance/Month
   15. Total Monthly

• Hint: Select cells B7:F24 and use Excels 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.

C23 x G H 1 J L N P R s T z AA AB AC AD AE AF Analysis Vehicle 2 Vehicle 3 Vehicle 4 2019 Ford F150 Truck 2017 Toyota Prius Passenger 2017 Ducati Super Sport Motorcycle Average Highest Lowest dealer $28,115 19 25 22 private seller $24.463 58 53 55.5 private seller $12.995 36 36 36 Pricel MPG City MPG Highway Average MPGO $500 60 $1,500 Maintenance Year Registration Feel Insuranceleari A 1 Vehicle Purchase Vehicle 1 3 Description 2019 Ford Mustang Convertib Vehicle Type Passenger 5 6 Seller dealer 7 Price $31,895 8 MPG City 21 9 MPG Highway 31 10 Average MPG' 26 11 Yearly Costs Maintenance Year $600 13 Registration Fee 100 14 Insurance Year $1,200 15 Need Loan? No No Amount to Borrow $22,895 17 APR 3.20% 18 Years 5 19 Monthly Costs Loan Payment $413.43 21 Gas $69.75 22 Maintenance/Month 23 Insurance/Month 24 Total Monthly 25 26 Affordable? 27 28 29 30 31 $500 100 $800 No $19,115 2.90% 3 $300 100 $900 No $15,463 1.90%. 3 $3,995 5.90% Amount to Borrow APRI Years $555.05 $82.43 $442.23 $32.68 $176.88 $50.38 Loan Payment Gas Maintenance Mont- Insurance/Month Total Monthly 33 34 35 36 37 39 40 41 42 43 44 45 47 48 49 50 51 52 53 54 55 File Home Insert Page Layout Formulas Data Review View Help Acrobat Share Share Commel fx - Calculate Now Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library Define Name GUse in Formula Name Manager Create from Selection Defined Names y Trace Precedents x Show Formulas a Trace Dependents Error Checking FRemove Arrows Evaluate Formula Formula Auditing Watch Window Calculation i Calculate Sheet Options Calculation C13 100 A D E F H | J K L M N o P Q R S T V w Y Z AA AB AC 1 Vehicle Purchase Assumptions 2 3 4 $9,000 Total Cash Available for Vehicle Purchase $650 Total Monthly Amount Available to pay for Operating Vehicle 650 Number of Miles 1 Expect To Drive Each Month $2.79 Gas Price Per Gallon 5 6 7 8 9 Registration Fee Lookup Table 10 column# 1 2 11 Cargo Van 100 12 Farm Vehicle 68 13 Motor Home 100 14 Motorcycle 60 15 Passenger 100 16 Trailer 30 17 I Truck 100 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 C23 x G H 1 J L N P R s T z AA AB AC AD AE AF Analysis Vehicle 2 Vehicle 3 Vehicle 4 2019 Ford F150 Truck 2017 Toyota Prius Passenger 2017 Ducati Super Sport Motorcycle Average Highest Lowest dealer $28,115 19 25 22 private seller $24.463 58 53 55.5 private seller $12.995 36 36 36 Pricel MPG City MPG Highway Average MPGO $500 60 $1,500 Maintenance Year Registration Feel Insuranceleari A 1 Vehicle Purchase Vehicle 1 3 Description 2019 Ford Mustang Convertib Vehicle Type Passenger 5 6 Seller dealer 7 Price $31,895 8 MPG City 21 9 MPG Highway 31 10 Average MPG' 26 11 Yearly Costs Maintenance Year $600 13 Registration Fee 100 14 Insurance Year $1,200 15 Need Loan? No No Amount to Borrow $22,895 17 APR 3.20% 18 Years 5 19 Monthly Costs Loan Payment $413.43 21 Gas $69.75 22 Maintenance/Month 23 Insurance/Month 24 Total Monthly 25 26 Affordable? 27 28 29 30 31 $500 100 $800 No $19,115 2.90% 3 $300 100 $900 No $15,463 1.90%. 3 $3,995 5.90% Amount to Borrow APRI Years $555.05 $82.43 $442.23 $32.68 $176.88 $50.38 Loan Payment Gas Maintenance Mont- Insurance/Month Total Monthly 33 34 35 36 37 39 40 41 42 43 44 45 47 48 49 50 51 52 53 54 55 File Home Insert Page Layout Formulas Data Review View Help Acrobat Share Share Commel fx - Calculate Now Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library Define Name GUse in Formula Name Manager Create from Selection Defined Names y Trace Precedents x Show Formulas a Trace Dependents Error Checking FRemove Arrows Evaluate Formula Formula Auditing Watch Window Calculation i Calculate Sheet Options Calculation C13 100 A D E F H | J K L M N o P Q R S T V w Y Z AA AB AC 1 Vehicle Purchase Assumptions 2 3 4 $9,000 Total Cash Available for Vehicle Purchase $650 Total Monthly Amount Available to pay for Operating Vehicle 650 Number of Miles 1 Expect To Drive Each Month $2.79 Gas Price Per Gallon 5 6 7 8 9 Registration Fee Lookup Table 10 column# 1 2 11 Cargo Van 100 12 Farm Vehicle 68 13 Motor Home 100 14 Motorcycle 60 15 Passenger 100 16 Trailer 30 17 I Truck 100 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39