An example of absolute cell reference
Answers
Answer:
Examples of an absolute cell reference
Absolute column and absolute row reference
=$A$2
The above formula is telling the spreadsheet program to show the value of cell A1 in the current cell. For example, if we were using the above Excel spreadsheet and entered this formula into cell B8, it would always show "100" since that is the current value in cell A2.
What makes the absolute cell reference different than a relative cell reference (e.g., =A2) is that if we copied the cell formula in B8 and placed it in B9, it would still be "100." A relative cell reference would use the next relative cell for its value, which would have been cell A3 and would have a value of "101" in the cell.
Relative column and absolute row reference
=A$2
The above formula is using a relative column with an absolute row reference. If the cell formula was copied, the row would always remain the same (2), but the column would be relative to where it is being copied.
Absolute column with a relative row reference
=$A2
The above formula is using an absolute column reference with a relative row reference. If the cell formula was copied, the column would always remain the same (A), but the row would be relative to where it is being copied.
Absolute cell reference with a relative cell reference
=SUM($A$2+B2)
Finally, the above formula always uses the value in A2, but add that value to the next relative cell. If the cell formula was copied from C2 to C3, it would become "=SUM($A$2+B3)."
Explanation: