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( …

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

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