Home / Learnings / Microsoft Excel / Microsoft Excel Exercise 2

Microsoft Excel Exercise 2

Microsoft Exersice 2

In this video Learning tutorial you can learn how to Create attendance sheet in Microsoft Excel 2013 in Urdu and Hindi Language and you can also learn How to Calculate Total Attendance using COUNTIF Function, How to Calculate Percentage and Calculate Eligible and Not Eligible using IF Function.

  • YouTube
  • Dailymotion 
  • Vimeo 
  • Facebook 
  • Tunepk
5 DAYS ATTENDENCE PAGE
Roll No. Name 1 2 3 4 5 Total Attendence % age Eligibility for Exams
1 Hira P A A P P 3 60 Allowed
2 Bilawal A P P P P 4 80 Allowed
3 Samina P P P P P 5 100 Allowed
4 Rubina P P P P A 4 80 Allowed
5 Aqeel P P A A P 3 60 Allowed
6 Faizan A P P A A 2 40 Not Allowed
7 Madiha P A P P P 4 80 Allowed
8 Erum P A A A A 1 20 Not Allowed
9 Salman P A P P P 4 80 Allowed
10 Nasir P A A P P 3 60 Allowed

Microsoft Excel Home Page
Watch, Learn and Share with Your Friends

Check Also

Microsoft Excel Exercise 4

In this video learning tutorial you can learn How to Create a Pay Roll of Employees, …