mmmm

Exercise No.1
A B C D E
1
2 VALLEY BOOK STORE [Link].
3 Kirtipur (Near Kirtipur New Gate), KTM
4 Day Book for the Month of………………………………………………………2071
5 Date Particulars Quantity Rate Amount
6 01/2
7 01/3
8 01/3
9 01/4
10 01/5
Grand Total
Condition:
Date : ;dfg lsg]sf] ldlt /fVg]
Particulars : ;dfgsf] gfd /fVg]
Quantity :
Rate :
Formulas:
Amount : quantity*Rate =C6*D6 (Enter)
Grand Total : Add all Net amount =Sum(E6:E10) (Enter)

Exercise No:- 2
 A B C DF E F G
1
2
3
4
5 Date Particulars Quantity Rate Amount Discount Net Amount
6 01/10 Books 222 123
7 01/11 Balpen 111 345
8 01/12 Copy 444 43
9 01/13
10 01/14
Grand Total

Condition:
 Date : ;fdfg a]r]sf] ldlt /fVg] .
 Particulars : ;fdgsf] gfk /fVg] .
 Quantity : ;fdgsf] kl/df0f /fVg] .
 Rate : ;fdgsf] d"No /fVg] .
Formulas:
 Amount : quantity*Rate =C6*D6 (Enter)
 Discount : Amount*Discount percentage =E6*15%
 Net Amount : Amount-Discount =E6*F6
 Grand Total : Add all Net Amount =Sum(G6:G10) 

Exercise No. 3
 A B C D E F G
1
2
NEPAL ELECTION COMMISSION
3 2070
4
5 Name of
Address Gender Age Citizenship Result 1 Result 2
Candidates
6 Rekha thapa KTM Female 28 Yes
7 Tilak Pandy DMK Male 20 Yes
8 Bipana Basu PKR Female 16 No
9 Total Participants
10 Total Voters
Total Females
Average Age
Conditions:-
[18 or above it by the age ="Voter", less than 18 of age ="Non-Voter"]
Formulas:
 Result 1 =if(age>=18,"Voter","Non-Voter")
 Result 2 =if(and(age>=18,citizenship="yes"),"Voter","Non-Voter")
 Total Voter =countif(F6:F8,"Voter")
 Total Male =countif(C6:C8,"male")
 Total Female =countif(C6:C8,"female")
 Average Age =average(D6:D8)

Exercise No:-4
 A B C D E F G H I J K
1
2 MAHENDRODAYA HIGHER SECONDARY SCHOOL
3 Gajurmukhi, Ilam
4
Mark-Sheet
5 Roll No. Name Nepali English Math Science Total Percentage Result Division Rank
6 306 Ashok Rai 75 55 80 65
7 307 Binita Giri 80 65 60 50
8 308 Sabina Tamang 60 55 65 85
9 309 Mohan Gaire 70 58 82 63
10 310 Nima Lama 66 54 84 74
AVERAGE
MINIMUM
MAXIMUM
Calculate:- Formulas:
 Total : =Sum(C6:F6)
 Percentage : =G6/4
 Result : =if(min(C6:F6)>=35,"pass","fail")
 Division : =if(i6="Pass",if(H6>=80,"disti",if(H6>=60,"First",if(H6>=45,"Second","third"))))
 Rank : =Rank(H6,$H$6:H10,0) 
 Average : =average(h6:h10) 
 Minimum : =min(h6:h10) 
 Maximum : =max(h6:h10) 

Exercise No. 5
A B C D E F G H I J
1
2 VALLEY CYBER CENTER
3 Kirtipur (Nayabazar), Kathmandu
4 Day Book
5 PC Name Log in Log out Duration Hour Minute Second Total Discount Net-
Time Tim Charge Amount
6 Pc1
7 Pc2
8 Pc3
9 Pc4
10
Condition:
[1hr= Rs. 20, per minute (20/60) = Rs. 0.33]
 Log in time : =Internet rnfPsf] ;do /fVg] . =Current time
 Log out time : =Internet rnfO;Sbfsf] ;do =Current time
Formula:
 Duration : =Log out time - Log in time =C6-B6
 Hour : =hour(duration) =hour(D6) 
 Minute : =Minute(duration) =minute(D6) 
 Second : =second(duration) =second(D6) 
 Total Charge : =(hour*60+minute)*0.33 =(E6*60+F6)*0.33

Exercise No:6
A B C D E F G H I J K L
1
2
3 ADARSHA HIGHER SECONDDARY
4 Kirtipur, Kathmandu
Calculation of Gratuity for Outgoing Staff
5 Name of Join Date Leave Salary(Annual Total Year Month Day Yearly Monthly Dally Total
Employees Date ) Days Gratuity
6 Sudar 2069/5/1 2070/4/30 150000
Newahang
7 Dipak Rai
8 Santosh Rai
9 Ashok Rai
10 Narendra
Rai

Calculate:
1. Basic Salary : Ps jif{df kfpg] hDdf tnj /sd /fVg] Formulas:
2. Total Day : Leave date -Join date =C6-B6
3. Years ` : Trunc (total days/365) =Trunc(E6/365) 
4. Months : Trunc((Total days-year*365)/30) =Trunc((E6-F6*365)/30) 
5. Days : Total Days-(year*365)-(month*30) =E6-(F6*365)-(G6*30) 
6. Yearly : Basic Salary*Year =D6*F6
7. Monthly : Round(Basic salary*month/12,0) =Round(D6*G6/12,0) 
8. Daily : Round(Basic salary*Days/12/30,0) =Round(D6*H6/12/30,0) 
9. Total Gratuity : Sum of individual fields =Sum(i6:K6) 

Exercise No.7
 2010 2011 2012 2014
No. of Students 350 360 300 390

No. of Students

25%
28%

2010
2011
2012
2014

21% 26%

Exercise No. 8
 Year Rice Maize Wheat
2009 60 40 32
2010 80 50 45
2011 90 65 55
2012 100 75 80
2013 140 105 100

160

140

120

100

Rice
80 Maize
Wheat
60

40

20

0
2009 2010 2011 2012 2013

Exercise No. 9
 A B C D E F G
1 NEPAL TELECOM [Link].
2 Kathmandu
3 Calculation of wages
4 TAX
5 S.N. Name Salary Service Income Total Net
Amount
6 202 Bikram Newahang 10000
7 203 Ashok Rai 12000
8 204 Sita Rai 20000
9 205 Neeta Rai 21000
10 206 Bikash Bhusal 16000
Calculate:
Service tax =1.5% of salary for all
Yearly Income tax = 0, if yearly salary is less than 2 lakhs.
Yearly Income tax= 10%, if yearly salary is between 2 lakhs and 3 lakhs.
Yearly Income tax =15%, if yearly salary is above 3 lakhs.
Total tax =service tax + income tax
Net salary =salary-total tax
Formula:
Service =C6*1.5%
Income =if(and(c6*12<=200000),0,if(and(c6*12>200000,c6<=300000),c6*10%,c6*15%))
Total tax =service tax + income tax
Net salary =salary-total tax

Exercise No.10
 A B C D E F
1 MITERI SAVING & CREDIT CO-OPERATIVE LTD.
2 Kirtipur, Kathmandu
3 2071
4
5 Member ID Name Balance Deposit Withdraw Net Balance
6 20 ram
7 21
8 22
9 23

Net Balance = Balance+Deposit-Withdraw

10 Member ID
11 Name
12 Balance =Vlookup(B10,A6:F9,2)
13 Deposit
14 Withdraw
15 Net Balance
=Vlookup(B10,A6:F9,3)
=Vlookup(B10,A6:F9,4)
=Vlookup(B10,A6:F9,5)
=Vlookup(B10,A6:F9,6)

Exercise No.11
 A B C D E F
1 NEPAL ELECTRICITY AUTHORITY
2 Kirtipur, Nepal
3
4 Miter No. Name of Customer Previous Unit Current Unit Total Unit Total Charge
5 102 Ram Krishna Dhakal 100 150
6 103 Ashok Rai 90 120
7 104 Shiva Pariyar
8 105 Krishna Murti

 Previous Unit : =uPsf] dlxgfsf] vkt Unit /fVg]

 Current Unit : =of] dlxgf;Ddsf] vkt unit /fVg]
 Total Unit : =Current Unit-Previous Unit
 Total Charge : =if(Total Unit<=20,80,if(Total Unit>=20,(Total Unit-20)*7.7+80))
Condition:
Minimum Unit: 20
Minimum Charge = Rs.80
Per Unit Charge: Rs. 7.7

Exercise No. 12
 A B C D E F G H I J
1
2 TALLY SOLUTION [Link]
3 Damak, Jhapa
4 Payroll System
5 Name Address Phone Working Time Basic Salary Post D.A H.R.A. P.F Net-Amount
6 Ashok Rai Ilam 9849133495 Full Time
7 Ganesh Rai Kirtipur 01-4332509 Part Time
8 Binod Nepal Jhapa
9 Sanyaya Niroula Ilam
10 Sanju Basnet Ilam
11 Srijana Dahal Kalanki
12 Sabina Shrestha Rukum
13 Arty Rai Ilam
Basic Salary : =sd{rf/L kfpg] dfl;s Go'gtd tna /fVg] .
Post :
=if(and(E6>=20000),"Manager",if(and(E6>=15000),"Staff",if(and>=10000),"Accountant",if(and(E6>=5000),"Cleek","poen"))))

Exercise No. 13
 A B C D E F G H
1
2
INFOTECH GLOBAL INDIA [Link]
3 New Road, KTM
Salary Sheet for the month of January 2013
4
5 Employee name Status Dis.(km) Basic Salary Extra Duty Expenses Road distance Net-Amount
Allowance Allowance allowance
6 Mr. R.K. Panta Male 5 20000
7 Ashok Rai Male 10 18500
8 Arty Rai Female 12 15000
9 Sanju Basnet Female 15 22500
10 Srijana Dahal Female 21 12500

Grand Total
Official treatment condition:
Extra Duty Allowance: Those whose basic salary are Rs. 20000 & are Male get 15% of Basic Salary otherwise get 10% of Basic
Salary.
Expenses Allowance: those whose basic salary are Rs. 20000 & are Male get 20% of Basic Salary other-wise get 15% of Salary.
Road Distance Allowance: Whose travel distance is above 20 KM get 15% of basic salary, above 15KM get 10% of basic salary,
above 10km get 8% of basic salary otherwise get 3% of basic salary.
Calculate: FORMULA:
Extra Duty Allowance : =If(and(B6="Male",D6>=20000),D6*15%,D6*10%)
Expenses Allowance : =If(and(B6="Male",D6>=20000),D6*20%,D6*15%)
Road Distance Allowance : =If(C6>=20,D6*15%,if(C6>=15,D6*10%,if(C6>=10,D6*8%,D6*3%)))
Net Salary : =Sum(D6:G6) 

Project Work
1. Prepare the following:

Loan Amount 150000 Conditions: interest is 14% if loan duration is less than 5 years and loan amount is more than 1
Loan Duration 6 years lakhs. Others wise 5%.
Interest ?

2. Prepare the following task:

SN Sales Man Sales Bonus Conditions: if sales amount is above Rs. 100000 loan is 10% otherwise 0.
Amount
1 Akram DC 215000 ?
2 Srijang BC 94500 ?

3. Prepare the following electricity bill.

S Name of Customer Type P.M.R C.M.R Used Unit Total Charge

N
1 Nitesh Mukhiya Domestic 1520 1590 ? ?
2 Shankar Chand Industries 12430 18486 ? ?
3 Tara Adhikari Agriculture 20142 22142 ? ?
Conditions:

Type Minimum 20 units 21-250 Above 250

Domestic 80 7.75 12.25
Industries 200 10.15 14.50
Agriculture 50 6.25 7.50

Joshibhagarati98@[Link]
4. Calculate the wages for 7 persons.

S.N Name of Employee Entry Time Out Time Worked Hour Wages
1 Hari Krishna 8:00 18:00 ? ?
2 Surya Man 9:00 17:00 ? ?

Conditions: the wages during office is Rs. 60 per hour and overtime is double wages (120)
Office time: 9:00-17:00 (8 hours), otherwise overtime.

5. Calculate the wages of the month December as per the given conditions
SN Name of Employee Month Working Days Absent/Over Day Wages
1 Om Puri January 2014 20
2 Sunil Sing January 2014 28

Conditions: Rs. 500 is given for working days and 2 days sick or accidental leave is allotted leave is allotted per month. 50%
amounts deducted for an absent day except holidays and 50% extra wages is given for working on holidays.
The normal working day for the month of January 2014 is 25 days.
6. Find the Grade of the students.
SN Name of students' Reading Writing Speaking Grade
1 Ashok Rai 20 15 15 ?
2 Himal Nepali 12 14 11 ?
3 Subas Ghale 7 5 9 ?
Conditions: if the scores on reading, writing and speaking are above 15, Grade A, if the scores on reading, writing & speaking are
between 10-1, Grade B. otherwise Grade C.
7. Importance Key Function:
Operator Function Name Meaning
+ Addition Cell A combination of grid
- Subtraction Rows Vertical line
/ Division Columns Horizontal line
* Multiplication Sheet Combination of rows and columns
% Percentage Worksheet A collection of sheets
< Less than Merge cell Merge two or more rows and column in one cell
> Greater than
<= Less than equal
>= Grater than equal
<> Not equal
^ Square root
IF Condition is true or false
AND More than two condition
OR Any one true

Exercise : - 14
A B C D E F G H
1
2
Nepal Bank Ltd.
Kalimati, Kathmandu
3 Interest Sheet
4 S.N. Name Address Principle Time Rate (%) Interest Amount
5 1. prakash aryal Balkhu 25000 2.5 18.5
6 2. Lalit Pokhrel Sanepa 250000 3 19
7 3. Hari Aryal Kirtipur 150000 19.5
8 4. Sunita Limbu kalanki 15000 20
9 5. Srita Sapkota New road 2000 21.5
  Interest :-
= (Principle*Time*Rate)/100 
 Amount :-
=Amount + Interest 

Condition :-

 Hari Aryal sf] @ aif{ % dlxgf !& lbgsf] Interest lgsfNg'xf];\ .

 Sunita Limbu sf] # aif{ & dlxgf @& lbgsf] Interest lgsfNg'xf];\ .
 Sarita Sapkota sf] !@ aif{ $ dlxgf )& lbgsf] Interest lgsfNg'xf];\ .
A B C D E F G H I J
1 Nepal Telecom Ltd.
2 Mesuam Road, chhauni Kathmandu, Nepal
3 Ph. :- 01-4222222
4 S.N. Name Address Previous call Current call Total call Extra call Amount vat Net amount
5 1 Janak Kirtipur 1250 1506
6 2 Ram Balkhu 1560 1760
7 3 Bhim Sanepa 1800 2150
8 4 Prem kalimati 1790 1908
9 5 Sohan kalanki
10 6 Mahesh pokhara
 Formula used in Total Call =E7- D7
Formula used in Extra Call =F7-100
Formula used in Amount =100+G7*2
Formula used in Vat =H7*13%
Formula used in Net Amount =H7+I7
Create the Following table and Insert the 10 records:-

A B C D E
1 l;= g= (s.n.) lja/0f (particular) kl/df0f b/ (Rate) hDdf (Total)
(Quantity)
2 ! sDKo'6/ @ @%))
3 @ Sofd]/f ! !@))
4 # 38L # ^))
5 $ /]l8of] $ #))
6 % lk|G6/ ! %)))
7 ^ 6]an # !@))
8 & slk @) !%
9 * k]lG;n !% %
10 ( kmf]6f]slk k]k/ ! #))
Join us for Valley
 Latest & Professional Course.
 Time Tested, Highly Motivational.
 Loadsheding Free lab with Solar Powered Backup.
 Both theory and practical classes.
 Regular tests and supporting classes for weak students.
Available here
 Computer
 Language
 Preparation Classes
 Child Care
 Supper learning Class
 All level All Subject Tuitions
 IELTS/TOFEL
 Many More…………………………………………….
Courses Services
 Office Package  Computer maintenance
 Diploma  Web page Designing
 Hardware & Networking  Desk Publication
 Graphic Design  Printing
 Accounting Package  Laptop Repair & Antivirus
 Web page Design scanning & updating
 programming  Many more……….
Animal Plant presentation
 About Buddha
 Born: Lumbini
 Died: Kushinagar, India
 Full Name: Siddhartha
 Spouse: Queen Yashodhara
 Parents: Queen Maha
Maya, Mahapajapati
Gotami, King Suddhodana
 Siblings: Nanda, Sundari
Slide 1 Slide 2 Slide 3

Slide 4 Slide 5 Slide 6

What is the shortcut to replace text in a document?