Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Rows and columns. Every cell address is a column letter and a row number. In a grid, the column header tells you what the cell measures and the row label tells you whose it is. To check an address, read up to the header and across to the label. Both must match what you asked for.
=D3 read D1 for the month and A3 for the name
Priya Raman, the East manager, asked for her August revenue target. You asked the AI assistant to pull it from the Q3 targets grid.
AI assistant: “Done! F2 shows East’s August target.”
Click F2 and read the AI’s formula. Fix it so F2 shows East’s August target by pointing at its cell.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Region | Jul target | Aug target | Sep target | East: August target | |||
| 2 | North | $6,726 | $6,616 | $6,803 | $5,006AI | |||
| 3 | South | $8,244 | $8,055 | $8,538 | ||||
| 4 | East | $5,006 | $5,102 | $4,948 | ||||
| 5 | West | $11,290 | $11,865 | $11,199 | ||||
| 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