Question

If the cell reference $a5 in a formula is copied and pasted over two columns and down two rows from its original cell, what the cell reference become in the new cell. $a5 $a7 $c5 $c7

Answer 1

When the cell reference $a5 is moved two columns to the right and two rows down, it changes to $a7 because the column is absolute and doesn't change, while the row is relative and increments by two.

Step-by-step explanation:

If the cell reference $a5 in a formula is copied and pasted over two columns and down two rows from its original cell, the dollar sign in the reference indicates that the column reference is absolute, meaning it will not change. However, since the row reference does not have a dollar sign in front of it, it is relative and will change. Therefore, after moving the cell reference over two columns to the right and down two rows, the column stays the same (A), but the row increases by two (5 + 2), resulting in the new cell reference being $a7.

Answer 2

Answer;
$A7
If cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell, the cell reference in the new cell becomes $A7.

Explanation;
Absolute cell reference is a cell address that contains a dollar sign, $, in the row or column coordinate, or both. such that when you enter a cell reference in a formula, the Excel assumes it is a relative reference unless you change it to an absolute reference.