Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
The AI assistant assigned East customers a loyalty tier from their 2025 revenue: Bronze from 0, Silver from 2,000, Gold from 5,000. Priya Raman sees tiny accounts marked Silver and the two biggest showing #N/A.
AI assistant: “I used XLOOKUP with an approximate match against the tier table, so every customer falls into a band even when their revenue isn’t an exact threshold.”
Check the AI’s formulas in C2:C24 and fix them so each customer gets the highest tier in F2:G4 whose “From” value their revenue in B2:B24 reaches.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Customer | Revenue 2025 | Tier | From | Tier | |||
| 2 | Atlas Realty | 7,682.08 | #N/AAI | 0 | Bronze | |||
| 3 | Beacon Hotels | 793.11 | SilverAI | 2,000 | Silver | |||
| 4 | Blue Motors | 4,157.33 | GoldAI | 5,000 | Gold | |||
| 5 | Bright Hotels | 1,167.88 | SilverAI | |||||
| 6 | Bright Motors | 839.12 | SilverAI | |||||
| 7 | Cedar Labs | 1,114.29 | SilverAI | |||||
| 8 | Copper Labs | 720.85 | SilverAI | |||||
| 9 | Falcon Dental | 2,574.20 | GoldAI | |||||
| 10 | Granite Clinic | 1,762.70 | SilverAI | |||||
| 11 | Harbor Bakery | 1,151.45 | SilverAI | |||||
| 12 | Harbor Dental | 4,470.13 | GoldAI | |||||
| 13 | Harbor Labs | 3,703.34 | GoldAI | |||||
| 14 | Harbor Studios | 4,435.94 | GoldAI | |||||
| 15 | Lakeside Studios | 2,471.15 | GoldAI | |||||
| 16 | Maple Academy | 3,402.44 | GoldAI | |||||
| 17 | Maple Bakery | 1,131.81 | SilverAI | |||||
| 18 | Meadow Consulting | 1,101.08 | SilverAI | |||||
| 19 | Oak Academy | 7,645.20 | #N/AAI | |||||
| 20 | Oak Bakery | 4,471.66 | GoldAI | |||||
| 21 | River Dental | 2,121.79 | GoldAI | |||||
| 22 | River Law Group | 1,226.04 | SilverAI | |||||
| 23 | Silver Academy | 1,404.12 | SilverAI | |||||
| 24 | Willow Law Group | 1,216.15 | SilverAI | |||||
| 25 | ||||||||
| 26 | ||||||||
| 27 |
=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