193k views
4 votes
In cell I4 of the Employee Hours sheet, which function should be used to copy the name from cell A4 and format it to be in uppercase?

a) =CONCATENATE(A4)
b) =UPPER(A4)
c) =FORMAT(UPPER(A4))
d) =CHANGE_CASE(A4, "UPPER")

User Canac
by
7.8k points

1 Answer

6 votes

Final answer:

The correct function to use is =UPPER(A4).

Step-by-step explanation:

The correct function to copy the name from cell A4 and format it to be in uppercase is =UPPER(A4).

User Pavan Kumar T S
by
7.7k points