Computer Training/ Day 9

Micro Soft Excel

Micro soft excel 2003 is developed to fulfill facilities for excel. Its main function is to calculate, create salary sheet, result sheet, billing system, balance sheet etc. It is include in MS-Office. It is called spreadsheet soft ware. It has 256 columns and 65536 rows as per sheet. It is developed by Microsoft Company of U.S.A.

1.     To Run Excel:

·        Click on star menu then click on Programs.

·        Click on Micro Soft Office then click on Micro Soft Excel.

Or

·        Click on Start menu and click on run command.

·        Type Excel and click on ok button. (Then Micro Soft Excel appears)

·         

2.     Billing System:

Kathmandu Mall Departmental Store Sundhara,Kathmandu Ph: 5487548
S.No.	Particular	Qty	Rate	Amount	Discount 10%	Net Amt	VAT 13%	Total Amt
1	Book	30	55
2	Copy	30	20
3	Computer	10	12000
4	Table	10	2000
5	C.P.U.	10	7000
6	Mouse	10	200
7	Keyboard	15	300
8	Chair	12	500
9	Monitor	5	10000
10	Photocopy	3	24000

Formula of Amount

=Qty*Rate 8 (Enter)

Formula of Discount

=Amount*10 %8 (Enter)

Formula of Net Amount

=Amount-Discount 8 (Enter)

Formula of VAT:

=Net Amt*13% 8 (Enter)

Formula of Total Amount

=Net Amt+VAT 8 (Enter)

3.     Salary Sheet

Question: A company paid T.A.D.A as per as his/her post. If they are G.M then they got 20% of their salary, if M.D, Accountant, Sales and Peon they got 15%, 12%, 10% and 5% respectively of their salary. If the company paid 5% Bonus and cuts their P. Fund of 10% then calculate their net salary.

S.No.	Name	Post	Salary	T.A.D.A.	Bonus	P. Fund	Net Salary
1	Namuna Thapa	G.M	15000
2	Mamata Kandel	M.D	18000
3	Kopila Dahal	Acc.	8000
4	Suprava Luitel	Sales	6000
5	Muna Kandel	Peon	4000

Formula of T.A.D.A

=if(Post=“G.M”,Salary*20%,if(Post=“M.D”,Salary*15%,if(Post=“Acc.”,Salary*12%,if(Post=“Sales”,Salary*10%,if(Post=“Peon”,Salary*5%)))))8 (Enter)

Formula of Bonus

=Salary*5%8 (Enter)

Formula of P. Fund

=Salary*10%8 (Enter)

Formula of Net Salary

=Salary+T.A.D.A+Bonus-P.Fund 8 (Enter)

4.     Telephone Bill

Question: If the customers have minimum 175 calls then they will be given Rs. 225 and other additional calls have Rs. 2 as per call. If the office took 10% VAT and 12% Tax then calculate the net amount.

Nepal Telecom Sundhara Kathmandu Ph: 4555566
S.No.	Name	Address	Calls	Amount	VAT	Tax	Net. Amt.
1	Namuna Thapa	Jamal	51
2	Mamata Kandel	Kalopul	850
3	Kopila Dahal	Tinkune	142
4	Suprava Luitel	Ason	540
5	Muna Kandel	Chabahil	186

Formula of Amount:

=if(Total Calls<=175,225,225+(Total Calls-175)*2) 8 (Enter)

Formula of VAT:

=Amount*10%8 (Enter)

Formula of Tax:

=(Amount+VAT)*10%8 (Enter)

Formula of Net Amount:

=Amount+VAT+Tax 8 (Enter)