Class 9 · Information TechnologyNCERT 2026 Revised Syllabus
Chapter 4: Electronic Spreadsheet (17925CH04)
Practical Exercise — How to Do — 10 questions with step-by-step answers.
Jump to:
Practical Exercise — How to Do(10 questions)
1
Cell addresses: first row–first column, first column–last row, first row–last column, seventh column–tenth row, tenth column–nineteenth row; in which row/column does LK89 sit? How should you answer?
School Level Solution
Ans.
Read addresses as Letters (column) + Number (row): A1; last row is 1048576 (A1048576); last column is XFD (XFD1); G = 7th letter → G10; J = 10th → J19. LK89 sits in row 89, column LK.
2
Range questions: first/last cell and A1-style range of Range1/Range2/Range3, name of row-wise and column-wise ranges, and cell count of Range3. How should you read them off the worksheet figure?
School Level Solution
Ans.
A range is top-left : bottom-right (e.g., B2:D5). A range along a row is called a row range; along a column, a column range. Count = rows × columns (e.g., 3 rows × 4 cols = 12 cells). Read each Range off Fig. 4.x the same way.
3
Evaluate by operator precedence, then verify in Calc: 8-4/2, 55+8, 3+54, 2^5+8, 3+2^2, 5+62^2, 8/44, -4/2+2, 1+2^2-2, 4*3/2. What are the results and the rule?
School Level Solution
Ans.
Apply ^ first, then ×/÷ left-to-right, then +/−: 8−2=6; 25+8=33; 3+20=23; 32+8=40; 3+4=7; 5+24=29; 2×4=8; −2+2=0; 1+4−2=3; 12/2=6. Type each with = first in Calc to verify.
4
Figure worksheets (Fig. 4.12, 4.17, 4.18): build each sheet, enter different values in the input cells (A2–C2 / B1 / B1–B2) and observe the formula columns. What should you watch?
School Level Solution
Ans.
Build the sheet exactly as figured with formulas referencing input cells. Change one input at a time and watch dependent results recalculate automatically — this live linkage is the point of the observation.
5
Functions drill (Fig. 4.22, HARMAN’s marks in 3 subjects): total in E2, average in F2, copy down; highest/lowest/count in Hindi (B7/B8/B9) and extend to English/Maths. Which formulas apply?
School Level Solution
Ans.
E2: =SUM(B2:D2); F2: =AVERAGE(B2:D2); drag the fill handle down to copy relatively. B7: =MAX(B2:B6); B9: =MIN(B2:B6); B8: =COUNT(B2:B6). Repeat MAX/MIN across the English and Maths columns.
6
Fill Handle drills (Fig. 4.30–4.33): drag days, months, natural/even/odd numbers to row 15; then =SUM(C2:G2) in H2 and =AVERAGE(C2:G2) in I2 dragged to row 11. What is the technique?
School Level Solution
Ans.
Click the seed cell(s) (select two cells for even/odd patterns) and drag the fill-handle square to row 15. For marks: type =SUM(C2:G2) in H2, =AVERAGE(C2:G2) in I2, then drag both down — references shift per row automatically.
7
Salary + range drills (Fig. 4.35/4.36 gross salary to row 11 with H12 total; Fig. 4.43 ranges, B8 totals, G3 totals, F3→F4 copy, averages; Harman science max/min/count/average in B9–B12). What is the method?
School Level Solution
Ans.
Enter D2–H2 formulas once, fill down to row 11, total in H12 with =SUM. For ranges: name the top-left:bottom-right cells; B8 total via addresses or =SUM; copy F3→F4 by drag or paste; B9–B12 via MAX/MIN/COUNT/AVERAGE down each subject column.
8
Explore tasks: count Save-As formats; 7 rainbow sheets (Violet… with matching tab colours); auto-fill negatives; two-date drag + monthly calendar; add your name to the dictionary. How?
School Level Solution
Ans.
Save As and count the format dropdown entries; reopen one to verify. + new sheets ×7, rename VIBGYOR, right-click tab → colour each. Drag negatives and 15-08-2013 + next date down 10 for series/calendar. Right-click your name → Add to Dictionary.
9
Project drills: implement a superstore-style shopping bill; your 6-subject marks sheet (total, average, %); Khushi/Diya/Kushaal list sorted by Class then name; August-birth filter. How?
School Level Solution
Ans.
Bill: item/rate/qty/amount table + =SUM total. Marks: six subjects, =SUM, =AVERAGE, % = total÷600×100. Friends list: Data → Sort by Class, then Name. August filter: Data → AutoFilter on Month-of-Birth = August.
10
Notes + validation + marksheet + charts: Help-based sorting/filtering notes; DOB 1–31 validation; school marksheet with % and grade; newspaper 3D pie; Y=3X+1 line chart; monthly bills comparison. What are the key steps?
School Level Solution
Ans.
Read Help on Sort/Filter/Validity into notes. DOB column: Data → Validity → Whole numbers 1–31. Marksheet: =AVERAGE, % and =IF grade slabs. Charts: select data → Insert → Chart (pie for newspapers, line for Y=3X+1, column/line for bills) and conclude which fits best (trends → line, shares → pie).