IIHS Safety Rating Lookup Chart Large and Small Pickups 10. Compute the monthly cost of gas. a. In cell C27, enter a formula to calculate the nugber 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 (cell A6 from the Data sheet). b. Copy the formula to the appropriate cells for the other trucks. 5. If cells D27:F27 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. Hint: The references to the cells on the Dato sheet should use absolute references. If they do not the formula will update incorrectly when you copy it across the row. Kekey. Ostrowski-ERen19-ChallengeYourself-3,3-ALT - Excel INSERT PAGELAYOUT FORMULAS DATA REVIEW VIEW B c F Truck Purchase Truck 1 Truck 2 Truck 3 Truck 4 2019 Chevrolet Colorado 2019 Dodge Ram 1500 2019 Toyota Tacoma 2019 Chevrolet Silverado Vehicle Safety Rating \begin{tabular}{|l|l|l|l|l|l|l|} & & & & & & \\ \hline 5000 \\ Maintenance/Year & $700 & $600 & $200 & $160 \\ \hline Registration Fee & 160 & $160 & $160 & $950 \\ \hline Insurance/Year & $1,200 & $800 & $600 & \end{tabular} d Loan? Amount to Borrow. APR 3.20\% 3.60% \begin{tabular}{r|r|r|} 5.00% & 5.90% \\ \hline 3 & 2 \\ \hline \end{tabular} nthly Costs Loan Payment Gas: Maintenance/Month Insurance/Month Total Monthly IIHS Safety Rating Lookup Chart Large and Small Pickups