Question

4. If the total is 215 out of 300 in cell A5, then write the formula in A6 cell to

calculate the percentage (there are 6 subjects and the marks are out of 50).​

Answer 1

Write the formula in A6 cell to  calculate the percentage

Explanation:

Given,  

There are 6 subjects and Each subject is of 50 marks.

Total marks obtained by a student is 215 out of 300

Subject                           Marks

Physics                               35

Chemistry                          42

Math                                   23

English                               38

Hindi                                   45

Social Science                   32

Total                                    215

The formula in A5 cell to  calculate the percentage

=sum(B3:G3)

The formula in A6 cell to  calculate the percentage

= (A5/300)*100

The screenshot is attached below