Question

Instructions

•Calculate the total marks obtained by each student in column H.

•Calculate the highest and lowest marks obtained in IT subject in row
8 and 9 respectively.

•Calculate the aggregate/percentage marks obtained by Aniket in column J

•Give the number of students appearing for SST subject in row 10.

• Find the average marks in Maths and display them in the row 12. ​

Answer 1

Answer:

32 32 23 23 32 32 23 23 32 32 23 23

Answer 2

(Note: I have done this according to the table given as some questions are wrong)

(If facing aby problem just change the name accordingly)

1. In cell H3 write:

= SUM ( C3 : C6 )

and drag this to H6

2. (i) Highest marks

In cell C8 write:

=MAX ( C3 : C6 )

and drag this to G8

(ii) Lowest marks

In cell C9 write:

=MIN ( C3 : C6 )

and drag this to G9

3. Percentage

= marks obtained/maximum marks × 100

so,

H column is for marks obt

I column is for max marks

J column is for percentage

In cell J3 write:

=H3/I3*100

and drag this to J6

4. In cell E7 write:

=COUNT ( E3 : E6 )

and drag this to G7 and C7 (if needed)

5. In Cell D12 write:

=AVERAGE ( D3 : D6)

and drag this to G12 and C12 (if needed)