SolveNCERT
SolveNCERT
HomeSolutionsInformation TechnologyCh 4Solve the Following in a Spreadsheet
Class 9 · Information TechnologyNCERT 2026 Revised Syllabus

Chapter 4: Electronic Spreadsheet (17925CH04)

Solve the Following in a Spreadsheet — 5 questions with step-by-step answers.

Solve the Following in a Spreadsheet(5 questions)

1

Cell A1 contains the number 10 and B1 contains 5. What will be the contents of cell C1, if the formula =A1+B1*2^3 is entered in cell C1?

School Level Solution

Ans.
Following BODMAS order: 2^3=8, B18=58=40, then A1+40 = 10+40 = 50. So cell C1 will show 50.
2

The contents of Cell A1, B1, C1 and D1 are 5, –25, 30 and –35, respectively. What will be the value displayed in cell E1 which contains the formula =MIN(A1:D1).

School Level Solution

Ans.
MIN(A1:D1) finds the smallest value among 5, –25, 30 and –35. The smallest value is –35, so cell E1 will display –35.
3

Cell D5 contains the formula =$B$5+C5 and this formula is copied to cell E5, what will be the copied formula in cell E5?

School Level Solution

Ans.
=$B$5+D5 — the absolute reference $B$5 stays fixed, while the relative reference C5 changes to D5 as the column shifts by one.
4

Cell D5 contains the formula =$B5 + C5 and this formula is copied to cell E5, what will be the copied formula in cell E5?

School Level Solution

Ans.
=$B5+D5 — the column part of$B5 (mixed reference) stays fixed at B, and the relative reference C5 changes to D5.
5

Cell D5 contains the formula =$B5 + C$5 and this formula is copied to cell E6, what will be the copied formula in cell E6?

School Level Solution

Ans.
=$B6+D$5 — in $B5 the column B is fixed but row changes to 6; in C$5 the row 5 is fixed but column changes to D.

Other Chapters