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
 =MAX(select all balance)

2.    Minimum

Name	Balance
Sita	4500
Anita	4600
Binita	4800

Formula

 =MIN(select all balance)

3.    Average value

Name	Balance
John	500
Romeo	300
Ram	400
Shyam	200

Formula
 =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")

Formula
Amount
 =Rate×Qty
Discount
 =Amount×5%
Net amount
 =Amount-Discount

6.    Interest Bill

Formula
Interest
 =P×T×R

Total amount
 =P+I

Monthly
 =I/12

Daily
 =M/30

7.    Mark sheet

Formula
 Total number
=Sum (Select all subjects)

  Percent
=total number/number of subjects 

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

  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”))))

  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")))))))))
  Rank

=Rank(select only one first percentage, Select all percentage then change into last two number change into $ pressing F4)