Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Joining text with &. The & operator glues texts together. Text you type yourself goes in double quotes, so a space is written " ". You can chain as many pieces as you like: a cell, a typed piece, another cell.
=B2&"-"&C2 gives 50001-West for order 50001 in West
The HR export of Brightline’s sales reps has first and last names in separate columns. The commission sheet needs one full name per rep.
In C2:C9, join the first name in column A and the last name in column B with one space between them, for example Tom Becker.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | First name | Last name | Full name | |||||
| 2 | Tom | Becker | ||||||
| 3 | Sofia | Lind | ||||||
| 4 | Ivan | Kolev | ||||||
| 5 | Jade | Turner | ||||||
| 6 | Luis | Romero | ||||||
| 7 | Hannah | Cole | ||||||
| 8 | Omar | Haddad | ||||||
| 9 | Ana | Lopez | ||||||
| 10 | ||||||||
| 11 | ||||||||
| 12 |
=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