$.$

$6$

$8$

Without grouping the worksheets, complete the following in each worksheet:

$$ In cell G$14,$ type Stock Level

$$ In cell G$15,$ construct an IF function to determine the items that must be ordered. If the Quantity in Stock is less than $75$ the Value$\_$if$\_$true is Order. Otherwise the Value$\_$if$\_$false is OK$.$ Fill the formula down through all the rows.