Question

Which column and row references are updated when you copy the formula: =SUM($B5:D$15)?

Answer 1

The row in $B5 and the column in D$15.

Step-by-step explanation:

The "$" sign that is placed next to a column or row indicates that it will be maintained constant. According to this, in $B5 the column B will be constant and the row will be updated. In D$15 the row 15 will remain constant and the column will be updated.

Answer 2

The '$' sign in front of the row or column indicates that these remain constant during the paste operation. Therefore in SUM($B5:D$15), the past would only update the row in '$B5' and the column in 'D$15'.