Case 13-1
Jim is copying and pasting formulas from one area of a worksheet to another. Please answer the questions below.
-Jim is copying a formula from cell C3 to cell F3 and wants the cell references to change accordingly.He is wanting to create a(n) ____ reference.
A)relative
B)absolute
C)data
D)function

Question

Quizplus · Accepted Answer

Jim wants the cell references in the formula to change accordingly, which means he wants to create a relative reference. A relative reference adjusts the cell references in a formula as it is copied to a new location.

Case 13-1 Jim Is Copying and Pasting Formulas from One Area of Area