Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Priya Raman is pricing new shelving for the East warehouse on a three-year loan. The AI assistant worked out the monthly payment, and it looks steep for a loan this size.
AI assistant: “Done! B5 is the monthly payment on the shelving loan, using the rate and term in B2 and B3.”
Check the AI’s formula in B5 and fix it so it returns the correct monthly payment, as a positive number, from the inputs in B1:B3.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Loan amount | $24,000 | ||||||
| 2 | Annual rate | 5.9% | ||||||
| 3 | Years | 3 | ||||||
| 4 | ||||||||
| 5 | Monthly payment | $1,621.96AI | ||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 |
=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