Question

On the sales associates worksheet, enter a formula in cell g2 to display the last name from cell a2 in all upper case letters?

Answer 1

To display the last name from cell A2 in all uppercase letters in cell G2, use the formula =UPPER(A2) in Microsoft Excel. This utilizes the UPPER function to convert text to uppercase.

Step-by-step explanation:

The student is asking how to create a formula in Microsoft Excel that converts the text in cell A2 to uppercase and displays it in cell G2. To achieve this, you would use the UPPER function, which converts all letters in a specified string to uppercase. The correct formula to enter into cell G2 would be =UPPER(A2). Once entered, this will display the last name from cell A2 in uppercase letters in cell G2.