Cell D5 contains the formula =$B$5+C5 and this formula is copied to cell E5, what will be thecopied formula in cell E5?

Break Down the Problem

1. The formula in cell D5 is =$B$5+C5.
2. When this formula is copied to another cell (E5), we need to analyze how cell referencing works.

Relevant Concepts

1. Absolute Reference: The dollar sign ($) before the column (B) and row (5) indicates that this is an absolute reference. It means that when the formula is copied, the reference to cell B5 won't change.
2. Relative Reference: The reference C5 is a relative reference, which means that it will change depending on where the formula is placed.

Analysis and Detail

1. In the original formula =$B$5+C5, $B$5 will remain unchanged regardless of where it is copied.
2. When moving from column D to column E, the relative reference C5 will change to D5 because cell C5 is to the left of cell D5.

Verify and Summarize

• After copying the formula from D5 to E5:
  • The absolute reference $B$5 remains the same.
  • The relative reference C5 changes to D5.

Final Answer

Thus, the copied formula in cell E5 will be: $= \$B\$5 + D5$