what formulas do i use for 10-12

a. 10. Compute the monthly cost of gas. In cel C21, enter a formula to alculate the number of miles you expect to drive each month. Divide the value of number of miles (cell A5 from the Data sheet) by the average MPG for the vehicle multiplied by the price of a gallon of gas (eel A6 from the Data sheet). b. Copy the formula to the appropriate cells for the other vehicles. c. Ifedis D21:F21 display an error or a value of 0, display formulas and check for errors. d. If you still can't find the error, try displaying the precedent arrows. e. Hit: The references to the cels on the Duta sheet should use absolute reference. If they do not, the formula will update incorrectly when you copy it across the row. 11. Compute the monthly cost of maintenance. 1. In cell C22, enter a formula to calculate the monthly maintenance cost: Divile cdl C12 by 12. b. Copy the formula to the appropriate cells for the other vehicles. 12. Compute the monthly cost of insurance. In cel C23, enter a formula to calculate the monthly insurance cost: Divide cell C14 byl 2 b. Copy the formula to the appropriate cells for the other vehicles. Vehicle Purchase 2 Vehide 1 Vehicle 2 Vehicle 3 Vehicle 4 2014 Ducati Dlavel Strada Motorcycle 2016 Chevy Colorado Truck private seller $14,250 36 36 36 dealer $20,100 22 31 26.5 3 Description 2016 Ford Mustang Convertible 2014 Honda Accord Hybrid Vehicle Type Passenger Passenger S 6 Seller dealer private seller 7 Price $27,800 $20,463 MPG City 17 50 MPG Highway 28 45 20 Average MPG 22.5 47.5 1 Yearly Costs 2 Maintenance/Year $600 $300 3 Registration Fee 100 $100 4 Insurance Year $1,000 $700 s Need Loan? FALSE FALSE 6 Amount to Borrow $19,800 $12,463 APR 3.20% 1.90% 8 Years 5 3 Monthly Costs 0 Loan Payment -$357.54 5356.43 Gas 2 Maintenance/Month Insurance/Month Total Monthly $SOO $1,000 $1,500 $500 $100 $600 Main Re FALSE FALSE $6,250 5.90% 2 $12,100 2.90% 5276.72 $351.35 Mainte Insu Affordable? $8,000 Total Cash Available for Vehicle Purchase $500 Total Monthly Amount Available to pay for Operating Vehicle 600 Number of Milesi Expect To Drive Each Month $2.50 Gas Price Per Gallon Registration Fee Lookup Table 2 100 68 100 Cargo Van Farm Vehicle Motor Home Motorcycle Passenger Trailer Truck 60 100 30 100 a. 10. Compute the monthly cost of gas. In cel C21, enter a formula to alculate the number of miles you expect to drive each month. Divide the value of number of miles (cell A5 from the Data sheet) by the average MPG for the vehicle multiplied by the price of a gallon of gas (eel A6 from the Data sheet). b. Copy the formula to the appropriate cells for the other vehicles. c. Ifedis D21:F21 display an error or a value of 0, display formulas and check for errors. d. If you still can't find the error, try displaying the precedent arrows. e. Hit: The references to the cels on the Duta sheet should use absolute reference. If they do not, the formula will update incorrectly when you copy it across the row. 11. Compute the monthly cost of maintenance. 1. In cell C22, enter a formula to calculate the monthly maintenance cost: Divile cdl C12 by 12. b. Copy the formula to the appropriate cells for the other vehicles. 12. Compute the monthly cost of insurance. In cel C23, enter a formula to calculate the monthly insurance cost: Divide cell C14 byl 2 b. Copy the formula to the appropriate cells for the other vehicles. Vehicle Purchase 2 Vehide 1 Vehicle 2 Vehicle 3 Vehicle 4 2014 Ducati Dlavel Strada Motorcycle 2016 Chevy Colorado Truck private seller $14,250 36 36 36 dealer $20,100 22 31 26.5 3 Description 2016 Ford Mustang Convertible 2014 Honda Accord Hybrid Vehicle Type Passenger Passenger S 6 Seller dealer private seller 7 Price $27,800 $20,463 MPG City 17 50 MPG Highway 28 45 20 Average MPG 22.5 47.5 1 Yearly Costs 2 Maintenance/Year $600 $300 3 Registration Fee 100 $100 4 Insurance Year $1,000 $700 s Need Loan? FALSE FALSE 6 Amount to Borrow $19,800 $12,463 APR 3.20% 1.90% 8 Years 5 3 Monthly Costs 0 Loan Payment -$357.54 5356.43 Gas 2 Maintenance/Month Insurance/Month Total Monthly $SOO $1,000 $1,500 $500 $100 $600 Main Re FALSE FALSE $6,250 5.90% 2 $12,100 2.90% 5276.72 $351.35 Mainte Insu Affordable? $8,000 Total Cash Available for Vehicle Purchase $500 Total Monthly Amount Available to pay for Operating Vehicle 600 Number of Milesi Expect To Drive Each Month $2.50 Gas Price Per Gallon Registration Fee Lookup Table 2 100 68 100 Cargo Van Farm Vehicle Motor Home Motorcycle Passenger Trailer Truck 60 100 30 100