UPPER, LOWER, PROPER in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

What is the output of =UPPER("Good Morning")?

You have the text Good Morning in a cell. What will the formula =UPPER("Good Morning") return?

Excel

=UPPER("Good Morning")

A "GOOD MORNING"

B "good morning"

C "Good Morning"

D "GoOd MoRnInG"

💡 Hint

UPPER converts all letters to capital letters.

The UPPER function changes all letters in the text to uppercase. So "Good Morning" becomes "GOOD MORNING".

📊 Formula Result

intermediate

What does =LOWER("HELLO WORLD") return?

Given the text HELLO WORLD, what is the result of the formula =LOWER("HELLO WORLD")?

Excel

=LOWER("HELLO WORLD")

A "hElLo WoRlD"

B "HELLO WORLD"

C "Hello World"

D "hello world"

💡 Hint

LOWER changes all letters to small letters.

The LOWER function converts all letters in the text to lowercase. So "HELLO WORLD" becomes "hello world".

📊 Formula Result

advanced

What is the output of =PROPER("john DOE")?

You have the text john DOE. What will the formula =PROPER("john DOE") return?

Excel

=PROPER("john DOE")

A "john doe"

B "JOHN DOE"

C "John Doe"

D "John DOE"

💡 Hint

PROPER capitalizes the first letter of each word and makes the rest lowercase.

The PROPER function capitalizes the first letter of each word and makes all other letters lowercase. So "john DOE" becomes "John Doe".

❓ Function Choice

advanced

Which formula converts "mIXeD CaSe" to "mixed case"?

You want to convert the text mIXeD CaSe to all lowercase letters. Which formula will do this?

A =LOWER("mIXeD CaSe")

B =PROPER("mIXeD CaSe")

C =LOWER(PROPER("mIXeD CaSe"))

D =UPPER("mIXeD CaSe")

💡 Hint

LOWER makes all letters small.

The LOWER function converts all letters to lowercase. So it changes "mIXeD CaSe" to "mixed case".

🎯 Scenario

expert

You have a list of names in mixed case. Which formula correctly formats all names as Proper Case?

You have a column with names like "aLEx smiTH", "MARy jOnEs", and "roBERT bRoWN". You want to convert all names to Proper Case (first letter capital, rest lowercase). Which formula should you use if the name is in cell A2?

A =LOWER(A2)

B =PROPER(A2)

C =UPPER(A2)

D =CONCAT(UPPER(LEFT(A2,1)),LOWER(MID(A2,2,LEN(A2))))

💡 Hint

PROPER capitalizes the first letter of each word automatically.

The PROPER function changes the first letter of each word to uppercase and the rest to lowercase, which is exactly what you want for names.