Question

Give answer using Excel formulas/function on the following table. Name amit physics 88 chemistry 68 math 86

Answer 1

Excel formulas for Add/Average the marks

=SUM(B2:D2)

=AVERAGE(B2:D2)

Explanation:

If we want to Add/Average the subject marks so  

• First, write NAME in A  Column and subject in another column  
• write  Amit  88,68,66  
• put the formula =SUM(B2:D2)
• or for average =AVERAGE(B2:D2)
• or you can click on auto sum button and select the option what you want to put
• Example:-sum, average, count numbers, max and mini