What type of cell reference should be used when a value remains constant?
A)Absolute
B)Relative
C)Mixed
D)Constant

Name: What type of cell reference should be used when a value remains constant? A)Absolute B)Relative C)Mixed D)Constant
Brand: Quizplus
Rating: 4.7 (30 reviews)

Question

Quizplus · Accepted Answer

When a value needs to remain constant in a formula, an absolute cell reference should be used. This ensures that the cell reference does not change when the formula is copied or filled down to other cells.

What Type of Cell Reference Should Be Used When a Value