In MS-EXCEL, a formula = B$1+ C$3+ 5 in cell D9 when copied to cell F12 will become:

Choose the correct answer from the options given below: ​​

Correct option is D

In MS-Excel, when a formula is copied to another cell, the references in the formula change based on the relative or absolute reference type. The dollar sign $ indicates an absolute reference, meaning the row or column will not change when the formula is copied to another cell. Here's the breakdown:
· B$1 is an absolute reference to row 1, so when the formula is copied to another cell, the column (B) changes, but the row (1) remains fixed.
· C$3 is an absolute reference to row 3, so when copied, the column (C) changes, but the row (3) stays fixed.
· The constant 5 remains unchanged regardless of where the formula is copied.
When copying the formula from D9 to F12:
· The B$1 reference moves from column B to column D, so it becomes D$1.
· The C$3 reference moves from column C to column E, so it becomes E$3.
· The constant 5 stays as is.
Thus, the new formula in cell F12 will be: = D$1 + E$3 + 5
Information Booster:
1. Absolute References: In Excel, the dollar sign $ is used to fix a reference to a specific row or column. For example, $A$1 fixes both the row and column, A$1 fixes the row, and $A1 fixes the column.
2. Relative References: If there is no dollar sign, the reference is relative. This means that both the row and column can change when the formula is copied to another cell.
3. Mixed References: We can use mixed references (e.g., A$1 or $A1) to lock either the row or the column while allowing the other part to adjust when copied.
Additional Knowledge:
Copying Formulas: When you copy a formula across multiple cells in Excel, understanding how references work (relative vs. absolute) can help you avoid errors and ensure that formulas work as intended.