For Marksheet Tips

For Total (K7)

=SUM(c7:j7) 

For Result (L7)

=IF(AND(c7>=32,d7>=32,e7>=32,f7>=32,g7>=32,h7>=32,i7>=32,j7>=32),"Fail","Pass")
=IF(OR(c7<32,d7<32,e7<32,f7<32,g7<32,h7<32,i7<32j7<32)  For Percentage (M7) =M7/800*100  For Division (N7) =IF(AND(N7>=80),"Distinction",IF(AND(N7>=60),"Fisrt",IF(AND(N7>=40),"Second",IF(AND(N7>=32),"Third","Fail"))) 

For Remarks (O7)

=IF(N7="Distinction","Excellent",if(N7="First","First","Very Good",if(n7="Second","Good",IF(n7="Third","Satifactory","Try Again"))) 

For Rank (P7)

=RANK(M7,M7:M15) 

Or Other's

=RANK(M7,$M$7:$M$15) 

For Making Bill

For Making Bill

S.N	Item/Particular	Rate	Quantity/Qty.		Amount
1	Copy	100	2		200
2	Pen	200	4		800
				Total	1000
				Disc.	100
				VAT	117
				G.T	1017

ÿ Amount

o   Multiply by rate & Qty.

o   Eg.=c2*d2 8

ÿ Total

o   Add all cells or

o   =Sum(e2:e3) 8

o   Or you can press the key in the same time Alt++= sign

ÿ Disc.  Discounts

o   Total * Percentage of the Discount

o   E.g. =E4*10% 8

ÿ VAT.  Value Added tax

o   Total – Discount and Multiply by Percentages of the VAT

o   E.G. =(E4-E5)*13% 8

ÿ G.T.   Grand Total

o   Total – Discount and Add the VAT.

o   =(E4-E5)+VAT 8

Microsoft Excel Exercise

Lab :

Code No.             3001                    3002                     3003

Employee            Ritesh                  Suresh                 Arun

Basic Salary         12000                  25000                  5400

Allowance            ?                           ?                           ?

Provident Fund   ?                           ?                           ?

Net Salary           ?                           ?                           ?

Questions:

Calculate allowance, provident fund and net salary

ÿ Allowance=5% of Basic Salary

ÿ Provident=10% of Basic Salary

ÿ Net Salary=(basic Salary + Allowance)-Provident Fund