SolveNCERT
SolveNCERT
Class 9 · Information TechnologyNCERT 2026 Revised Syllabus

Chapter 4: Electronic Spreadsheet (17925CH04)

Fill in the Blanks — 10 questions with step-by-step answers.

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

Other Chapters