UPPER, LOWER, PROPER in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the UPPER function do in Excel?

The UPPER function changes all letters in a text string to uppercase letters. For example, UPPER("hello") returns "HELLO".

beginner

How does the LOWER function work in Excel?

The LOWER function converts all letters in a text string to lowercase letters. For example, LOWER("HELLO") returns "hello".

beginner

Explain the PROPER function in Excel.

The PROPER function capitalizes the first letter of each word in a text string and makes all other letters lowercase. For example, PROPER("hello world") returns "Hello World".

beginner

Which function would you use to make a name look like a title, with each word starting with a capital letter?

Use the PROPER function. It capitalizes the first letter of each word and makes the rest lowercase, perfect for names or titles.

beginner

If cell A1 contains "GoOd MoRnInG", what formula would convert it to all lowercase?

Use =LOWER(A1). This will change "GoOd MoRnInG" to "good morning".

What will =UPPER("Excel Tips") return?

A EXCEL TIPS

B excel tips

C Excel Tips

D eXcEl tIpS

UPPER converts all letters to uppercase, so "Excel Tips" becomes "EXCEL TIPS".

Which function changes all letters to lowercase?

A PROPER

B UPPER

C LOWER

D CAPITAL

LOWER converts all letters in a text string to lowercase.

What does PROPER("john doe") return?

A JOHN DOE

B John Doe

C john doe

D JoHn DoE

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

If you want to make "HELLO WORLD" look like "Hello World", which function do you use?

A PROPER

B UPPER

C TEXT

D LOWER

PROPER capitalizes the first letter of each word and lowercases the rest.

Which formula will NOT change the text case?

A =UPPER(A1)

B =LOWER(A1)

C =PROPER(A1)

D =SUM(A1)

SUM is a math function and does not change text case.

Describe how to use UPPER, LOWER, and PROPER functions to change text case in Excel.

Think about how you would fix text that is all caps, all lowercase, or mixed case.

Give an example of when you would use the PROPER function in a real-life spreadsheet.

Think about how names or titles usually look in documents.