What is the function of the '$' sign in Excel formulas?
A. It creates an absolute reference
B. It is used for concatenation
C. It denotes a currency format
D. It indicates a named range
Answer: Option A
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!