Answer to Question #180083 in Software Engineering for Sunny

Question

Write FORMULAS ( NOT ANSWERS) FOR THE OPERATIONS ( for a-e) on spread sheet given below along with the relevant cell address

A B C D E F G H

1 sr.no name gender Science math COMPUTER TOTAL Average

2 1 MAX M 34 75 39 ? ?

3 2 Swati F 47 29 33 ? ?

4 3 shruti F 83 51 42 ? ?

5 4 Ram M 63 94 68 ? ?

6 5 Neetu M 51 90 45 ? ?

7 Max ?

8 Total ?

9 Average marks of males M ?

10 Average marks of females F ?

a) To calculate the total marks as sum of science, Maths and computers for each student and display them in column G

b) to calculate the average marks for each student and display them in column H

c) to calculate the highest marks in Computers and display it in cell F7.

d) to calculate the total number of students appearing in science and display it in cell D8

e) to calculate the average marks for male students in cell H9 and for female students in cell cell H10.

Answer 1

Dear Sunny, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order