An example of a formula with an absolute reference is
A)=B4*B5.
B)=^b^4*^b^5.
C)=@b@4*@b@5.
D)=$b$4*$b$5.

Name: An example of a formula with an absolute reference is A)=B4*B5. B)=^b^4*^b^5. C)=@b@4*@b@5. D)=$b$4*$b$5.
Brand: Quizplus
Rating: 4.9 (36 reviews)

Question

Quizplus · Accepted Answer

The symbols "$" before "b" and "4" and "5" create an absolute reference. This means that when the formula is copied and pasted to other cells, the cell references "$b$4" and "$b$5" will remain constant, rather than changing based on their relative position to the copied formula.

An Example of a Formula with an Absolute Reference Is