e$.$ AutoFit column A$.$

f$.$ Set the width of column B to $16.$

g$.$ Apply the Currency number format to cell B$1.$ Display two digits after the decimal.

h$.$ Enter a formula using the PMT function in cell B$4.$ Be sure to use a negative value for the $Pv$ argument.

i$.$ In cell A$6,$ type: Total payments

j$.$ In cell B$6,$ 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 A$7,$ type: Interest paid

I. In cell B$7,$ 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 A$6$:B$7.$

n$.$ In cell A$9,$ type: Average sales

o$.$ In cell B$9,$ enter a formula to calculate the average sales per month for the truck locations. Hint: Use cells B$7$:E$7$ from the MobileSales worksheet as the function argument.

p$.$ Apply the Currency number format to cell B$9.$ Display two digits after the decimal.

q$.$ In cell A$10,$ type: Buy new truck?

r$.$ In cell B$10,$ 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.