Computer Science, asked by simranvarma1998, 10 months ago

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 failedsquash537
6

Answer:use table

Explanation:

Go to insert/ table and set the rows and columns

Answered by suskumari135
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