UPPER, LOWER, PROPER in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

Excel

= [1](A1)

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

ATEXT

BLOWER

CPROPER

DUPPER

Attempts:

3 left

💡 Hint

Common Mistakes

Using LOWER instead of UPPER.

Using PROPER which capitalizes only the first letter.

The UPPER function converts 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.

Excel

= [1](B2)

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

APROPER

BLOWER

CUPPER

DCONCAT

Attempts:

3 left

💡 Hint

Common Mistakes

Using UPPER instead of LOWER.

Using PROPER which only changes the first letter of each word.

The LOWER function changes 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.

Excel

= [1](C3)

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

APROPER

BUPPER

CLOWER

DTRIM

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 in the text.

4fill in blank

hard

Fill both blanks to create a formula that converts text in D4 to lowercase and then capitalizes the first letter of each word.

Excel

= [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 inside which makes all letters uppercase first.

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

5fill in blank

hard

Fill all three blanks to create a formula that trims extra spaces from E5, converts text to lowercase, and then capitalizes the first letter of each word.

Excel

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

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

APROPER

BLOWER

CTRIM

DUPPER

Attempts:

3 left

💡 Hint

Common Mistakes

Skipping the TRIM function causing extra spaces to remain.

Using UPPER instead of LOWER inside.

The formula first removes extra spaces with TRIM, then converts all letters to lowercase with LOWER, and finally capitalizes the first letter of each word with PROPER.