Question

Create an excel sheet to calculate the total and percentage of the students of a certain class. also find out the maximum and minimum marks scored in each subject.

Answer 1

Answer:

(1)Format the spreadsheet and design it as shown here. (2)fill up the data in the "Roll No."column with the help of auto fill. (3) calculate the "total" by adding up the marks in each subject. (4) calculate percentage by dividing total with maximum marks and multiplying the result with 100.

Thank_you❤

PLEASE MARK ME AS BRAINLEAST

Answer 2

If you have all 6 subjects are compulsory and for the 100 marks then you calculate percentage as

Total marks you get out of your each subject/total marks *100

E.g you get 520marks out of 600 then you calculate like this-

520/600*100=86.67%