When you copy and paste a formula one cell below its current spreadsheet location,the cells referenced in the formula 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 is an example of a relative reference, as the cells referenced in the formula change relative to their new location. Absolute references use dollar signs to indicate cells that should remain constant when copied or moved. Functions and links are different concepts altogether.

When You Copy and Paste a Formula One Cell Below