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

Spreadsheet Tool : OO Calc I — Question 7

Back to all questions
7
Question

Question 7

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

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

Absolute cell reference

Reason — Cell address $A$4 in a formula means it is an Absolute cell reference because the use of $ sign makes the column and row absolute, i.e., the address will not change when the formula is copied to any other cell.