What is the function of the '$' sign in Excel formulas?
A. It denotes a currency format
B. It is used for concatenation
C. It creates an absolute reference
D. It indicates a named range
Answer: Option C
Solution (By JKSSB Mock Tests)
The dollar sign ($) is used to create absolute references (e.g., $A$1) that do not change when the formula is copied. It can also be used for currency formatting when applied as a number format, but in formulas it's for absolute references.
No comments yet. Be the first to start the discussion!