Anne has attended:
Excel Intermediate course
Excel Advanced course
Relative References
What can relative references be used for?
RE: Relative References
Hello Anne
Thank you for your question.
A relative reference is a cell reference in a formula that will change to a different reference when the formula is copied to other cells in the spreadsheet.
This is generally useful as it allows you to create a formula and reuse it in other places in your spreadsheet.
You are also able to create absolute references and mixed references in formulas.
Kind regards
Amanda