Microsoft Excel Exercise 8 Scholarship Statement

Muhammad Niaz 6 Comments 10,577 Views

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.

Scholarship Statement

YouTube
Vimeo

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

6 comments

Sadia baloch
May 2, 2014 at 5:39 pm
sir mey ne bhot kuch seki hain apsy leken 1 problum hai plz help me . meri computer urdu lekti hai leken jo mey lekna chati hon wo ni lekti b ka bottan lagati hon to پ k jaga ش lekti hian plz help me. i will be thank full to you
hussnain Javed
March 20, 2014 at 8:40 pm
Sir! Which plugin are you using for the protection of you data? When I want to copy password it does not copy it. Please tell me ap kon c plugin use krty ho? Thanks 🙂
- Muhammad Niaz
  March 20, 2014 at 11:44 pm
  Dear Plugin nahi Use ker raha houn
  Template si Edit kiya hai
Ali Hassan
March 16, 2014 at 1:03 am
AOA sir!
sir me ap ki website ka regular reader hn. Me ap ki website sa boht zyada inspire hn. Mene ap ki website sa boht kuch sekha ha. Sir ab ma seo ka course kr raha hn, to mere pas aik sawal ha. plz ap us ka jwab zaror dien… Mene ap ki website to aik dafa check kiya tha toh ap ki posts website par search ni kr rahi thi. Lakin ab mene kuch din phele dobara check kiya to ap ki sari posts google par search ho rahi hein. To plz ap muja ye bta dien k ye ap na apni seo kese thik ki jo ap ki sub post dobara search honay lag gai hein.. Sir plz reply.. waiting for tour reply…
- Muhammad Niaz
  March 16, 2014 at 11:55 am
  Walikum Salam and Thanks Dear
  INSHALLAH April ke month main WEB Designing SEO ke All Tutorial Launch Kerna Start ker donga
Mustafa
March 9, 2014 at 4:32 am
AOA!
Niaz bhai muja ap ki help chahiye thi. Me ap ki website ka regular reader hn. Me Seo ka b shok rakhta hn. Mene ap ki site ko aik dafa 2 month phele check kiya tha tb ap ki koi b post index ni ho rahi thi google par, aur koi b search ni ho rahi thi… Lakin kuch din phele mene ap ki site dobara check ki to is ki sari posts index ho rahi hein… To ma ap sa pochna chahta hn k ap ne asa kiya kiya tha jo ap ki seo aur google searching bilkul thik ho gai? Please reply Naiz bahi….