e.AutoFit column A. 1. Set the width of column B to 16. 9 Apply the Currency number format to cell B1. Display two digits after the decimal h. Enter a formula using the PMT function in cell B4. Be sure to use a negative value for the Pv argument Din cell A6, type: Total payments 1. In cell B6, enter a formula to calculate the total paid over the life of the loan (the monthly payment amount the number of payments). Use cell references k In cell A7, type: Interest paid 1. In cell B7, enter a formula to calculate the total interest paid over the life of the loan (the total payments - the original price of the truck). Use cell references. m. Apply borders using the Thick Outside Borders option around cells A6:37 in. In cell A9, type: Average sales o. In cell B9, enter a formula to calculate the average sales per month for the truck locations. Hint: Use cells B7:E7 from the MobileSales worksheet as the function argumenti p. Apply the Currency number format to cell B9. Display two digits after the decimal. Din cell A10, type: Buy new truck? r. In cell B10, enter a formula using the IF function to display Yes if the monthly payment for the truck loan is less than the average sales per month for the current trucks. Display No if it is not 110 of 9. e.AutoFit column A. 1. Set the width of column B to 16. 9 Apply the Currency number format to cell B1. Display two digits after the decimal h. Enter a formula using the PMT function in cell B4. Be sure to use a negative value for the Pv argument Din cell A6, type: Total payments 1. In cell B6, enter a formula to calculate the total paid over the life of the loan (the monthly payment amount the number of payments). Use cell references k In cell A7, type: Interest paid 1. In cell B7, enter a formula to calculate the total interest paid over the life of the loan (the total payments - the original price of the truck). Use cell references. m. Apply borders using the Thick Outside Borders option around cells A6:37 in. In cell A9, type: Average sales o. In cell B9, enter a formula to calculate the average sales per month for the truck locations. Hint: Use cells B7:E7 from the MobileSales worksheet as the function argumenti p. Apply the Currency number format to cell B9. Display two digits after the decimal. Din cell A10, type: Buy new truck? r. In cell B10, enter a formula using the IF function to display Yes if the monthly payment for the truck loan is less than the average sales per month for the current trucks. Display No if it is not 110 of 9