Question

please answer
.........​

Answer 1

Answer:

the formula in cell A2 is = B2+ C3. On copying this for to cell C2, C2 will change to D2 + D3 .

Explanation:

As per given question statement, we are given a formula for a cell A2;

A2 is =B2+C3

Now if we copy this A2 formula to a new cell C2, the new formula in C2 becomes as D2+D3 when we select the normal option of paste( Paste P option) in excel.

Excel gives multiples options when pasting a field, like simple paste, keep source formatting, formula etc