Which of the following symbols is used to denote a relative cell reference in a formula in MS Excel?

The correct answer is $

Key Points

• The dollar sign ($) is used to denote a relative cell reference in a formula in MS Excel.
• Relative cell references adjust the cell reference when the formula is copied or moved to another cell.
• For example, if a formula in cell A1 is copied to cell B1, a relative reference will update from A1 to B1.
• Using the dollar sign ($) before the column letter or row number makes it an absolute reference, which does not change when copied.

Important Points

• Relative references in Excel are crucial for creating formulas that can be copied across multiple cells.
• The use of the dollar sign ($) ensures that specific parts of the cell reference remain constant.
• Understanding the difference between relative and absolute references is fundamental for efficient spreadsheet management.