d. In cell C2, enter a formula to calculate the total sale. Multiply the quantity sold (cell B2) by the price per box (cell F1). You are going to copy this formula to cells C3:C9, so use relative and absolute references as appropriate.
e. Copy the formula in cell C2 to cells C3:C9.
f. Format the data in cells A1:C9 as a table using any style.
g. Sort the table data by values in the quantity column so the largest number is at the top.
h. In cell E3, type: Average Quantity
i. Enter a formula in cell F3 to calculate the average of cells B2:B9.
j. In cell E4, type: Total Sales
k. Enter a formula in cell F4 to calculate the sum of cells C2:C9.
l. Apply the Currency number format to cell F4.
m. Select cells A1:G9 and change the font size to 20.
n. Autofit all columns so the data are completely visible.
o. Copy cells A1:G9.
p. Save the Excel file, but leave it open.