The spreadsheet given below contains the name, gender, and age of family members. Study the spreadsheet and data carefully and answer the following questions.

1. Which column is filled with the age of the family members?
2. Which row contains the age and gender of Nabin?
3. The spreadsheet shows that the age of Kamala is 25. What is the name of the cell filled with her age?

\begin{tabular}{|c|c|c|c|}
\hline
4 & [tex]$A$[/tex] & 8 & [tex]$\varepsilon$[/tex] \\
\hline
1 & नाम & चर्में & निका \\
\hline
[tex]$=$[/tex] & पह्धम & 65 & [tex]$M$[/tex] \\
\hline
3 & हान्मी & 62 & [tex]$F$[/tex] \\
\hline
4 & मिना & 42 & F \\
\hline
5 & सिसाराम & 39 & [tex]$M$[/tex] \\
\hline
6 & प्षाची & 35 & F \\
\hline
7 & नानन & 38 & [tex]$M$[/tex] \\
\hline
8 & क्षहा & 25 & F \\
\hline
9 & चषन & 20 & [tex]$M$[/tex] \\
\hline
10 & & & \\
\hline
11 & & & \\
\hline
\end{tabular}

Fig 2.17

Science and Technology, grade 7



Answer :

Sure, let's analyze the given spreadsheet data step by step:

1. Which column is filled with the age of the family members?

To find the column that contains the ages, we need to observe the headers of each column and look for the column that lists numerical values corresponding to ages.

By analyzing the given spreadsheet:
```plaintext
| Column | Header 1 | Header 2 | Header 3 |
|--------|----------|----------|----------|
| 4 | [tex]$A$[/tex] | 8 | [tex]$\varepsilon$[/tex] |
| 1 | नाम | चर्में | निका |
| 2 | पह्धम | 65 | [tex]$M$[/tex] |
| 3 | हान्मी | 62 | [tex]$F$[/tex] |
| 4 | मिना | 42 | F |
| 5 | सिसाराम | 39 | [tex]$M$[/tex] |
| 6 | प्षाची | 35 | F |
| 7 | नानन | 38 | [tex]$M$[/tex] |
| 8 | क्षहा | 25 | F |
| 9. | चषन | 20 | [tex]$M$[/tex] |
```

The ages are 65, 62, 42, 39, 35, 38, 25, 20. Observing this, we see that the third column contains the ages.

Answer: The column filled with age is Column 3 (0-based index: 2).

2. Which row is filled with age and gender of Nabin?

We need to identify the row that contains Nabin's information. By scanning the rows:
```plaintext
| 7 | नानन | 38 | [tex]$M$[/tex] |
```

Therefore, Nabin's age and gender are found in row 7.

Answer: The row filled with age and gender of Nabin is Row 7 (0-based index: 6).

3. Spreadsheet shows that the age of Kamala is 25. What is the name of the cell filled with her age?

The given spreadsheet mentions that Kamala's age is 25. By finding her row:
```plaintext
| 8 | क्षहा | 25 | F |
```

Kamala's age is in the third column (C) in row 8, so the cell name is C8.

Answer: The name of the cell filled with Kamala's age is C8.

By analyzing the spreadsheet carefully, we have derived the answers:
1. Column filled with age: Column 3 (0-based index: 2).
2. Row filled with age and gender of Nabin: Row 7 (0-based index: 6).
3. The cell filled with Kamala's age: C8.