When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ____.
A) =$A$3+$A$4
B) =$B$5+$B$6
C) =A3+A4
D) =$B$3+$B$4

Name: When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ____. A) =$A$3+$A$4 B) =$B$5+$B$6 C) =A3+A4 D) =$B$3+$B$4
Brand: Quizplus
Rating: 4.9 (31 reviews)

Question

Quizplus · Accepted Answer

The formula =$A$3+$A$4 uses absolute references, which do not change when copied to another cell. Therefore, when copied to cell B7, the formula remains =$A$3+$A$4.

When the Formula =$A$3+$A$4 in Cell A5 Is Copied to Cell