Write the difference between a relative reference formula and an absolute reference formula in a spreadsheet.

A Relative Reference formula changes its cell references based on its position when copied to another cell. This makes it flexible for copying and pasting in different cells.

For example, if we have a formula in cell C1 as $= \text{A1} + \text{B1}$ and copy it to cell C2, the formula in C2 will automatically adjust to $= \text{A2} + \text{B2}$. The references will adjust relative to the original position.

An Absolute Reference formula maintains fixed cell references regardless of its position when copied to another cell. It utilizes dollar signs $(\text{\textdollar})$ to anchor the references, ensuring they do not change.

For example, if we have a formula in cell C1 as $= \text{\textdollar A\textdollar1} + \text{\textdollar B\textdollar1}$ and copy it to cell C2, the formula in C2 will remain as $= \text{\textdollar A\textdollar1} + \text{\textdollar B\textdollar1}$. The references do not adjust; they stay fixed as these are absolute references.