Categories: create marksheet in ms excel pdfhow to create marksheet in ms excel step by stepstudent mark sheet in excel format xls downloadstudent marksheet in excel template

Microsoft Office Excel-2007, Market sheet, Marks Sheet, Salary Sheet, Medical Sheet with Formula

 

Market Sheet

 

A

B

C

D

E

F

G

1

Item Name

Quantity

Unit

Rate

Sale

Discount

Total Sale

2

Apple

10

Kg

80

800

40

760

3

Rice

20

Kg

30

600

30

570

4

M. Oil

5

Liter

180

900

45

855

5

T Shirt

2

Pic.

550

1100

110

990

 

Sale=B2*D2(Quantity * Rate)

Discount=if(E2>1000, E2*10%,if(E2>=500,E2*5%,
if(E2<500,E2*0%)))

Total Sale=E2-F2(Sale-Discount)





Marks Sheet

 

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

Roll No

Name

English

Assamese

G. Science

Maths

S. Science

Hindi

Total

PASS/FAIL

Division

Percentage(%)

Maximum

Minimum

2

10124

Minu Murah

35

50

44

45

44

55

273

PASS

2ND

45.5

55

35

3

10246

Nikita Das

45

45

45

55

47

65

302

PASS

2ND

50.33

65

45

4

10045

Sneha Deb

70

78

60

47

67

78

400

PASS

1ST

66.66

78

47

 Formula

Total= SUM(C2:H2)

Pass/ Fail=if(i2>=180, “Pass”, “Fail”) 

Division=if(i2>=360,”1st”,if(i2>=270,”2nd”,if(i2>=180,”3rd”,”fail”)))

Percentage=i2*100/600

Maximum= Max(C2:H2)

Minimum= Min(C2:H2)





Salary Sheet

 

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

1

EMP
NAME

EMP
ID

ADDRESS

POST

BP

HRA
(8%)

DA
(9%)

TA
(10%)

MD
(12%)

GS

PF
(12%)

LIC

GD

NS

AS

IT

2

PANKAJ

121

Guwahati

MANAGER

45000

3600

4050

4500

5400

62550

5400

1600

7000

55550

666600

33330

3

RAJU

122

Dibrugarh

PRINCIPAL

60000

4800

5400

6000

6000

82200

7200

1600

8800

73400

880800

44040

4

RAM

123

Tinsukia

INCHARGE

35000

2800

3150

3500

4200

48650

4200

1600

5800

42850

514200

25710

 Formula

HRA(House
Rent Allowance)=E2*8%

DA(Dearness
Allowance)=E2*9%

TA ( Travelling
Allowance)=E2*10%

MD(Medical)=E2*12%

GS(Gross Salary)=
sum(E2:I2)

PF(Provident
Fund)=E2*12%

LIC(Life
Insurance Corporation of India)=Type Here Own Rs.1500/2000

GD(Gross
Deduction)=K2+L2

NS(Net
Salary)=J2-M2

AS(Annual
Salary)=N2*12

IT(Income Tax)=IF(O3>60000,O3*5%,IF(O3>40000,O3*3%,IF(O3<40000,O3*0%)))















pabitraurang

Leave a Comment
Share
Published by
pabitraurang
3 years ago

Recent Posts

What is Coding in Computer

Coding in computer is the step-by-step process of designing and writing instructions that a computer…

4 weeks ago

Ishan Uday Scholarship 2025

The Ishan Uday Scholarship, launched by the University Grants Commission (UGC), is a transformative initiative…

1 month ago

10 best application for leave of absence to principal

 1. Application for Sick Leave To The Principal, Public School, TSK ( Type Here Own…

3 months ago

Importance Of Computer Education

 1. ছাত্ৰ-ছাত্ৰীয়ে নিজা গতিৰে শিকাত আনন্দ পায়। সেইবাবে শিক্ষাৰ ক্ষেত্ৰত কম্পিউটাৰ ব্যৱহাৰ কৰা এক গুৰুত্বপূর্ণ…

6 months ago

Computer Keyboard

 Computer KeyboardThe key board is a widely used and popular input. This product is not…

3 years ago

Advantage and Disadvantage of computer

 Advantage and Disadvantage of computer  Advantage of Computer1. Any calculation or work in the computer…

3 years ago