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.

Cell address A$4 in a formula means it is a :

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

How would you refer to the range starting from 1^st column, 1^st row and spread till 6^th column and 3^rd row ?

1. [E3 : A1]
2. [A1 : E3]
3. [I6 : A1]
4. [A1 : F3]