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

Spreadsheet Tool : OO Calc I — Question 10

Back to all questions
10
Question

Question 10

How would you refer to the range starting from 1st column, 1st row and spread till 6th column and 3rd row ?

  1. [E3 : A1]
  2. [A1 : E3]
  3. [I6 : A1]
  4. [A1 : F3]
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].