Question

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

Answer 1

Answer:

Answer. 1 )$B$5+D5 Hope it will help you .

Answer 2

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

• In MS-Excel we use the symbol $ for absolute cell addresses, which does not change when copied to other cells.
• In the given formula = $B$5+C5 '$' is used twice with column and row name both, so both will remain constant when copied to another cell.
• Cell C5 which is written in the formula in D5 is not constant, so it will change with change in the rows.
• The formula = $B$5+C5  when copied to E5 will become = $B$5+D5.

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