एब्सोल्यूट सेल रेफरेंसिंग हमेशा स्प्रेडशीट में एक ही सेल को संदर्भित करता है।
Absolute cell referencing always refer to the same cell in spreadsheet.
A)
B)
Explanation:
Absolute cell referencing in a spreadsheet (like Excel or Google Sheets) always refers to the same cell, regardless of where the formula is copied or moved. It is denoted by a dollar sign ($
), such as $A$1
, where both the column and row are fixed.
For example:
- In a formula like
=$A$1 + 5
, if you copy that formula to another cell, it will always reference cell A1, no matter where the formula is placed.