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

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.