$10$

Onthe portand inventory worksheet, in cell B$5,$ enter a

retail price. In cell $B6,$ enter a function that will display the median retail price. In cell $B7,$ enter a function that will calculate the lowest retail price. In cell B$8,$ enter a function that will calculate the highest retail price. Format the range B$5$:B$8$ with Accounting Number Format.

$11$

On the Portland Inventory worksheet, in cell G$14,$ enter an IF function to determine the items to be ordered. If the Quantity in Stock is less than $50,$ then the cell should display Order. If not, then the cell should display OK$.$ Copy the function down through cell G$19.$