The Pro Shop sells a variety of items from numerous categories. Aleeta would like to promote...

Transcribed Image Text:

The Pro Shop sells a variety of items from numerous categories. Aleeta would like to promote all items that are NOT accessories. On the Transactions worksheet, in cell H10, replace the static value by entering a formula that will return Yes if the category of the Item sold is not Accessories, otherwise return No. Use the fill handle to copy the formula down through H30. The Pro Shop sells a variety of items from numerous categories. Aleeta would like to promote all items that are NOT accessories. On the Transactions worksheet, in cell H10, replace the static value by entering a formula that will return Yes if the category of the Item sold is not Accessories, otherwise return No. Use the fill handle to copy the formula down through H30.