On the ‘’Sales’’ worksheet, in the ‘City Code’’ column, modify the formula to display the letters in unpercase.

At NOD Publishers, you are preparing a workbook for the company’s annual review.

On the ‘’Summary worksheet, from the existing text in cell A2, insert a hyperlink to ‘’http://www:nodpublishers.com with a ScreenTip that displays ‘’Company Website’’.

On the ‘’Prices’’ worksheet, apply the Title style to cell A1.

On the ‘’Prices’’ worksheet, in the ‘’inventory Notice’’ column, use a function to display ‘’Low’’ if the ‘’ inventory Level % is below 15%. Otherwise, leave the ‘’Inventory Notice’’ blank.

On the ‘’Instructional Hours’’ worksheet, adjust the width of columns B,G to exactly 12.