UPPER practice exercises
Converts to capitals. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 6501 | South | Theo | 3 | 30 | 90 |
| 3 | 6502 | West | Maya | 6 | 18 | 108 |
| 4 | 6503 | South | Lena | 4 | 60 | 240 |
| 5 | 6504 | South | Theo | 6 | 45 | 270 |
| 6 | 6505 | East | Kofi | 3 | 9 | 27 |
| 7 | 6506 | West | Lena | 1 | 30 | 30 |
| 8 | 6507 | South | Maya | 3 | 12 | 36 |
| 9 | 6508 | East | Theo | 5 | 24 | 120 |
Show order 6502’s Rep (C3) in capital letters.
Show answer
=UPPER(C3)→ MAYAShow order 6505’s Rep (C6) in capital letters.
Show answer
=UPPER(C6)→ KOFIShow order 6503’s Rep (C4) in capital letters.
Show answer
=UPPER(C4)→ LENAShow order 6501’s Rep (C2) in capital letters.
Show answer
=UPPER(C2)→ THEOShow order 6508’s Rep (C9) in capital letters.
Show answer
=UPPER(C9)→ THEOShow order 6506’s Rep (C7) in capital letters.
Show answer
=UPPER(C7)→ LENA
New to UPPER? Read the UPPER guide first: syntax, a worked example and common mistakes.