Question

a. Enter the data as shown in the figure.
b. Calculate the Total marks for each child using the SUM option of AutoSum feature.
C. Calculate the Average marks for each child using the Average function.
d. Find out who has scored the highest marks using the Max function.
e. Find out who has scored the lowest marks using the Min function.
f. Highlight the names of students who have scored the highest and the lowest marks, respectivel​

Answer 1

Explanation:

Calculate the Total marks for each child using the SUM option of AutoSum feature.

C. Calculate the Average marks for each child using the Average function.

d. Find out who has scored the highest marks using the Max function.

e. Find out who has scored the lowest marks using the Min function.

f. Highlight the names of students