72.3k views
2 votes
To make a calculation always refer to a specific cell when copying it using the fill handle, make the cell a(n).

reference.
Multiple Choice
absolute
perpetual
relative
constant

User Mosh Feu
by
7.6k points

1 Answer

2 votes

Answer:

Absolute

Step-by-step explanation:

To make a calculation always refer to a specific cell when copying it using the fill handle, you make the cell an absolute reference. Absolute references are denoted by a dollar sign ($) before the column and/or row reference, which means that the reference won't change when copied to other cells. This ensures that the formula always points to the same cell.

User Elice
by
8.0k points

No related questions found