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.
Jump to:
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.
3Cell D5 contains the formula =
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.5Cell D5 contains the formula =
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.