Asked by julia lavergne on Sep 24, 2024
Verified
Which of the following formulas contains an absolute cell reference?
A) =$B4
B) =B$4
C) =$B$4
D) =B4
Absolute Cell Reference
In spreadsheet applications, a cell reference that remains constant even if the formula is copied to a different location.
- Master the use of advanced Excel functions such as nested IF statements and absolute cell references.
Verified Answer
JH
Jawad Hussain1 day ago
Final Answer :
C
Explanation :
The formula =$B$4 contains an absolute cell reference because both the column and row are locked with a dollar sign, meaning that no matter where the formula is copied or dragged, it will always refer to cell B4. Choices A and D contain relative cell references, meaning that the row or column can change when the formula is copied or dragged. Choice B contains an absolute column reference but a relative row reference.
Learning Objectives
- Master the use of advanced Excel functions such as nested IF statements and absolute cell references.