Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
What counts as revenue. At Brightline, revenue counts completed orders only. Refunded and cancelled orders stay in the data, but they are not revenue. Before you trust a total, check which statuses it includes.
=COUNTIFS(B2:B30,"North",C2:C30,"completed") counts North’s completed orders
The AI assistant totalled June revenue by region for the finance report. Finance says every region is higher than their numbers.
AI assistant: “I used SUMIF to add up each region’s order values. June revenue by region is in G2:G5.”
Check G2:G5 and fix the formulas so each region shows its real revenue.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Status | Value | Region | Revenue | ||
| 2 | 50486 | East | cancelled | 110 | North | 1417.82AI | ||
| 3 | 50487 | South | completed | 260.2 | South | 795.15AI | ||
| 4 | 50490 | North | completed | 194.82 | East | 555.5AI | ||
| 5 | 50492 | West | completed | 259.75 | West | 850.25AI | ||
| 6 | 50497 | North | completed | 312 | ||||
| 7 | 50505 | East | completed | 445.5 | ||||
| 8 | 50508 | North | refunded | 271.8 | ||||
| 9 | 50513 | North | completed | 639.2 | ||||
| 10 | 50515 | West | completed | 359 | ||||
| 11 | 50517 | South | refunded | 343.7 | ||||
| 12 | 50520 | South | completed | 191.25 | ||||
| 13 | 50526 | West | refunded | 231.5 | ||||
| 14 | ||||||||
| 15 | ||||||||
| 16 |
=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