Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
CONCAT. CONCAT(text1, text2, …) joins all its arguments in order, the same as chaining them with &. Typed pieces such as brackets and spaces still go in double quotes. CONCATENATE is the older name for the same idea.
=CONCAT("Order ",A2," / ",B2) gives Order 50001 / WestThe quarterly leaderboard shows each sales rep with their region in brackets, like Tom Becker (North), so managers can find their team at a glance.
In C2:C9, use CONCAT to build a label from the name in column A and the region in column B, in the form Tom Becker (North).
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Rep | Region | Label | |||||
| 2 | Tom Becker | North | ||||||
| 3 | Sofia Lind | North | ||||||
| 4 | Jade Turner | South | ||||||
| 5 | Luis Romero | South | ||||||
| 6 | Ben Carter | East | ||||||
| 7 | Mei Chen | East | ||||||
| 8 | Noah Brooks | West | ||||||
| 9 | Ravi Shah | West | ||||||
| 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