_______ symbol is used to keep the cell reference constant in MS-Excel application.
A$
B#
C=
D/
Answer:
A. $
Read Explanation:
• The dollar sign ($) symbol is used to keep a cell reference constant in MS Excel. • When you place a $ before the column letter or the row number in a formula, it turns a relative reference into an absolute reference. • This ensures that when you copy or drag the formula to other cells, the specific row or column reference remains locked and does not change. How It Works: A1 (Relative): Both column and row change when copied. $A$1 (Absolute): Both column and row remain completely locked. $A1 or A$1 (Mixed): Only the column or only the row remains locked. • You can quickly toggle through these absolute and mixed references by selecting the cell reference in the formula bar and pressing the F4 key.