In a LibreOffice Calc, absolute cell reference can be represented as :

A. A3

B. $A$3

C. A$3

D. $A3

Correct Answer is :

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.