UPPER, LOWER, PROPER in Google Sheets - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

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

You enter the formula =UPPER("Good Morning") in a cell. What will the cell display?

Google Sheets

=UPPER("Good Morning")

A good morning

B GOOD MORNING

C Good Morning

D GoOd MoRnInG

💡 Hint

UPPER converts all letters to uppercase.

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?

You type =LOWER("HELLO WORLD") in a cell. What will be the result?

Google Sheets

=LOWER("HELLO WORLD")

A hello world

B HELLO WORLD

C Hello World

D hElLo WoRlD

💡 Hint

LOWER changes all letters to lowercase.

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

📊 Formula Result

advanced

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

You enter =PROPER("john DOE smith") in a cell. What will the cell show?

Google Sheets

=PROPER("john DOE smith")

A John DOE Smith

B john doe smith

C JOHN DOE SMITH

D John Doe Smith

💡 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 the rest lowercase. So "john DOE smith" becomes "John Doe Smith".

❓ Function Choice

advanced

Which formula converts "mArY aNnE" to "Mary Anne"?

You want to change the text "mArY aNnE" so that only the first letter of each word is uppercase and the rest are lowercase. Which formula should you use?

A =UPPER("mArY aNnE")

B =LOWER("mArY aNnE")

C =PROPER("mArY aNnE")

D =CONCATENATE("mArY aNnE")

💡 Hint

Think about which function capitalizes the first letter of each word.

PROPER capitalizes the first letter of each word and makes the rest lowercase. UPPER makes all uppercase, LOWER all lowercase, and CONCATENATE joins text without changing case.

🎯 Scenario

expert

You have a list of names in column A with mixed cases. You want to create a formula in column B that shows the names in all uppercase except the first letter of the entire name should be uppercase and the rest lowercase. Which formula will produce this result for cell A2?

Given cell A2 contains "jOhN doE", which formula in B2 will produce "John doe" (only the first letter of the entire text uppercase, rest lowercase)?

A =UPPER(LEFT(A2,1)) & LOWER(MID(A2,2,LEN(A2)-1))

B =LOWER(A2)

C =UPPER(A2)

D =PROPER(A2)

💡 Hint

Think about combining functions to capitalize only the first letter of the whole text.

PROPER capitalizes the first letter of each word, not just the first letter of the entire text. UPPER(LEFT(A2,1)) & LOWER(MID(A2,2,LEN(A2)-1)) capitalizes only the first letter and makes the rest lowercase.