give answer using Excel formula on the following table. what is the average marks in physics,chemistry and maths ? display the max marks in physics and chemistry.
Attachments:
Answers
Answered by
10
Answer:
formula for average : =average(select marks ) enter formula for maximum: =max(select marks) enter.
Answered by
3
Answer:
Average of:
Physics - 82.167
Chemistry - 82.67
Maths - 80.5
Max in:
Physics - 95
Chemistry - 98
Create a Row heading Average
Write the formula for average under Physics Column
=average(Range of cells with marks in them)
Press enter and drag this under other 2 columns as well
Create a Row heading Maximum
Write the formula for Maximum under Physics Column
=max(Range of cells with marks in them)
Press enter and drag this under other 2 columns as well
Similar questions