Dionne has attended:
Excel Introduction course
PowerPoint Introduction course
Word Intermediate course
Excel 2007
what's the difference between relative and absolute references?
RE: Excel 2007
Hi Dionne
Thank you for your question.
Relative and absolute references are cell references in a formula.
A relative cell reference changes when a formula is moved or copied to another location in your spreadsheet. By default, cell references in a formula will be relative unless you make them into an absolute reference.
An absolute cell reference does not change when a formula is moved or copied to another location in your spreadsheet. An absolute reference is recognisable in a formula as it has $ signs preceding the column letter and the row number in the cell reference, e.g. $B$4.
I hope this helps.
Amanda
Amanda