UPPER, LOWER, PROPER in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the UPPER function do in Google Sheets?

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 affect text in a cell?

LOWER converts all letters in the text to lowercase. For example, LOWER("Hello World") returns "hello world".

beginner

Explain what the PROPER function does with an example.

PROPER capitalizes the first letter of each word and makes all other letters lowercase. For example, PROPER("good morning") returns "Good Morning".

beginner

Which function would you use to make a name look like this: "John Smith" from "john smith"?

Use the PROPER function to capitalize the first letter of each word. For example, PROPER("john smith") returns "John Smith".

beginner

Can UPPER, LOWER, and PROPER functions change numbers or symbols in text?

No, these functions only change letters. Numbers and symbols stay the same. For example, UPPER("abc123!") returns "ABC123!".

What will =UPPER("good day") return?

A gOOD dAY

B good day

C Good Day

D GOOD DAY

UPPER converts all letters to uppercase, so "good day" becomes "GOOD DAY".

Which function makes all letters lowercase?

A PROPER

B LOWER

C UPPER

D CAPITALIZE

LOWER changes all letters to lowercase.

What does PROPER("hello world") return?

A Hello World

B HELLO WORLD

C hello world

D hELLO wORLD

PROPER capitalizes the first letter of each word.

If a cell contains "mY nAmE", which function will make it "My Name"?

A PROPER

B UPPER

C LOWER

D TRIM

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

Do UPPER, LOWER, and PROPER change numbers in text?

A Only PROPER changes numbers

B Yes, they change numbers to words

C No, numbers stay the same

D Only LOWER changes numbers

These functions only change letters; numbers and symbols remain unchanged.

Describe how you would use UPPER, LOWER, and PROPER functions to format names in a spreadsheet.

Think about how names usually look in formal writing.

Explain what happens to numbers and symbols when using UPPER, LOWER, or PROPER functions.

Consider what characters these functions can modify.