Question

please answer my question it's very urgent​

Answer 1

Answer:

i)

in G2 cell, write

=SUM(C2:F2)

then hold and drag fill handle upto G6 then total marks get inserted in the table.

in H2 cell, write

=(G2/4)

then hold and drag fill handle upto G6 then percentage of marks get inserted in the table.

ii)

in B7 cell, write

=MAX(C2:C6)

then hold and drag the fill horizontally to get maximum marks of each subject in appropriate cell.

in B8 cell, write

=MIN(C2:C6)

then hold and drag the fill horizontally to get minimum marks of each subject in appropriate cell.

iii)

conditional formatting

hope this will help you