Question

The formula in the cell A2 is=B2+C$3.on copying this formula to cell D2.What will the formula be

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