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

Question

UkoKoshka [18]

3 years ago

7

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

Biology

1 answer:

san4es73 [151] · Answer 1 · 2022-03-09T21:23:14+03:00

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.