Enter a formula in cell F12 to calculate the remaining balance after the current payment. The remaining balance is calculated by subtracting the principal payment from the balance in column B. Enter a function in cell 612, based on the payment and loan details, that calculates the amount of cumulative interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references. Enter a function in cell H12. based on the payment and loan details. that calculates the amount of cumulative principal paid on the first payment. Be sure to use the appropriate absolute. relative, or mixed cell references. Enter a reference to the remaining balance of payment 1 in cell 813. Use the fill handle to copy the functions created in the prior steps down to complete the amortization table. Ensure the Sales worksheet is active. Enter a function in cell BS to create a custom transaction number. The transaction number should be comprised of the item number listed in cell CB combined with the quantity in cell D8 and the first initial of the payment type in cell E8. Use Auto Fill to copy the function down, completing the data in column B