a) (i)
Give answer using Excel formula/function on the following table
Name
Physics
Chemistry
Math
amit
88
86
arav
66
puneet
| 78
seema
88
pankaj
78
88
88
77
77
pooja
95
97.
()
(ü)
What is the average marks in Physics, Chemistry and Maths?
Display the maximum marks in Physics and Chemistry.
Answers
Answered by
6
Answer:use table
Explanation:
Go to insert/ table and set the rows and columns
Answered by
31
Average and Maximum marks in Physics, Chemistry and Maths
Explanation:
There are 5 subjects and Each subject is of 100 marks.
Calculate the average marks
The formula in B8 cell to calculate the average marks in Physics
=AVERAGE(B2:B7)
The formula in C8 cell to calculate the average marks in Chemistry
=AVERAGE(C2:C7)
The formula in D8 cell to calculate the average marks in Maths
=AVERAGE(D2:D7)
Calculate the maximum marks
The formula in B9 cell to calculate maximum marks in Physics
=MAX(B2:B7)
The formula in C9 cell to calculate maximum marks in Chemistry
=MAX(C2:C7)
The formula in D9 cell to calculate maximum marks in Maths
=MAX(D2:D7)
The screenshot is attached below
Attachments:
Similar questions