Question

8. Cell address $A4 in a formula means it is a :
(a) Mixed cell reference
(b) Absolute cell reference
(c) Relative cell reference
(d) All the above
9. Cell address A$4 in a formula means it is a :
(a) Mixed cell reference
(b) Absolute cell reference
(c) Relative cell reference
(d) None of the above​

Answer 1

Answer:

(b)

Explanation:

Absolute cell reference

Answer 2

Answer:

absolute cell reference.

When a formula appears =A$4 the column is relative and the row is fixed. When a formula appears =$A$4 the column is fixed and the row is fixed. Absolute cell references do not change when a formula is copied from one cell to another.