Consider a formula "= D3 + C5" in cell B4. If cell B4 is copied and pasted into F10, then what will be the formula in cell F10?

Correct option is A

When you copy and paste the formula =D3 + C5 from cell B4 to cell F10, the references are adjusted relative to the new location. Since both D3 and C5 are relative references, they will shift based on the difference in rows and columns between B4 and F10.
· B4 to F10: The formula moves 4 columns to the right (from B to F) and 6 rows down (from 4 to 10).
· D3 moves 4 columns to the right, becoming E3.
· C5 moves 4 columns to the right, becoming D5.
Therefore, the formula in F10 will be =E3 + D5.
Important Key Points:
1. Relative References: In Excel, when you copy a formula with relative references, the references automatically adjust based on the relative movement of rows and columns.
2. Formula Adjustment: The formula =D3 + C5 is translated into =E3 + D5 when moved from B4 to F10.
Knowledge Booster:
· Absolute References: If the formula used absolute references (e.g., $D$3), the references would not change when the formula is copied to another cell.
· Mixed References: If a formula had mixed references (e.g., $D3 or D$3), only part of the reference would adjust upon copying and pasting.