1. 1. On the Sales sheet, use formulas to complete the worksheet for the total cost, total profit, total sales per order and % of total sales columns. In rows 39-42, calculate the highlighted cells (totals, average, etc.)
2. 2. Use conditional formatting to highlight certain orders. In the Order Volume (Doses) column, apply a light green fill with green font to order volumes above the average of all of the order volumes. In the Total Cost, apply a light red fill with darker red font to the top 10 most expensive orders (cost). In the Profit column, apply a light blue fill with darker blue font for the top 10 most profitable orders.
3. 3. Insert a new worksheet and name it “Sales by Product”. Create a pivot table from the Sales data that shows each product and the total sales for those products by year.

Year	Drug Code	Order Volume (Doses)	Manufacturing Cost per Dose	Total Cost	Markup Percentage	Profit	Total Sales Price	% of Total Sales
2009	CX101	2310	$933.75		15%
2011	CX102	3709	$525.25		25%
2009	CX103	5175	$765.98		17%
2010	CX101	2893	$933.75		15%
2009	CX103	2833	$765.98		17%
2010	CX102	2863	$525.25		25%
2011	CX101	1822	$933.75		15%
2011	CX102	5245	$525.25		25%
2009	CX103	5084	$765.98		17%
2010	CX103	4590	$765.98		17%

Answer rating: 100% (QA)

Answer 1 On the Sales sheet formulas can be used to complete the worksheet for various calculations such as total cost total profit total sales per order and of total sales Total cost can be calculate... View the full answer