Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Customer success gives Gold service to customers who spent at least 5,000 in 2025 and Silver to those who spent at least 2,000. The AI assistant tiered the list, and not one customer came out Gold.
AI assistant: “I tiered every customer in D2:D11 with IFS: Gold from 5,000, Silver from 2,000, Bronze below that.”
Check the AI’s formulas in D2:D11 and fix them: "Gold" for at least 5,000, "Silver" for at least 2,000, "Bronze" otherwise.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Customer | Segment | 2025 revenue | Tier | ||||
| 2 | Orchard Clinic | Enterprise | $12,170.74 | SilverAI | ||||
| 3 | Harbor Labs | Mid-Market | $3,703.34 | SilverAI | ||||
| 4 | Cedar Accounting | SMB | $1,846.23 | BronzeAI | ||||
| 5 | Atlas Realty | Mid-Market | $7,682.08 | SilverAI | ||||
| 6 | Oak Studios | SMB | $2,542.60 | SilverAI | ||||
| 7 | Maple Consulting | SMB | $1,587.23 | BronzeAI | ||||
| 8 | Orchard Print Co | Mid-Market | $5,743.66 | SilverAI | ||||
| 9 | Bright Fitness | SMB | $2,269.48 | SilverAI | ||||
| 10 | Orchard Logistics | SMB | $1,254.95 | BronzeAI | ||||
| 11 | Bright Motors | SMB | $839.12 | BronzeAI | ||||
| 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