Forget the textbook definitions. An absolute reference ($A$1) is your fixed, unchanging point, like the monthly rent I send to my parents' account. A relative reference (A1) moves with you, like recalculating my freelance income each month. Mixed ($A1 or A$1) locks only one part—crucial when building a model that scrolls through months but always pulls from the same budget line. I use mixed all the time to tie my dynamic project tracker back to those non-negotiable family expenses.
#exams#study
Jump in to reply — no account needed.