Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Each order needs the regional manager's name for follow-up.
In C2:C11, look up the manager for each order's region from the table in F1:G5.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Manager | Region | Manager | |||
| 2 | 51127 | West | North | Elena Petrova | ||||
| 3 | 51126 | West | South | Marcus Hill | ||||
| 4 | 51125 | West | East | Priya Raman | ||||
| 5 | 51124 | West | West | Daniel Ortiz | ||||
| 6 | 51123 | West | ||||||
| 7 | 51122 | West | ||||||
| 8 | 51121 | West | ||||||
| 9 | 51120 | West | ||||||
| 10 | 51119 | West | ||||||
| 11 | 51118 | West | ||||||
| 12 | ||||||||
| 13 | ||||||||
| 14 |
=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