Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Reading #DIV/0!. #DIV/0! means a formula divided by zero or by an empty cell. Often the zero is real: a month with no sales, a carrier with no late parcels. Decide what that row should honestly show, then test the divisor before dividing, or catch the error.
=IF(D5=0,"",E5/D5) cost per visit, blank with no visits
Operations compares how late each carrier’s late parcels were in December. The AI assistant’s average shows #DIV/0! for one carrier.
AI assistant: “D2:D4 has each carrier’s average days late in December.”
Fix D2:D4 so each carrier shows its average days late per late shipment (C ÷ B), rounded to 2 decimals, and an empty result ("") when it had no late shipments.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Carrier | Late shipments | Total days late | Avg days late | ||||
| 2 | Greenway Logistics | 3 | 6 | 2AI | ||||
| 3 | ParcelLine | 0 | 0 | #DIV/0!AI | ||||
| 4 | Rapid Freight | 4 | 11 | 2.75AI | ||||
| 5 | ||||||||
| 6 | ||||||||
| 7 |
=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