Question

Suppose you have the formula =$D$5*E5 in cell F5. When you copy the formula into cell F6 what will the new formula be?

a. =$D$5*E5

b. =D5*E6

c. =$D$5*E6

d. =$D$6*E6

Answer 1

C. =$D$5*E6

Explanation:

In excel Columns are A, B, C, D, .....

And, rows are, 1, 2, 3, ....

Also, the intersection of column and row is called cell,

eg : A1 is a cell,

When we copy a function formula from a cell A1 to B2,

Then in the formula we replace A1 by B2 or vice versa,

But the row or column which comes after the dollar sign is anchored or absolute.

That is, when we copy an excel formula with $ sign they will copy cells referred in that formula relative to the position where they are being copied to.

Thus, if we have the formula =$D$5*E5 in cell F5,

Then, $D$5*E6 must be the new formula into cell 6.

Option 'C' is correct.