View excerpt

When copying a formula across multiple rows and columns in Excel, which type of cell reference would you use to maintain a reference to a fixed cell B$2$ while allowing other references in your formula to adjust based on the row or column position?

Select one

Absolute reference $($$$8$$$2)$

Relative reference $($B$2)$

Dynamic reference $(82$:$)$

Mixed reference $($either $582$ or BS$2)$