In MS Excel, what type of cell reference style is used when a formula contains a cell formatted as $C$5?
A. Relative Cell Reference
B. Absolute Cell Reference
C. Mixed Cell Reference
D. External sheet reference link
Answer: Option B
Solution (By JKSSB Mock Tests)
An absolute cell reference locks both the column letter and the row number with dollar signs ($C$5), ensuring that the reference does not change when the formula is copied to another cell.
No comments yet. Be the first to start the discussion!