JOIN NOW

Computer Applications

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

OOo Calc

2 Likes

Answer

Mixed cell reference

Reason — Cell address A$4 in a formula means it is a Mixed cell reference because the column A is relative while the row 4 is absolute. Thus, when the formula is copied to any other location, the column will change while the row will remain the same.

Answered By

2 Likes

Related Questions