In …………… referencing the relative address of the cell gets adjusted w.r.t. the current cell.

1. Relative
2. Absolute
3. Mixed
4. Nil

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

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

Cell address A4 in a formula means it is a :

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

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.