Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
You asked the AI assistant for West revenue and West line count. One of its formulas is wrong.
AI assistant: “Done! F2 has total West revenue and F3 counts the West lines.”
Check F2 and F3. Fix whatever is wrong so both values are correct.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Region | Category | Revenue | Metric | Value | |||
| 2 | West | Coffee & Kitchen | 59.7 | West revenue | 832AI | |||
| 3 | West | Desk Supplies | 76 | West line count | 2AI | |||
| 4 | South | Paper & Print | 756 | |||||
| 5 | South | Paper & Print | 50 | |||||
| 6 | South | Paper & Print | 33 | |||||
| 7 | South | Coffee & Kitchen | 34.2 | |||||
| 8 | North | Desk Supplies | 54.15 | |||||
| 9 | North | Desk Supplies | 48 | |||||
| 10 | North | Desk Supplies | 62 | |||||
| 11 | North | Coffee & Kitchen | 34.2 | |||||
| 12 | East | Cleaning | 15 | |||||
| 13 | East | Cleaning | 75 | |||||
| 14 | East | Desk Supplies | 9.03 | |||||
| 15 | East | Coffee & Kitchen | 108 | |||||
| 16 | South | Coffee & Kitchen | 179.1 | |||||
| 17 | ||||||||
| 18 | ||||||||
| 19 |
=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