Microsoft Excel 2010

 Microsoft Excel 2010

This program is developed by Microsoft Company. So, it is known as Microsoft Excel. It is a spreadsheet program we can insert data, process them short them, filter them and create chart from the data etc. in this program we can perform various kinds of mathematical, financial, engineering calculator, using this program. We can create bill, voucher, salary sheet, mark sheet, income and expenses statement purchase book, sale book, balance sheet etc.

 

1.    Maximum

Name	Balance
Hari	1500
Gita	1800
Shyam	1200

Formula

F =MAX(select all balance)

 

2.    Minimum

Name	Balance
Sita	4500
Anita	4600
Binita	4800

Formula

F =MIN(select all balance)

 

3.    Average value

Name	Balance
John	500
Romeo	300
Ram	400
Shyam	200

Formula

F =AVERAGE(Select all balance)

4.    Find Male and female (Countif)

S.N	Name	Gender
1.	Hari	M
2.	Gita	F
3.	Shyam	M
4.	Ram	M

 Find theTotal No. of Male

Formula: =countif(select all gender,”M”)

 

5.    Amount Bill

S.n	Particular	Qty	Rate	Amount	Discount	Net amount
1	Mouse	10	100
2	CPU	15	1000
3	Keyboard	5	200
4	Monitor	12	500

Formula

Amount

F =Rate×Qty

Discount

F =Amount×5%

Net amount

F =Amount-Discount

6.    Interest Bill

S.n	Name	Address	Time	Principal	Rate	Interest	Total amount	Monthly	Daily
1	Ram	Sindhuli	5	500000	10%
2	Shyam	Sindhuli	15	15000	5%
3	Hari	Marin	25	30000	1%
4	Gita	Sarlahi	30	20000	3%

Formula

Interest

F =P×T×R

Total amount

F =P+I

Monthly

F =I/12

Daily

F =M/30

 

7.    Mark sheet

		Subjects
S.n	Name	Eng	Math	Sci	Soc	Nep	Pop	Total	Percent		Result	Division	grade	Rank
1	Shanti	66	56	76	23	54	34
2	Kanti	77	87	65	32	34	54
3	Som	67	55	88	76	65	65
4	Tom	23	20	43	20	23	22

Formula

o   Total number

=Sum (Select all subjects)

o   Percent

=total number/number of subjects

o   Result

=if (percent>=40,”Pass”,”fail”)

o   Division

=if(percent>=60,”First Division”,if(percent>=50,”Second Division”,if(percent>=40,”Third Division”,if(percent<40,”You are Fail Plz Try again”))))

o   Grade

=IF(percentage>=90,"A+",IF(percentage>=80,"A",IF(percentage>=70,"B+",IF(percentage>=60,"B",IF(percentage>=50,"C+",IF(percentage>=40,"C",IF(percentage>=30,"D+",IF(percentage>=20,"D",IF(percentage<20,"E")))))))))

o   Rank

=Rank(select only one first percentage, Select all percentage  click every number from second and press F4)