Question

Write the formula in E2 to find the total marks

scored by HARMAN.

2. Copy the formula entered in E2 for other

students.

3. Write the formula in F2 to find the average marks

scored by HARMAN?

4. Copy the formula entered in F2 for other

students.

5. Write the formula in cell B7 to find the highest

score in Hindi.

6. How will you find the highest score in English

and Maths?

7. Write the formula in cell B8 to find the total

number of students who appeared in Hindi?

8. Write the formula in cell B9 to find the lowest

score in Hindi.

9. How will you find the lowest score in English and

Maths?

10. How will you find the highest score in Hindi,

English and Maths?​

Answer 1

Explanation:

Write the formula in F2 to find the average marks