of the loan.

a$.$ Insert a new worksheet between the MobileSales sheet and the

Onlinesales sheets.

b$.$ OName the new worksheet: TruckLoan

c$.$ Change the color of the worksheet tab to Orange. Use the third color

from the left in the row of Standard colors.

d$.$ Enter the loan terms as shown below.

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