🚀 Hurry! Offer Ends In
00 Days
00 Hours
00 Mins
00 Secs
Enroll Now
X

एब्सोल्यूट सेल रेफरेंसिंग हमेशा स्प्रेडशीट में एक ही सेल को संदर्भित करता है।

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.
Latest Updates