or the new IDs, the sales associates$$ names must be in all upper case.

On the Sales Associates worksheet, enter a formula in cell G$2$ to display the last name from cell A$2$ in all upper case letters. Use cell references where appropriate.