In cell A6, type: Total payments 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. In cell A7, type: Interest paid 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. Apply borders using the Outside Borders option around cells A6:B7. In cell A9, type: Average sales In cell B9, enter a formula to calculate the average sales per month for the food truck locations. Hint: Use cells B7:E7 from the FoodTrucks worksheet as the function argument. Apply the Currency number format to cell B9. Display two digits after the decimal. In cell A10, type: Buy new truck? 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. This workbook includes two worksheets for data from the Tysons store. You should only be working with the latest data from 2022. Hide the TysonsStore2021 worksheet. Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully. Complete the following steps in the TysonsStore2022 worksheet: Select cells A2:A32, and apply the Short Date date format. Find the top ten sales items for the month. Select cells B2:D32 and use conditional format