This table "Transaction Entry" keeps each transaction made by each sales representatives. The SalesPrice and UnitCost are both for per unit of goods. Use the table "UnitCost" to Complete the Column "UnitCost" (column H) in the "Transaction Entry" table. For example, cell H5 should be 350 since the cost of product "Quad" is 350 in the East region according to the UnitCost table. Hint: use two-way vlookup (5%) Complete the "Profits" column in the "Transaction Entry" table (column I) for each transaction. Profit = (SalesPrice - UnitCost)* Units (5%) In the column "# of Transactions" of the "Profit" table (column L), count the number of transactions occurred in each region. Hint: use countif, each row in the Transaction Entry table is a separate transaction (5%) In the column "Profit" of the "Profit" table (column M), calculate the TOTAL PROFITS generated in each region. Hint: use the sumif function. (5%) Draw a PIE CHART for the profit column you calculated in the last step, Showing the total sales in each region. (5%)