computer
Licensing
Short
computer Courses
Applications
[Link]
Soft Technology Computer Institute Farooka
03000594915
IT
education
and Solutions
information
Website
development
Written By: OFFICE MANAGEMENT
Muhammad Shoaib MS Exel Practical Part
MS Computer Science (Urdu Version)
MS Excel Practical Work
How to Work:الچےناکرطہقی
رپکلکرکدںیسجےکدعباآپےکاپسالسکییکوڈنواونپوہاجےئیگ۔ExcelرپاجںیئاورProgram رپکلکرکںیاورStart
ںیمآپوکیئیھباکمرکرےہوہںوتاسںیماگلےئاجےنویلکںںیمبسےسےلہپربارب=اکاشننانھکلہنوھبںیل–ارگآپےنوکیئٹیشلمکمرکیلےہ–وتآپاسٹیشExcel
شی
–ںیمھچک ٹیںانبیئاجیتںیہExcel –ےکاکملںیموکیئدبتیلیرکںیےگوتوٹلٹںیمیھبوخدوخبددبتیلیوہاجیگیئ
Result Making Sheet
A B C D E F G H I J K
[Link] Name School Name Chem Bio Phy Urdu Eng Math P.s Islam
1 ABC High school 50 56 66 88 88 45 56 44
L M N O P Q R S
Obtain %Age Average Result Div Get High Low
Marks P/F got Grade marks marks
493 58 61.625 pass 2nd C+ 88 44
کلیے
Gained Marks = sum (d2 : k2)
percentage = L2 / 850 * 100
Average = Average (d2 : k2)
Result = If (M2>32.99,”Pass”,”Fall”)
Division = If ( M2 > 59.99,” 1 st “ ,if (M2 >44.99, “ 2nd “,If (32.99,”3rd “,”Fai”)))
Grade =If (M2>79.99,”A+”, If (M2>69.99,”A”,If (M2>59.99,”B”, If (M2>49.99,”C”, If (M2>39.99,”D”, If
(M2>32.99,”E”,” Fail”))))))
1st student =Max (M2:M20)
Last student =Min (M2:M20)
Electric Bill
1 A B C D E F G H
2 Serial Name of The Meter No previous Current Total Units Rate Total bill
no Owner Of Meter given on bill units cons. Units cons. consumed Per Unit of person
3 1 abc 12345 200 500 300 3.4 1020
کلیے
Units Consumed = E2-D2
Rate per Unit =If(F2<101,3.36, If (F2<201,5.36, If (F2>200,8.75,)))
Total bill generated = F2 * G2
Bank Account Slip
1 A B C D E F G H I J
2 Sr Name of A/C .no Opening balance Rupee Rupee Current Zakat Profit Closing
no Person At select. time Credit Debit balance deducted received balance
3 1 Abc 12345 10000 5000 3000 12000 300 360 12060
کلیے
Current Balance =D2+E2-F2
Zakat = If (G2>4999,G2*2.5%,)
Profit = G2 * 3%
Closing Balance =G2 – H2 + I2
Salary Slip Generation
1 A B C D E F G H I J K L M
2 Name of Atten- Designa Medical Convince Gross Income G.P Advance Net
Basic pay
H. Rent
Employee dance -tion Allow. Allow. pay tax Fund Money pay
Sr no
deduct Ded- taken
uct
3 1 abc 20 Manager 30000 5000 4000 3000 42000 1000 500 1200 393
at 00
softtech
کلیے
House Rent = E2 * 25 % / 30 * c2
Medical Allowance = E2 * 20 % / 30 * c2
Convince Allowance = E2 * 15% / 30 * c2
Gross Pay امتماکزملوکعمجرکںی
Income Tax
ٰ = If (E2 >4999, E2 * 5% / 30 * c2,)
G , P , Fund = E2 * 2.5% / 30 * c2
Net Pay = 12 * J2 - K2 - L2
Hotel Bill Management Sheet
1 A B C D E F G H I J K
2 Sr Name of Address Room Rent/Day Check in Check out Total Total Advance Balance
no Customer of Cust. /Day Day Rent
3 1 abc C.C.F Single 500 4/4/2018 8/8/201 5 2500 1000 1500
8
کلیے
Rent / Day = If (d2=”single”, 500, If (d2=, double”, 1000, If (d2=” family”,1500,if (d2=”sweer”,5000,))))
Total Day = Day 360 (f 2 : g2)
Total Rent = E2 *h2
Balance = i2 * j2
Composed by: Student Khurram