Prisiritian w wistire Inventory Worksheet 1) Fill in the "Profit" column by using a formula. Recall that profit is calculated by subtracting the cost to purchase from the price. Ensure that your answer is in Acceunting format 2) Use the MAX function to determine which profit amount is the highest. Ensure that your answer is in Accounting format. 3) Use a function to determine the average price for all the inventory items. Ensure that your answer is in Accounting format. 4) Use a function to determine the average profit for all the inventory items. Ensure that your answer is in Accounting format. Prisiritian w wistire Inventory Worksheet 1) Fill in the "Profit" column by using a formula. Recall that profit is calculated by subtracting the cost to purchase from the price. Ensure that your answer is in Acceunting format 2) Use the MAX function to determine which profit amount is the highest. Ensure that your answer is in Accounting format. 3) Use a function to determine the average price for all the inventory items. Ensure that your answer is in Accounting format. 4) Use a function to determine the average profit for all the inventory items. Ensure that your answer is in Accounting format