To create an absolute cell reference …………… sign is used before the parts of formula.

1. $ sign
2. #
3. ^
4. %

Calc worksheets are given …………… extension.

1. .odf
2. [= sign]
3. .ods
4. .odw

Cell address $\text{\textdollar}$A$\text{\textdollar}$4 in a formula means it is a :

1. Mixed cell reference
2. Absolute cell reference
3. Relative cell reference
4. All the above.

Cell address $A4 in a formula means it is a :

1. Mixed cell reference
2. Absolute cell reference
3. Relative cell reference
4. All the above.