Question 1 of 10
| A | B | C | D | |
|---|---|---|---|---|
| 1 | change me to capital | |||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 |
UPPER, LOWER, and PROPER Functions - Free Excel Practice Online
This free, interactive exercise teaches you UPPER, LOWER, and PROPER Functions in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Text Manipulation Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising UPPER, LOWER, and PROPER Functions this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this UPPER, LOWER, and PROPER Functions lesson
- The UPPER function changes text to uppercase. Type =UPPER(A1) to convert the text in A1 to "CHANGE ME TO CAPITAL".
- The LOWER function changes text to lowercase. Type =LOWER(A1) to convert the text in A1 to "change me to lowercase".
- The PROPER function changes text to proper case. Proper case is where the first letter in each word is capitalized, and the other letters are lowercase. This is typically used for proper nouns, like names. Type =PROPER(A1) to convert the text in A1 to "Christopher Walken".
- Convert the text in A1 to uppercase.
- Convert the text in A1 to lowercase.
- Convert the text in A1 to "Some Text".
- Write a formula that would return "MORE TEXT".
- Write a formula that would return "other text".
- Write a formula that would return "Other Text".
- Write a formula that would return "More Text".
UPPER, LOWER, and PROPER Functions practice - FAQ
How do I practice UPPER, LOWER, and PROPER Functions in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the UPPER, LOWER, and PROPER Functions exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this UPPER, LOWER, and PROPER Functions lesson?
This lesson covers UPPER, LOWER, and PROPER Functions as part of the Text Manipulation Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.