UPPER, LOWER, PROPER in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to convert the text in cell A1 to all uppercase letters.

Google Sheets

= [1](A1)

Drag options to blanks, or click blank then click option'

APROPER

BUPPER

CLOWER

DCONCAT

Attempts:

3 left

💡 Hint

Common Mistakes

Using LOWER instead of UPPER.

Using PROPER which capitalizes only first letters.

The UPPER function changes all letters in the text to uppercase.

2fill in blank

medium

Complete the formula to convert the text in cell B2 to all lowercase letters.

Google Sheets

= [1](B2)

Drag options to blanks, or click blank then click option'

ALOWER

BTRIM

CPROPER

DUPPER

Attempts:

3 left

💡 Hint

Common Mistakes

Using UPPER instead of LOWER.

Using PROPER which capitalizes first letters only.

The LOWER function converts all letters in the text to lowercase.

3fill in blank

hard

Fix the error in the formula to capitalize the first letter of each word in cell C3.

Google Sheets

= [1](C3)

Drag options to blanks, or click blank then click option'

APROPER

BLOWER

CUPPER

DLEFT

Attempts:

3 left

💡 Hint

Common Mistakes

Using UPPER which makes all letters uppercase.

Using LOWER which makes all letters lowercase.

The PROPER function capitalizes the first letter of each word.

4fill in blank

hard

Fill both blanks to convert text in D4 to lowercase and then capitalize the first letter of each word.

Google Sheets

= [1]([2](D4))

Drag options to blanks, or click blank then click option'

APROPER

BLOWER

CUPPER

DTRIM

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing the order of functions.

Using UPPER instead of LOWER inside.

First, LOWER makes all letters lowercase, then PROPER capitalizes the first letter of each word.

5fill in blank

hard

Fill all three blanks to convert text in E5 to uppercase, then lowercase, then capitalize the first letter of each word.

Google Sheets

= [1]([2]([3](E5)))

Drag options to blanks, or click blank then click option'

APROPER

BLOWER

CUPPER

DTRIM

Attempts:

3 left

💡 Hint

Common Mistakes

Incorrect order of functions.

Using TRIM which removes spaces instead of changing case.

The text is first converted to uppercase with UPPER, then to lowercase with LOWER, and finally capitalized with PROPER.