The formula =B1+B2+B3+B4 is copied from cell B5 to cell C5.What is the formula found in cell C5 after the copy is complete?
A) =B1+B2+B3+B4
B) =C1+C2+C3+C4
C) =B5
D) none of the above

Question

Quizplus · Accepted Answer

When a formula is copied from one cell to another in Excel, the cell references are adjusted relative to the position of the new cell. Since the original formula in B5 adds the cells directly above it (B1 to B4), when copied to C5, the formula adjusts to add the cells directly above C5, which are C1 to C4.

The Formula =B1+B2+B3+B4 Is Copied from Cell B5 to Cell