In 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.
|Roll No.||Name||Obtained||Total||Full Fee||Scholarship||Payable Fee|
|SS7062||Fareeha||488||900||80000||NO Scholarship||NO Scholarship|
Microsoft Excel Home Page
Watch Learn and Share with Your Friends