Which of the following formulas santains an absolute cell reference?
A) =$B4
B) =B$4
C) =$B$4
D) =B4

Question

Quizplus · Accepted Answer

An absolute cell reference is used to refer to a specific cell in a worksheet, regardless of where the formula is copied or moved. In the formula =$B$4, the dollar signs ($) before the column letter and row number indicate that the reference is absolute. This means that when the formula is copied or moved, the cell reference will not change.

Which of the Following Formulas Santains an Absolute Cell Reference