$5456$ W$23$ A B $5$ Inventory Worksheet $3$ C IDI E FI H K Introduction Questions L $+$ M N $0$ P AKA Q $61)$ 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 Accounting format. $72)$ Use the MAX function to determine which profit amount is the highest. Ensure that your answer is in Accounting format. $83)$ Use a function to determine the average price for all the inventory items. Ensure that your answer is in Accounting format. $94)$ Use a function to determine the average profit for all the inventory items. Ensure that your answer is in Accounting format. $1011$ Price Increase Worksheet $125)$ The store would like to increase prices by $15\%.$ Use a function to fill in the column "Price Increase" to calculate the $15\%$ increase, using an absolute reference to cell B$1.$ Ensure that your answer is in Accounting format. $136)$ The store would like to adjust the increased prices so that they are rounded to the nearest whole dollar. Use the ROUND function in column "Rounded" to accomplish this. Ensure that your answer is in Accounting format. $147)$ What is the minimum price of the increased, rounded prices? Use an appropriate function to determine the answer. Ensure that your answer is in Accounting format. $158)$ What is the count of the items in the table? Use an appropriate function to determine the answer. $16$ H R $17$ Item ID Update Worksheet $189)$ The store would like to update the Item IDs to remove the letters after the $"$#$".$Fill in the column "Location of #$"$ with the position of the $"$#$"$ in the "Item ID$"$ column. Use the FIND function with the Search Text of an absolute referen $1910)$ Create the updated ID in cmn "New ID$"$ using the LEFT function and the value in the "Locaton of #$"$ column. Questions Inventory Price Increase Item ID Update S : G