Report Bug

Qus: In a computer spreadsheet, absolute cell reference can be represented as :

Qusकंप्यूटर स्प्रेडशीट में, एब्सोल्यूट सेल एड्रेस को इस प्रकार दर्शाया जा सकता है:


A. A3
B. $A$3
C. A$3
D. $A3


Solution
B. $A$3



Explanation

In spreadsheet, an absolute cell reference is represented by using the dollar sign ($) before the column letter and row number. This helps to fix the reference to a specific cell when copying the formula to other cells.