When you copy and paste a formula one cell below its current spreadsheet location,the cell range in the formula does 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

This behavior is characteristic of an absolute reference in spreadsheet formulas, where the cell reference does not change when the formula is copied to a new location.

When You Copy and Paste a Formula One Cell Below