Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Mixed references in a grid. In a two-way grid, each formula must read its row header and its column header. $A4 locks the column but lets the row move, so it always reads the rate in column A. B$3 locks the row but lets the column move, so it always reads the term in row 3. Fixed inputs get both: $B$1.
=$A5*F$2 a price grid: unit price down column A, quantities across row 2
For the van decision, finance wants a grid of monthly payments on the loan in B1: annual rates down A4:A7 and loan terms in years across B3:D3. The AI assistant wrote B4 and filled it across and down. B4 looks fine; the rest doesn’t.
AI assistant: “Done! I wrote the payment formula in B4 and filled it across and down, so B4:D7 covers every rate and term.”
Check the AI’s formulas in B4:D7 and fix them so every cell shows the monthly payment for the rate in its row and the term in its column, as a positive number.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Loan | $38,000 | ||||||
| 2 | ||||||||
| 3 | Rate \ Years | 3 | 4 | 5 | ||||
| 4 | 5.0% | $1,138.89AI | $3,606,497.95AI | $11,420,576,846.72AI | ||||
| 5 | 6.0% | $190.00AI | $601,666.67AI | $1,905,277,777.78AI | ||||
| 6 | 7.0% | $221.67AI | $701,945.67AI | $2,222,827,942.83AI | ||||
| 7 | 8.0% | $253.33AI | $802,222.24AI | $2,540,370,423.94AI | ||||
| 8 | ||||||||
| 9 | ||||||||
| 10 |
=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