EN हिं

NCERT Solutions Ganita Prakash (Part 2) Chapter 5 –113Spreadsheets — In-text Questions

Book page 112 Updated on2026-09-05

Q1.
Can you tell which cell has the marks obtained by Farooq in Mathematics?
Answer

Cell E5.

Columns: A = Name, B = Odia, C = Telugu, D = English, E = Maths, F = Social Science, G = Science
Rows: 1 = the headings, 2 = Ratna, 3 = Nagesh, 4 = Ashwin, 5 = Farooq
Column E, row 5 → E5, which holds 42
Tip: a cell name is always column letter first, then row number. Read across to find the letter and down to find the number, and the two meet at the cell you want.
Q2.
Can you tell what data is in column B7?
Answer

Cell B7 holds Gowri’s marks in Odia, which are 27.

Column B = Odia
Row 7 → row 2 Ratna, 3 Nagesh, 4 Ashwin, 5 Farooq, 6 Mrinal, 7 Gowri
So B7 = Gowri’s Odia marks = 27
Q3.
In which subjects has Ashwin scored more than 30 marks?
Answer

Ashwin’s row (row 4) reads:

OdiaTeluguEnglishMathsSocial ScienceScience
293133343028

He scored more than 30 in Telugu (31), English (33) and Mathematics (34).

Careful: Social Science is exactly 30, which is not more than 30, so it does not belong in the list.
Q4.
What formula would you type to find out the class average marks in Science?
Answer

Science is column G, and the 22 students occupy rows 2 to 23. So type

=AVERAGE(G2:G23)

Working it out by hand as a check: the Science marks add up to 729, and 729 ÷ 22 = 33.14 (to two decimal places).

Why the range matters: G2:G23 names the first and last cell of the block you want. If you typed G1:G23 the heading ‘Science’ would be included; if you typed G2:G22 you would silently leave Jyothi out. A spreadsheet will not warn you — it simply averages whatever you point it at.
Q5.
Find out if the class average marks in Odia is greater than the class average marks in Telugu.
Answer

No — Odia’s average is lower than Telugu’s.

=AVERAGE(B2:B23) → Odia total 687, average = 687 ÷ 22 = 31.23
=AVERAGE(C2:C23) → Telugu total 739, average = 739 ÷ 22 = 33.59
31.23 < 33.59, so the Telugu average is higher by about 2.36 marks
Tip: you can let the spreadsheet answer the comparison itself by typing =AVERAGE(B2:B23)>AVERAGE(C2:C23), which returns FALSE.
Q6.
Show the average marks in other subjects after the last row by typing the appropriate formulae.
Answer

The last student is in row 23, so put the averages in row 24. In B24 type =AVERAGE(B2:B23) and drag it across to G24 — the column letter updates by itself.

SubjectFormula in row 24Total of 22 marksClass average
Odia=AVERAGE(B2:B23)68731.23
Telugu=AVERAGE(C2:C23)73933.59
English=AVERAGE(D2:D23)71832.64
Maths=AVERAGE(E2:E23)75134.14
Social Science=AVERAGE(F2:F23)69031.36
Science=AVERAGE(G2:G23)72933.14

The class did best in Mathematics (34.14) and weakest in Odia (31.23), though the six subject averages are all within about three marks of one another.

Q7.
Get the total scores of each student by typing the appropriate formulae.
Answer

Use a new column H headed ‘Total’. In H2 type =SUM(B2:G2) and drag it down to H23.

StudentTotalStudentTotalStudentTotal
Ratna200Aishwarya273Shanker232
Nagesh250Hari147Vyshnavi197
Ashwin185Trupti188Govind103
Farooq266Veeresh148Shiva177
Mrinal194Vidhya213Tarun246
Gowri183Sanskruti242Jyothi183
Pankaj112Jaya248Ganesh225
Shravan102

The highest total is Aishwarya’s 273 out of 300 and the lowest is Shravan’s 102.

Why a spreadsheet is worth learning here: that is 22 sums of six numbers each, plus six averages of 22 numbers — around 150 additions by hand. Typing two formulae and dragging them does the lot, and if a single mark is corrected every total and every average updates on its own.
Was this helpful? Report an error