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.0k 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
7.4k points