When cell A3 containing the formula =$A$5+$B$6 is copied to cell G7,the formula in cell G7 is =$G$9+$H$10.

Name: When cell A3 containing the formula =$A$5+$B$6 is copied to cell G7,the formula in cell G7 is =$G$9+$H$10.
Brand: Quizplus
Rating: 4.9 (38 reviews)

Question

Quizplus · Accepted Answer

When a formula containing absolute cell references (with $ signs) is copied to another cell, the absolute references do not change. Therefore, if cell A3 containing the formula =$A$5+$B$6 is copied to cell G7, the formula in cell G7 will still be =$A$5+$B$6, not =$G$9+$H$10.

When Cell A3 Containing the Formula =$A$5+$B$6 Is Copied to Cell