In a computer spreadsheet absolute cell reference can be represented as

A. A3

B. $A$3

C. A$3

D. $A3

Correct Answer

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.