Computer Applications
How would you refer to the range starting from 1st column, 1st row and spread till 6th column and 3rd row ?
- [E3 : A1]
- [A1 : E3]
- [I6 : A1]
- [A1 : F3]
OOo Calc
1 Like
Answer
[A1 : F3]
Reason — The cell address of 1st column, 1st row is A1 and the cell address of 6th column and 3rd row is F3. Since a range is specified by giving the addresses of the first cell and the last cell in the range, the range will be referred as [A1 : F3].
Answered By
2 Likes
Related Questions
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
The keyboard shortcut for Copy is ……………. and for Paste is …………….. .
- Ctrl + C
- Ctrl + X
- Ctrl + A
- Ctrl + V
When you …………….. or …………….. , the selected range gets surrounded by a moving border.
- Copy, Paste
- Copy
- Cut
- Cut, Paste