Which option in Microsoft Excel represents a formula with an absolute reference?
- =(B$1-B$3)
- =($A1-$B1)
- =(B$=(C$1$-F$1$)
- =($A$1-$B$1))
| Explanation & Hint:
Dollar symbols in a cell reference indicate to Microsoft Excel to treat the cell reference as absolute and to always refer to the value of the cell regardless of whether it is moved or where the formula is located. An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row. As an absolute reference was used to refer to Cell B1, the formula will automatically update to wherever the contents of this cell is moved. |