Scribd
Upload
61 views2 pages

Ms Excel

The document presents a marksheet for 15 students across five subjects, detailing their total scores, percentages, averages, minimum and maximum scores, ranks, and pass/fail status. The highest scorer is Piyush with a percentage of 95.2%, while Kavya and Yashika failed with percentages of 15.8% and 22.6%, respectively. Overall, the majority of students passed with varying grades from A+ to C.

Uploaded by

Kushal Prajapati
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
61 views2 pages

Ms Excel

The document presents a marksheet for 15 students across five subjects, detailing their total scores, percentages, averages, minimum and maximum scores, ranks, and pass/fail status. The highest scorer is Piyush with a percentage of 95.2%, while Kavya and Yashika failed with percentages of 15.8% and 22.6%, respectively. Overall, the majority of students passed with varying grades from A+ to C.

Uploaded by

Kushal Prajapati
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

JOB : 1

EXCEL SHEET
MARKSHEET
SUBJECTS
S. NO. NAME TOTAL PERCENTAGE
Maths Computer EVS English Hindi
1 Aman 65 78 67 54 23 287 57.4
2 Amit 79 92 87 56 44 358 71.6
3 Deepa 67 53 45 23 56 244 48.8
4 Harsh 78 28 32 90 71 299 59.8
5 Harshita 32 64 56 67 33 252 50.4
6 Karan 22 83 98 22 42 267 53.4
7 Kavya 21 22 11 17 8 79 15.8
8 Manisha 62 21 20 67 42 212 42.4
9 Mohan 66 77 56 76 97 372 74.4
10 Nishu 65 98 43 34 43 283 56.6
11 Piyush 95 96 99 91 95 476 95.2
12 Sonu 32 43 67 43 56 241 48.2
13 Riya 43 44 92 45 76 300 60
14 Yash 88 76 45 44 79 332 66.4
15 Yashika 34 52 11 6 10 113 22.6
1
HEET
EET

AVERAGEMINIMUMMAXIMUM RANK PASS/FAILGRADE


57.4 23 78 7 PASS C+
71.6 44 92 3 PASS B+
48.8 23 67 11 PASS C
59.8 28 90 6 PASS C+
50.4 32 67 10 PASS C+
53.4 22 98 9 PASS C+
15.8 8 22 14 FAIL FAIL
42.4 20 67 13 PASS C
74.4 56 97 2 PASS B+
56.6 34 98 8 PASS C+
95.2 91 99 1 PASS A+
48.2 32 67 12 PASS C
60 43 92 5 PASS C+
66.4 44 88 4 PASS B
22.6 6 52 14 FAIL FAIL

You might also like