Question

Cell D5 contains the formula =$B$5+C5 and
this formula is copied to cell E5, what will be the
copied formula in cell E5?​

Answer 1

Answer:

$B$5 will be copied over

Explanation:

as $ represents a absolute reference the formula in those will be copied over as exact, the C5 is not a absolute reference hence, won't copy the formula from that cell but from the cell near E5 and as far as the cell C5