TEXT & DATA CLEANUP · ORIGINAL EXERCISE
Lower the signal
Convert the email in C2 to lowercase.
This quest practices LOWER using a fictional business dataset. Read the sheet below, then enter the interactive quest to write and check your formula.
| Raw name | Code | City | Imported amount | |
|---|---|---|---|---|
| aRI stone | ORD-NY-204 | ARI@EXAMPLE.COM | New-York | 1200 |
| bea moon | ORD-LA-105 | BEA@EXAMPLE.COM | Los-Angeles | 850 |
| CAM reed | ORD-NY-306 | CAM@EXAMPLE.COM | New-York | 940 |
| dev fox | ORD-AT-107 | DEV@EXAMPLE.COM | Atlanta | 650 |
Hints to get you started
- LOWER converts letters to lowercase.
- Reference the email cell C2.
- Put C2 inside LOWER.
Show the worked solution
=LOWER(C2)Consistent casing makes imported contact information easier to read.
Make the skill stick
After solving the task, explain what each reference does and why the formula answers the business question. Try the workbook download inside the quest to practice in your own spreadsheet app.
Explore the rest of this region →