Question

5. The formula in cell A2 is =B2+C3. On copying this for
to cell C2, C2 will change to​

Answer 1

Answer:

C2 =D2+E3

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+E3 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

Answer 2

Answer:

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