Computer Applications
Cell address A4 in a formula means it is a :
- Mixed cell reference
- Absolute cell reference
- Relative cell reference
- All the above.
OOo Calc
3 Likes
Answer
Absolute cell reference
Reason — Cell address 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.
Answered By
2 Likes
Related Questions
Calc worksheets are given …………… extension.
- .odf
- [= sign]
- .ods
- .odw
Cell address A4 in a formula means it is a :
- Mixed cell reference
- Absolute cell reference
- Relative cell reference
- None of the above
Cell address $A4 in a formula means it is a :
- Mixed cell reference
- Absolute cell reference
- Relative cell reference
- All the above.
Cell address A$4 in a formula means it is a :
- Mixed cell reference
- Absolute cell reference
- Relative cell reference
- None of the above