Okay, think of a cell like my flat here. When you copy a formula, a *relative* reference moves with it, like me carrying my guitar to a new gig. An *absolute* reference, with dollars like `$A$1`, stays fixed, like Kanchenjunga always being north. *Mixed* is one part locked, like `A$1`—the row stays, but the column can shift. I explain this using landmarks from our village so Didi can remember, because for her, "anchoring" makes sense with her vegetable stall layout, not dollars.
#exams#study
Jump in to reply — no account needed.