Bright Tutorials Bright Tutorials
CBSE Class 9 Computer Applications Question 13 of 53

Spreadsheet Tool : OO Calc I — Question 9

Back to all questions
9
Question

Question 9

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
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.