Ms. Excel Practical Projects
Practice, Prepare & Train Yourself
Ms. Excel Pratical Projects with Answer
Project-1
Calculate Total, Percentage, Fail/ Pass, Grade and Division by using excel formula(function)
| Roll No. | Name | Hindi | English | Maths | Science | SS.T | Computer | Total | Percentage | P/F | Grade | Division |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101 | Divya | 75 | 67 | 60 | 78 | 76 | 87 | 443 | 73.83% | Pass | A | Second |
| 102 | Kavya | 78 | 68 | 87 | 56 | 79 | 57 | 425 | 70.83% | Pass | A | Second |
| 103 | Mariya | 87 | 86 | 78 | 67 | 75 | 73 | 466 | 77.67% | Pass | A | First |
| 104 | Nancy | 45 | 56 | 74 | 73 | 76 | 56 | 380 | 63.33% | Pass | B | Third |
| 105 | Afsana | 56 | 56 | 76 | 45 | 76 | 78 | 387 | 64.50% | Pass | B | Third |