Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
LOWER and UPPER. LOWER(text) turns every letter into a small letter and UPPER(text) into a capital. Wrap them around a whole joined piece to fix the case of everything at once. Systems such as logins, codes and email addresses often care about case even when people don’t.
=UPPER("cl-301") gives CL-301IT is setting up accounts for six Brightline reps. Logins are the first letter of the first name plus the last name, all in small letters (Chloe Martin is cmartin), and the team tag is the region in capitals.
In D2:D7, build each rep’s login from columns A and B in lower case. In E2:E7, write the region from column C in upper case, for example WEST.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | First name | Last name | Region | Login | Team tag | |||
| 2 | Chloe | Martin | West | |||||
| 3 | Lena | Fischer | West | |||||
| 4 | Ana | Lopez | East | |||||
| 5 | Omar | Haddad | South | |||||
| 6 | Hannah | Cole | South | |||||
| 7 | Ivan | Kolev | North | |||||
| 8 | ||||||||
| 9 | ||||||||
| 10 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe