Class 9 · Information TechnologyNCERT 2026 Revised Syllabus
Chapter 4: Electronic Spreadsheet (17925CH04)
Fill in the Blanks — 10 questions with step-by-step answers.
Jump to:
Fill in the Blanks(10 questions)
1
The column immediately next to column 'Z' is ________.
School Level Solution
Ans.
AA
2
The default extension of a workbook created using a LibreOffice Calc spreadsheet is ________.
School Level Solution
Ans.
.ods
3
The spreadsheet feature used to continue the series is called as ________.
School Level Solution
Ans.
Fill handle
4
The formula '=MIN(C1:C5)' stored in cell C6 when copied to cell D6 changes to ________.
School Level Solution
Ans.
=MIN(D1:D5)
5
The formula in cell A2 is =B2+C3. On copying this formula to cell C2, C2 will change to ________.
School Level Solution
Ans.
=D2+E3
6
The cell address of the cell formed by the intersection of the ninth column and the eighth row will be ________.
School Level Solution
Ans.
I8
7
$A1$B2 is an example of ________ referencing in spreadsheet software.
School Level Solution
Ans.
mixed
8
Numbers entered into a cell are automatically ________ aligned.
School Level Solution
Ans.
right
9
If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5;60) will display ________.
School Level Solution
Ans.
20
10
In ________ referencing, the reference changes rows and columns automatically when it is copied to a new cell.
School Level Solution
Ans.
Relative