YouTube Subscribe Animation Button

Microsoft Excel Exercise 8 Scholarship Statement

Microsoft Exersice 8 Scholarship StatementIn 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.NameObtainedTotalFull FeeScholarshipPayable Fee
SS7061Sabahet802900800004800032000
SS7062Fareeha48890080000NO ScholarshipNO Scholarship
SS7063Shafiq599900800002400056000
SS7064Asad667900800003200048000
SS7065Fozia782900800004800032000

Microsoft Excel Home Page
Watch Learn and Share with Your Friends

Check Also

Microsoft Excel Exercise 3 Marksheet

Download Setup In this Video Learning tutorial you can learn How to Create Marks Certificate,  use …

6 comments

  1. 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

  2. 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 🙂

  3. 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…

  4. 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….

Leave a Reply to Muhammad Niaz Cancel reply

Your email address will not be published. Required fields are marked *