Question

Marks sheet of students is given below:
Complete the table by writing formulas in Row 6 and Column E.

\[ \begin{array}{|c|c|c|c|c|} \hline A & B & C & D & E \\ \hline \text{Name of Students} & \text{Marks Scored in July, 2022} & \text{Marks Scored in December, 2022} & \text{Marks Scored in March, 2023} & \text{Total Marks} \\ \hline \text{Mohan} & 300 & 400 & 425 & \text{=B2+C2+D2} \\ \text{Ram} & 250 & 291 & 300 & \text{=B3+C3+D3} \\ \text{Gobind} & 350 & 300 & 295 & \text{=B4+C4+D4} \\ \text{Kamal} & 410 & 390 & 415 & \text{=B5+C5+D5} \\ \hline \text{Total Marks} & \text{=SUM(B2:B5)} & \text{=SUM(C2:C5)} & \text{=SUM(D2:D5)} & \text{=SUM(E2:E5)} \\ \hline \end{array} \]

Hint:

The SUM function in Excel adds up the values in a range of cells. This is useful for calculating totals across rows or columns.

Answer 1

Step 1: Formula for Total Marks. 
To calculate the total marks for each student, we need to sum the marks scored in all three months (July 2022, December 2022, and March 2023). Therefore, for each student, the formula in Column E is: \[ \text{Total Marks} = \text{=B2+C2+D2} \] Similarly for other students, replace the row numbers accordingly. 
Step 2: Formula for Total Marks for All Students. 
To calculate the total marks for each month (Column B, C, and D), use the SUM formula for each column. For example, for Column B (July 2022): \[ \text{Total Marks in July 2022} = \text{=SUM(B2:B5)} \] Similarly for the other months (Columns C and D), use the SUM formula for each column.