It converts all the text to uppercase.
The syntax of the function is the following:
UPPER(text)
text: The text you want to convert to uppercase.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the UPPER function:
Insert the appropriate function in the cell A2 that changes the format on the contents of the cell A1 to title case.
Insert the appropriate function in the cell A3 that changes the format on the contents of the cell A1 to uppercase.
Insert the appropriate function in the cell A4 that changes the format on the contents of the cell A1 to lowercase.