Home / Learnings / Microsoft Excel / Microsoft Excel Exercise 8

Microsoft Excel Exercise 8

Microsoft Exersice 8In this video Learning tutorial you can learn how to Create Scholarship Statement in Microsoft Excel 2013 in Urdu and Hindi Language By Sir Muhammad Niaz.
(A) Apply formula to calculate the Scholarship on the following rang of make.
1) No Scholarship for those Students who Obtained marks below 500.
2) 30% Scholarship of Full fees will be awarded to those who Obtained marks Between 500 to 600.
3) 40% Scholarship of Full fees will be awarded to those who Obtained marks Between 600 to 700.
4) 60% Scholarship of Full fees will be awarded to those who secured marks above 700.
(B) Count the number of student gained Scholarship using COUNT ( ) Function.

  • YouTube 
  • Dailymotion 
  • Vimeo 
  • Facebook 
  • Tunepk 
Roll No. Name Obtained Total Full Fee Scholarship Payable Fee
SS7061 Sabahet 802 900 80000 48000 32000
SS7062 Fareeha 488 900 80000 NO Scholarship NO Scholarship
SS7063 Shafiq 599 900 80000 24000 56000
SS7064 Asad 667 900 80000 32000 48000
SS7065 Fozia 782 900 80000 48000 32000

Microsoft Excel Home Page
Watch Learn and Share with Your Friends

Check Also

Microsoft Excel Exercise 3

In this Video Learning tutorial you can learn How to Create Marks Certificate,  use the SUM( …