Question

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. ​

Answer 1

Answer:

formula for average : =average(select marks ) enter formula for maximum: =max(select marks) enter.

Answer 2

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