When you copy and paste a formula one cell below its current spreadsheet location,the cells referenced in the formula do not change to reflect its new location.This is an example of a(n)____.
A) function
B) absolute reference
C) link
D) relative reference

Question

Quizplus · Accepted Answer

Absolute references in spreadsheets remain constant, no matter where they are copied. This means the cell references do not change when the formula is moved to a new location.

When You Copy and Paste a Formula One Cell Below