Which of the following is an example of a formula with an absolute address?
A) =G13*G13
B) =G13+G14
C) =$G13+$G14
D) =$G$13+$G$14

Question

Quizplus · Accepted Answer

The formula =$G$13+$G$14 contains absolute addresses for both cells G13 and G14, indicated by the dollar signs ($). This means that when the formula is copied to other cells, the references to G13 and G14 will not change. Option A is a formula with a relative address as the cell reference changes depending on where the formula is copied. Option B is also a formula with relative addresses, and option C has an absolute column reference but a relative row reference.

Which of the Following Is an Example of a Formula