What symbol is used for absolute cell referencing?

In Microsoft Excel, the dollar sign ($) is used for absolute cell referencing. Absolute references keep a specific cell fixed when copying formulas to other cells. This means that no matter where you copy the formula, the cell reference with... Read More

1 MS OFFICE MCQS

What symbol is used for absolute cell referencing?

  • $
  • &
  • @
  • #
Correct Answer: A. $

Detailed Explanation

In Microsoft Excel, the dollar sign ($) is used for absolute cell referencing. Absolute references keep a specific cell fixed when copying formulas to other cells. This means that no matter where you copy the formula, the cell reference with $ remains constant.


For example:




  • $A$1 is an absolute reference to cell A1.




  • When copied, it will always refer to cell A1, unlike a relative reference (A1), which changes based on the formula's new location.



Discussion

Thank you for your comment! Our admin will review it soon.
No comments yet. Be the first to comment!

Leave a Comment