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

Spreadsheet Tool : OO Calc I — Question 8

Back to all questions
8
Question

Question 8

Cell address $A4 in a formula means it is a :

  1. Mixed cell reference
  2. Absolute cell reference
  3. Relative cell reference
  4. All the above.
Answer

Mixed cell reference

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