M S Excel Computer Lab Assignments with Solutions

Microsoft Oce Excel Exercise 1 Name

Science

Math

English

Total

Average

Daniel Maureen  John !ihar "o#nath ri&a "'oorthi

89 67 78 86 75 86 68

87 81 86 89 87 76 61

79 69 86 86 6$ 53 72

255 217 25 261 226 215 21

85 72.33 83.33 87 75.33 71.66 67

Percentag e 85 % 72 % 83 % 87 % 75 % 72 % 67 %

Exercise 2 Name

Kannada

English

Hindi

Total

Average

(n)ali !ai#a !i*hil  +alan  +alan "hre&a ra,athi (nu

75 87 68 68 76 8$ 85

87 68 6$ 69 $9 69 96

6$ 57 67 6$ 58 71 55

226 212 199 21 183 22$ 236

75.33 7.66 66.33 67 61 7$.66 78.66

Percentag e 75 % 71 % 66 % 67 % 61 % 75 % 79 %

Exercise 3 Name

Math

Science

Social

Total

Average

"har#a -u'ta Malhotra hatna,ar "axena /aritha (sh0ini

78 68 $9 67 75 79 86

59 9$ 58 73 69 6$ 7$

68 75 $7 79 $8 73 69

25 237 15$ 219 192 216 229

68.33 79 51.33 73 6$ 72 76.33

Percentag e 68 % 79 % 51 % 73 % 6$ % 72 % 76 %

Exercise 4 Name

Kannada

English

Hindi

Total

Average

en)a#in (u,ustine Dai E0ar harles El4ert ell&

76 97 59 68 $9 76 68

8$ 67 68 76 67 8$ 85

79 8$ 71 59 58 52 73

239 2$8 198 23 17$ 212 226

79.66 82.66 66 67.66 58 7.66 75.33

Page 1

Percentag e 8 % 83 % 66 % 68 % 58 % 71 % 75 %

Microsoft Oce Excel Exercise 5 Name

Test 1

Test 2

Test 3

Total

Average

ran* ace -ett& o4ert (#&  John (lan

72 68 67 58 55 72 81

67 73 58 67 59 85 73

75 85 67 $9 57 6$ 72

21$ 226 192 17$ 171 221 226

71.33 75.33 6$ 58 57 73.66 75.33

Percentag e 71 % 75 % 6$ % 58 % 57 % 7$ % 75 %

Exercise  !orld"ide S#orting $oods

1819.21

(e)r&ar ' 1766.55

19$2.88

Total Sales 5528.6$

Ex#ens es 12$1.

Net Sales $287.6$

Avg Sales 18$2.88

*ro"n

17$.38

189.1

165.28

5163.67

1165.

3998.67

1721.22

!allace

29.69

2195.19

2159.29

636$.17

165.

$71$.17

2121.39

Adams

19$8.$$

1725.56

187.26

55$$.26

13$5.

$199.26

18$8.9

Total

7$81.72

7$96.31

7622.71

226.7 $

5$1.

17199.7 $

7533.58

Sales

%an&ar'

Smith

March

Exercise + !orld"ide S#orting $oods , -&stomer Sales , .ast /ear 0tr 1

0tr 2

0tr 3

0tr 4

Total

"'orts it&

Stat &s 2

15568

16523

17658

18952

6871

Averag e 17175

(thletes Drea#

3

21356

225$7

2$598

23691

92192

23$8

"'orts E#'oriu#

1

22571

23681

22698

2$995

939$5

23$86

"'orts :orl

$

1$568

15$23

16532

152$8

61771

15$$3

 +ennis  +ennis )oint

3

1652

9865

1156

1156$

$2237

1559

(thletes :orl

2

236$

18596

19532

23$8

788$

1971

-om#an'

Page 2

Microsoft Oce Excel "'orts#ans Den

1

21$57

2567

22365

2256

86$$5

21611

:orl of "'orts

3

15862

16538

17568

18563

68531

17133

"'ecialt& "'orts

$

187$5

19865

2361

2$55

79$26

19857

 +otal  +otal

1611$3

16365

171$68

175872

67288

16822

(era,e

1795

18178

1952

195$1

7$676

18669

Exercise  P&)lic School !a#e

 +est  +est 1

 +est  +est 2

 +est  +est 3

 +est  +est $

 +est  +est 5

 +est  +est 6

 +otal  +otal

(era, e

;eronic a

$7

75

68

$9

57

67

3 63

6.5

ett&

59

2$

67

32

59

62

3 21

53.5

(rchie

68

75

71

$9

53

6$

38

63.33

Mar,e

59

6$

28

53

57

$1

3 2

5.33

e,,ie

31

5$

62

55

$7

53

3 2

5.33

er 61 % 5$ % 63 % 5 % 5 %

Min

Max

esult

$7

75

ass

32

67

ail

$9

75

ass

28

6$

ail

31

62

ail

Exercise  Sl No

$end er

Age

Ethnicit'

Planned maor

-ategor'

-ollege

1

#ale

18

0hite

4usiness

4usiness

4usiness

2

#ale

18

0hite

electrical en,ineerin,

en,ineerin,

en,ineerin,

3

#ale

19

0hite

4iolo,&

natural science

$

#ale

18

0hite

#ath

#ath

5

#ale

19

0hite

co#'uter science

co#'uter science

6

#ale

19

0hite

co#'uter science

co#'uter science

Page 3

arts an sciences arts an sciences arts an sciences arts an sciences

Microsoft Oce Excel 7

#ale

2

0hite

,ra'hic esi,n


arts an sciences

8

#ale

19

his'anic

seconar& eucation

eucation

eucation

9

#ale

2

4usiness

4usiness

4usiness

1

#ale

19

'olitical science

social science

arts an sciences 4usiness

11 12 13 1$ 15 16 17 18 19 2

fe#al e fe#al e fe#al e fe#al e fe#al e fe#al e fe#al e fe#al e fe#al e fe#al e

african= a#erican african= a#erican

22

:hite

4usiness

4usiness

19

:hite

french

hu#anities

18

:hite

anthro'olo,&

social science

19

:hite

en,lish

hu#anities

2

:hite

ele#entar& eucation

eucation

eucation

21

:hite

co#'uter science

co#'uter science

arts an sciences

19

african= a#erican

eucation

eucation

21

asian

seconar& eucation earl& chilhoo eucation

eucation

eucation

19

his'anic

en,lish

hu#anities

22

african= a#erican

'olitical science

social science

21

#ale

19

0hite

theatre


22

#ale

19

his'anic

co##unications

hu#anities

arts an sciences arts an sciences arts an sciences

arts an sciences arts an sciences arts an sciences arts an sciences

Exercise 1 !ages

6nventor'

S&##lies

Sales

Pro7t

(''arel

1

5

2

75

13

/ar0are

22

1

2

15

26

 +o&s  +o&s

5

35

2

75

33

urniture

1

3

2

725

5525

Page 4

Microsoft Oce Excel Electronics

2

9

2

22

18

oo

15

$75

35

9675

375

Totals

82

32855

1835

8+

28

Exercise 11 -ards and gi9ts 2 sales 1st 0&arter

2nd 0&arter

3rd 0&arter

4th 0&arter

Average

-ene -enera rall ar ars

221 22188 88

21 21 99 99

222 22 253 53

282 28 231 31

23$ 23 $$3 $3

937 93 771 71

"easonal ars

16277

17377

1776

19819

1788

71233

-ift :ra'

5566

5$$5

6125

6223

58$

23359

"tationer&

1289

1$95

129

2188

15$5

6181

-ene -enerral -ift -ifts s

169 16 926 26

173 17 351 51

137 13 796 96

2$ 2 $59 59

171 17 133 33

685 68 532 32

"easo "easona nall -ift -ifts s

1122 11223 3

122 12 225 25

126 12 65$ 5$

136 13 665 65

12$ 12 $$2 $2

$97 $9 767 67

Maxi#u#

22188

2199

22253

28231

23$$3

93771

1$95

129

2188

15$5

6181

12$99

123

1598

1335

521$1

Mini#u#

1289

(era,e

122$5

Total

73$69

7$992

73797

9585

78211

2 Totals

3128$3

Exercise 12 Acme 6ncor#orated Sales :e#ort Northern ;istrict

So&thern ;istrict

!estern ;istrict

Eastern ;istrict

Total

"ales 1

56789

$578$

78327

56783

237683

"ales 2

76$89

626$6

73$56

67328

279919

"ales 3

625$3

5$786

7198

5$987

2$$296

"ales $

71239

659

83265

69736

291$

Page 5

Microsoft Oce Excel Maxi#u#

76$89

659

83265

69736

291$

Mini#u#

56789

$578$

7198

5$987

237683

(era,e

66765

57279

76757

6229

2631

 +otal

2676

229116

3728

2$883$

15238

Exercise 13 Eat -a
>uarters !( !( !( !( !( !(

?ear 25 25 25 25 25 25

hannel etail artner Direct "ales aterin, @nternet Mall stores

orecast 9$573$ 87698 3$5876 23$587 $5698 678$35

Exercise 14 Name

(irst Name

$enre

6ncome

Sit&ation

-hild

 Jan)uah

o4

Man

2

elationshi'



"ara

"u#it

Man

8

Marrie

1

ha#'ne&

o4ert

Man

67

Marrie



 Jonas

Aee

Man

35

elationshi'



"a#en

Michael

Man

77

"in,le



"ata*e

aori

Man

7

Marrie

3

Aeon

ernano

Man

23

"in,le

3

&erl&

i#4erl&

:o#an

97

elationshi'

1

:arner

!orris

Man

26

Diorce

3

-auefro&

Marie

:o#an

89

elationshi'



ha'

Mathe0

:o#an

77

"in,le

2

"i#'son

(u4re&

Man

3$

Diorce



or&ce

Dai

Man

61

elationshi'

2

 +ortelli

Olao

:o#an

27

"in,le



Page 

Microsoft Oce Excel (coc*

Dai

:o#an

72

Diorce

3

ontat

+hi4ault

Man

85

elationshi'

1

BiCCari

"te'hen

:o#an

8$

"in,le

3

re&er

Jean=Auc

Man

5

"in,le

2

 Jones

Dai

Man

31

"in,le



Exercise 15 !ee
.ast Name

(irst Name

Total Ho&rs

Ho&rl' Pa'

Total Pa'

-ul

Dou,

8

8.55

68.$

1863

-uCi*

"ue

$

9.55

38.2

1878

Mai

hris

6

1.

6.

1913

/a

ichar

7

11.25

78.75

2156

olte

Ellen

8

11.

88.

3788

Miller

in&

8

15.

12.

$11

Miller

Jan

6

13.25

79.5

$56$

utler

+eresa

9

12.5

112.5

$793

(4els

-in,er

5

11.5

57.5

578

ause&

+i#

$

9.5

38.

516

ha#4ers

Julie

6

2.

12.

5128

ha#4ers

Aes

8

16.

128.

51$5

(4ell

ruce

8

1$.

112.

571$

Miller

ein

1

13.

13.

6566

Miller

ueana

8

9.25

7$.

6569

Eas

Aina

6

1.25

61.5

778

ussell

"usan

$

11.75

$7.

Exercise 1 Page +

Microsoft Oce Excel Month

Sales :e#

:egion

-ontacts

Sales

Ann&ali=ed

 Jan

o4

!orth

58

2838

3689$

 Jan

ran*

!orth

35

572

686$

 Jan

aul

"outh

25

176

12912

 Jan

an&

"outh

$7

3916

$6992

 Jan

Mar&

"outh

39

2267

272$

e4

o4

!orth

$$

558$

678

e4

Jill

!orth

$6

35$

$2$8

e4

ran*

!orth

7$

$118

$9$16

e4

aul

"outh

29

15$2

185$

e4

an&

"outh

$5

258

396

e4

Mar&

"outh

52

2338

2856

Mar

o4

!orth

3

3531

$2372

Mar

Jill

!orth

$$

5321

63852

Mar

ran*

!orth

57

258$

318

Mar

aul

"outh

13

286

3$32

Mar

an&

"outh

1$

1622

19$6$

Exercise 1+  ?ear

198  198 1 198 2 198 3 198 $

 +e#' a,F

 +e#' #axF

 +e#' #inF

G of eain,s

ainfall inF

28

32

1

1

11

+ro'ical

-eor,e

25

37

=5

1

2

Desert

Ji#

=3

1

=32

1

$

(rctic

Janet

18

28

=15

1

56

 +e#'erat Mi*e e

25

38

13

1

98

+ro'ical

Page 

li#ate

O4serer

ill

Microsoft Oce Excel 198 5 198 6 198 7 198 8 198 9 199  199 1 199 2 199 3 199 $ 199 5 199 6 199 7 199 8 199 9 2  2 1 2 2 2 3

28

32

1

1

11

+ro'ical

ill

25

37

=5

1

2

Desert

ill

=3

1

=32

1

$

(rctic

Ji#

18

28

=15

1

56

 +e#'erat  Janet e

25

38

13

1

98

+ro'ical

ill

28

32

1

1

11

+ro'ical

Janet

25

37

=5

1

2

Desert

Ji#

=3

1

=32

1

$

(rctic

Ji#

18

28

=15

1

56

 +e#'erat -eor,e e

25

38

13

1

98

+ro'ical

-eor,e

28

32

1

1

11

+ro'ical

ill

25

38

13

1

98

+ro'ical

Janet

28

32

1

1

11

+ro'ical

ill

25

37

=5

1

2

Desert

ill

=3

1

=32

1

$

(rctic

Ji#

18

28

=15

1

56

 +e#'erat  Janet e

25

38

13

1

98

+ro'ical

ill

28

32

1

1

11

+ro'ical

Janet

25

37

=5

1

2

Desert

Ji#

Page 

Microsoft Oce Excel 2 $ 2 5 2 6

=3

1

=32

1

$

(rctic

Ji#

18

28

=15

1

56

 +e#'erat -eor,e e

25

38

13

1

98

+ro'ical

-eor,e

Exercise 1 Eastern 12 0&arters 1

0&arters 2

0&arters 3

0&arters 4

-olf

5

2

15

2

"afari

9

6

$

5

 +ennis

15

5

6

15

1585

85

81

85

0&arters 1

0&arters 2

0&arters 3

0&arters 4

:insur
18

5

65

175

-olf

35

25

6$3

$59

6

32

$7

5

1183

18+

1+8

11834

0&arters 1

0&arters 2

0&arters 3

0&arters 4

55

15

1$

25

"afari

1

65

$$

$5

 +ennis

1

8

55

1

185

8

835

8

Total Sales

!estern 12

 +ennis

Total Sales

Eastern 13 -olf

Total Sales

Page 1

Microsoft Oce Excel !estern 13 0&arters 1

0&arters 2

0&arters 3

0&arters 4

:insur
185

$

55

155

-olf

15

25

$75

25

65

2

$59

555

85

85

14815

815

53815

385

43815

3845

 +ennis

Total Sales $rand Total Sales

Exercise 1 @te# ate,or&

@te# +&'e

@te#G

urrent ost

@nentor&

inal ost

lour

astr&

$

7

2

1$

lour

:hole :heat

5

$.2

3

12.6

lour

:: astr&

1$

7

7

$9

lour

:hole :heat

15

$.2

$

16.8

lour

astr&

2$

7

5

35

@cin,

utter crea#

6

1.75

3

5.25

@cin,

o&al

7

2.25

5

11.25

@cin,

onant

8

3.5

$

1$

@cin,

lue utter crea#

16

1.75

15

26.25

@cin,

lue o&al

17

2.25

8

18

@cin,

lue onant

18

3.5

6

21

Mix

hocolate

1

5.25

$

21

Mix

;anilla

2

3

1

3

Mix

Mar4le

3

$.25

2

8.5

Page 11

Microsoft Oce Excel Mix

Dutch hocolate

11

7.25

3

21.75

Mix

o&al ;anilla

12

$

15

6

Mix

oun

13

5.25

11

57.75

Mix

rench hocolate

21

6.25

1

62.5

Mix

rench ;anilla

22

$

13

52

Mix

Mar4le

23

5.25

2

1.5

"'rin*les

"u,ar

9

1.5

22

23.1

"'rin*les

"u,ar ree

19

1.5

16

16.8

 +o''in,s

"u,ar

1

1.3

19

2$.7

 +o''in,s

"u,ar ree

2

1.3

$

5.2

Exercise 2 riHOctH5

"atHOctH5

"unHOctH 5

MonHOctH  +ueHOctH5 5

:eHOctH 5

 +huHOctH 5

1

5

1

1

=1

65

3

25

51

999

7

=15

66

9

$

52

998

13

=2

67

15

55

53

997

19

=25

68

21

7

5$

996

25

=3

69

27

85

55

995

31

=35

7

33

1

56

99$

37

=$

71

39

115

57

993

$3

=$5

72

$5

13

58

992

$9

=5

73

51

1$5

59

991

55

=55

7$

57

16

6

99

61

=6

75

63

175

61

989

67

=65

76

69

Page 12

Microsoft Oce Excel 19

62

988

73

=7

77

75

25

63

987

79

=75

78

81

22

6$

986

85

=8

79

87

235

65

985

91

=85

8

93

25

66

98$

97

=9

81

99

265

67

983

13

=95

82

15

28

68

982

19

=1

83

111

295

69

981

115

=15

8$

117

31

7

98

121

=11

85

123

325

71

979

127

=115

86

129

3$

72

978

133

=12

87

135

355

73

977

139

=125

88

1$1

37

7$

976

1$5

=13

89

1$7

Exercise 21 Admission No

.ast Name

(irst Name

Exam 1

Exam 2

Exam 3

Total

66

(ltieros

Melissa

75

72

66

213

9$3

ol4urn

Mar&

92

95

91

278

983

Dais

Michael

$$

52

73

169

1326

Dais

ell&

93

92

86

271

1572

Dou,las

+heresa

88

7$

69

231

2563

D0&er

/elen

92

91

88

271

2637

-ott

Michelle

9

77

85

252

2679

/ar&

ussell

78

76

79

233

2773

/o4son

Jen

98

92

92

282

2779

/olt

!icholas

91

89

83

263

Page 13

Microsoft Oce Excel 2981

Jac*son

"cott

95

95

91

281

3789

Jac*son

enneth

73

57

68

198

387$

Ao'eC

Elaine

65

78

71

21$

$662

Meese

Erin

82

75

72

229

$875

Mittelstat

"te'hanie

72

75

8

227

$919

Oestreich

Jennifer

71

55

76

22

969

"teele

&lie

91

72

8

2$3

9873

:illia#son

Aina

76

69

75

22

Exercise 22 P( Statement 9or the month o9 %&l' Sl No 

Partic&lars

*asic

1

/.. I (#in

5

2

"ecurit&

3

3

(ccounts

5

$

Maintenanc e

3

5

Driers

6

6

ouncer

325

7

I "erice

35

Medic al

!ash Allo"an ce

S#ecial Allo"anc e

?the rs

Total

>;A

H:A

-?N >

1 1 1 1 1 1 1 1 1 1 1 1 1 1

2 

8

125

6

263$9



1 



8

125



269$9



6

2

8



6

599



1

$





6

999



6

215

8

125



799



12

6

25



6

799



65

6

5



6

799



7

Page 14

Microsoft Oce Excel 8

ront Oce

9 1 11

I rouction /ouse ee'in, itchen "te0arin,

12

$25 75 325 325

+rainee

2$5

$rand Total

121$5 

1 1 1 1 1 1 1 1 1 1 12 12

8

6



6

12$9



85

26

8

125



18$9



15

6

25



6

799



65

6

25



6

799



65

$





6

1$9



55

375 

585

5

5$

6338



2$35 

Exercise 23 6ron !or
 %an

(e)

236

583

$53

28$

129$

788

3638

1789$

1712

1289$

1288$

15623

17$33

937$

$783

593221

$8853$

589322

$99322

523855

1879$5

198$22

21123

2938$$

1988$3

219

18956

198$2

17363

1876$

198$6

17883

11265$

38953

398$7

37855

399

38755

37129

2315$8

193 55

28$773 3

189532 2

198$$7 2

175833 2

18$673 $

122626 $8

Mini#u#

193 55 236

28$773 3 583

189532 2 $53

198$$7 2 28$

175833 2 129$

18$673 $ 788

(era,e

38172

53951

37978

$19797

361716

377692

2672 $2

371666 

26535$ $

293857 9

25321 5

26$38$ 1

122626 $8 3638 2$595 $ 171566 81

"0itch 'lates  +in eilin,s Door lates Aoc* "ets a4inet no4s Dra0er ulls athroo# /ar0are Maxi#u#

 +otal

Page 15

Ma'

%&n

Total

317225 7 12819 6

Microsoft Oce Excel Exercise 24 A*- .imited (or the #eriod o9 2 @ 22 E;E!E

2

21

22

-ross "ales

7

75

9

"ales eturns

2

23

28

5

52

2

2

21

22

e,innin, @nentor&

35

36

$2

-oos urchase

12

165

185

$7

525

65

36

$2

$35

434

43

515



3+

55

OE(+@!EKE!"E"

2

21

22

"ellin,

62

73

$6

$$5

5275

6

15

125+5

1

@45

@+5

@4+5

Taxes on 6ncome

@1225

@33+5

@213+5

Net Pro7t

@222+5

@4125

@2125

NET SA.ES

O"+ O "(AE"

 +otal -oos (aila4le Enin, @nentor&

Total cost o9 $oods -ons&med $ross Pro7t

-eneralH(#inistrat ie Total ?#erating Ex#enses 6ncome )e9ore Taxes

!ote L net sales  ,ross sales N sales return

Page 1

Microsoft Oce Excel  +otal cost of ,oos consu#e  +otal -oos (aila4le = Enin, @nentor& -ross 'ro
Exercise 25 6;

.ast Name

(irst Name

;e#artment

Extension

1

ur#eister

(llen

Deelo'#ent

5325

2

ole

rancis

u4lications

5277

3

onra

John

usto#er "u''ort

5$2$

$

Dixon

olleen

/u#an esources

5387

5

El'hin

rena

u4lications

5298

6

ran*lin

enito

"ales I Mar*etin,

571

7

-rith

"usan

/u#an esources

5321

8

/enr&

urt

"hi''in,

5167

9

/irsch

(lexa

/u#an esources

53$5

1

a'lan

Dan

(ccountin,

5598

11

a'ur

Maeline

(ccountin,

55

12

Aao

+on&

u4lications

5211

13

AinQuist

Donal

"ales I Mar*etin,

5727

1$

Mercer

Ernest

Deelo'#ent

5333

15

Mur'h&

ran*lin

Deelo'#ent

5676

16

"'encer

elicit&

u4lications

529

Page 1+

Microsoft Oce Excel 17

"te'hens

Mar&anne

"ales I Mar*etin,

5763

18

+ai

(nna

Deelo'#ent

531

19

+ho#as

-eor,e

"hi''in,

5189

2

+ran

Mar,aret

(ccountin,

5571

Exercise 2 Name

State

-it'

Prod&ct

0&antit'

Mitron

alifornia

"an Jose

D=OM

6$

nit Price .25

"#ith

alifornia

Aos (n,eles

D=OM

152

.25

38

-arcia

Massachus etts

oston

"#art ar

282

25.3

713$.6

+exas

Dallas

D;D=OM

292

.55

16.6

oston

D;D=OM

336

.55

18$.8

oston

D;D=OM

3$

.55

167.2

+exas

Dallas

e&4oar

331

7.5

 ?o*uchi

+exas

Dallas

D=OM

385

.25

 ?an,

!eaa

Aas ;e,as

le "

285

12.$5

 ?an,

!eaa

Aas ;e,as

/ar rie

16$

75

123

+exas

Dallas

D;D=OM

3$$

.55

189.2

!eaa

Aas ;e,as

D=OM

53

.25

13.25

"#ith

alifornia

Aos (n,eles

D=OM

283

.25

7.75

harlton

+exas

Dallas

D;D=OM

313

.55

172.15

+exas

/ouston

D;D=OM

397

.55

218.35

harlton

+exas

Dallas

"

$88

12.$5

675.6

harlton

+exas

Dallas

"#art ar

181

25.3

$579.3

 ?o*uchi -arcia -arcia harlton

harlton  ?an,

 Julian

Massachus etts Massachus etts

Page 1

Total 16

2$82.5 96.25 35$8.25

Microsoft Oce Excel harlton

+exas

Dallas

"

$6

12.$5

5727

!eaa

Aas ;e,as

/ar rie

9

75

675

ro0n

alifornia

"an rancisco

rinter

26

5$

1$$

oular

Massachus etts

"'rin,
D;D=OM

286

.55

157.3

Mitron

alifornia

"an Jose

D;D=OM

25$

.55

139.7

oston

rinter

398

5$

"'rin,
"#art ar

185

25.3

"'rin,
/ar rie

15

75

1125

+exas

/ouston

rinter

228

5$

12312

alifornia

"an Jose

"#art ar

28$

25.3

!eaa

Aas ;e,as

/ar rie

$72

75

35$

+exas

Dallas

e&4oar

53

7.5

397.5

+exas

Dallas

"#art ar

372

25.3

oular

Massachus etts

"'rin,
e&4oar

$9

7.5

"#ith

alifornia

Aos (n,eles

D=OM

1

.25

-arcia

Massachus etts

oston

rinter

5

5$

27

+exas

/ouston

rinter

37$

5$

2196

Massachus etts

"'rin,
e&4oar

285

7.5

2137.5

 ?an,

!eaa

Aas ;e,as

rinter

376

5$

23$

 ?an,

!eaa

Aas ;e,as

D=OM

25

.25

-arcia

Massachus etts

oston

rinter

$71

5$

25$3$

Mitron

alifornia

"an Jose

rinter

366

5$

1976$

Mitron

alifornia

"an Jose

"#art ar

365

25.3

 ?an,

-arcia oular oular  Julian Mitron  ?an, harlton  ?o*uchi

 Julian oular

Massachus etts Massachus etts Massachus etts

Page 1

21$92 $68.5

7185.2

9$11.6 3675 25

6.25

923$.5

Microsoft Oce Excel Exercise 2+ A to B ?Cce S&##lies 0&arterl' Sales 23 Sales Person

0tr1

0tr2

0tr3

0tr4

Total

!ichols +o

12

$23

521

625

2769

-reen her&l

65$

63$

326

75$

2368

inle& o4ert

2567

239

35

2389

1351

 Jen*ins Jerr&

233

532

525

652

19$2

ran*lin :illia#

35$

633

$22

255

166$

"oer#an a#ela

255

525

252

62$

1656

ar'enter anace

$22

6$2

6$2

62$

233

"utherlan atricia

85$

36$

$7$

7$3

2$35

:illia#s :alter

223$

2567

2987

25$6

133$

oo#4s Dallas

356

63$

632

7$3

2365

Maxi#u#

2567

2567

35

25$6

1351

Mini#u#

233

36$

252

255

1656

(era,e

913

93$

979

996

3821

9129

93$$

9786

9955

3821$

 +otal

Exercise 2    &    r    a    u    n    a     J

   &    r    a    u    r      4    e     6

     h      l      i    c    r    r    '    a     (     M

   &    a     M

   e    n    u     J

   &      l    u     J

Page 2

    t    s    u    ,    u     (

   r    e      4    #    e     t    '    e     "

   r    e      4    o     t    c     O

   r    r    e    e      4      4    #    #    e    e    c    1    e    o     !     D

     l    a     t    o     +

Microsoft Oce Excel @nco#e

15 

ixe 75 ex'ens ;aria4les 6 ex'ens (#ount of  135 ex'ens  esult

15

1 

1 

18 

27 

27 

33 

363

231 

1732 .5

12 

138 

75

75

75

75

75

75

75

75

75

75

75

5

5

18$  259 

211 6 286 6

16  235 

576

11

$3$

139  = 19

132 6

35

2$33 .$ 3183 .$ $$6. 6

6$

125  = 25

16  235 

5$

125  = 25

15  225  = $5

2$252. 5 9.  1$$$5. $ 23$$5. $

5$

87.1

=$

129 $$2. 5

!oteL result  inco#e N a#ount of ex'ens

Exercise 2 ;o"nto"n 6nternet -a9D Ann&al (orecast    '    r    a    &    n    a     %

   '    r    a    &    r     )    e     (

    h    c    r    a     M

    l     i    r    #     A

133 

136 

1$2 

1$$ 

58  36  1 

6  38  11 

62  38  11 

o#'uter

$

$

Total Sales

2$1 

722

   e     )    m    e     t    #    e     S

   r    e     )    o     t    c     ?

   r    e     )    m    e    v    o     N

   r    e     )    m    e    c    e     ;

   e    n    &     %

   '     l    &     %

    t    s    &    g    &     A

152 

155 

156 

157 

158 

162 

168 

62  36  15 

62  38  15 

62  38  15 

6$5  5  21 

65  51  22 

65  52  22 

67  58  23 

69  625  2$ 

$

6

6

8

775

8

8

9

95

1

8$25

2$9 

257 

263 

273 

278 

2992 5

33 

35 

319 

333 

3$ 

3$62 5

7$8

769

762

79$

81

883

893

92

95$

12 

121 5

1253 5

   '    a     M

    l    a     t    o     T

Sales Es'resso Dri' oee ooHeera ,es Merchanise

171 

7 6$ 25

183$ 

7665  5615  21$ 

Ex#enses ost of

Page 21

Microsoft Oce Excel -oos

5









5

5

5





ost of Merchanise

7

77

77 9 

15  786 

15  839 

15  87$ 

1$7  9 

15$  9 

15$  9 

161  95 

168  98 

a&roll

9 

9 

@nternet

325

325

325

325

325

325

325

325

325

325

uilin,

21 

21 

21 

21 

21 

21 

21 

21 

21 

(ertisin,

6

6

6

6

6

6

6

6

a'ital (ssets Miscellaneou s

15  13 

15  13 

15  13 

15  13 

15  13 

15  13 

15  13 

2275 

237 5

2328 5

2235 5

232 5

2363 

135 

182 5

2$1 5

39$ 5

$9 5

5.6 %

7.33 %

9.$ %

15%

15%

Total Ex#enses

Net 6ncome Pro7t Margin

12 

1$98  18$ 9

325

325

39

21 

21 

21

252 

6

6

6

6

72

15  13 

15  13 

15  13 

15  13 

2513 

253 

2538 5

26$7 5

2732 5

2799 

2959 5

$17 

$79 5

5 

511 5

5$2 5

597 5

61 

512 

15%

16%

16%

16%

17%

17%

17%

175

15 13

18  156 

16%

!oteL !et @nco#e  +otal "ales N +otal Ex'enses ro
Exercise 3 Save Sa)le :iver (o&ndation .i9etime (&ndraising S&mmar'

or'orate

(llento0 n 7$29.3 5

ha#4er it& 92278.21

atonsil le 6381.7 $

Page 22

"a4le ;illa,e 8$21.2

"tron,s ille 616$$.2 6

 +o0n of  ar& 8982.5 1

 +otal $656$. 9

Microsoft Oce Excel Direct Mail un uns -oern#en t hone=a= thon

Maxim&m Minim&m Average Total

67286. 6 5$7$.3 9 3623.9 9 16692.1 $ 7$29.3 5 16692.1 $ $8667.1 9

2438335 3

83867.23 6693$.67 5861$.35

5576.$ 8 6$581.6 6 51$86.$ 6

555$7.28 28895.86 36387.9

2$223.81

9$92.91

17328.7$

92278.21

6$581.6 6

8$21.2

2$223.81

9$92.91

17328.7$

65183.65

$87$3.8 5

$$$73.8

32581 2+

2438+1 25

22283 

79779. 2 3269.3 7 516$2.5 5 1235.8 5

8$366.1 9 6$2$2.7 2 $177.8 7 2197.6 

$25922.2 6 312$9.6 7 268932.3 1 111$1. 5

79779. 2 1235.8 5 $7612.$ 1

8982.5 1 2197.6  599$.9 8

$656$. 9 111$1. 5 31$621.8 8

2382 5

28+4 

185+381 3

Exercise 31 Advent&re Travels 1st 0tr

2nd 0tr

3rd 0tr

4th 0tr

Total

ar entals

12$65

12$875

1265

1291$5

5517

(irlines

225

22692

229995

23539

917287

112553

135655

15675

175585

573271

2236$8

2567892

2756215

3125689

1686276

55

555$5

595655

65115

231315

2236$8

2567892

2756215

3125689

1686276

Mini#u#

12$65

12$875

1265

1291$5

5517

(era,e

852332

96$17$

1$188

117238

$28552

48218

4828

58284

585181

281428+5

 +our ac*a,es ruise ac*a,es /otels

Maxi#u#

Total

Exercise 32 Page 23

Microsoft Oce Excel Em#lo'e e 6;

.ast Name

(irst Name

Address

-it'

212

"chi

ha

235 !. actus Dr.

hester
(

92122

617

!ichols

ath&

75 roo*lea Dr.

Aanis

(

9212

97

ennin,t on

Mar*

23 Mill (e.

Aanis

ca

9212

3225

Mor,an

Dan

56$ ". Ae#on Dr.

Malin

(

92121

3$6

Ao'eC

Mina

$29 E. (la#ea Dr.

Malin

(

92121=37$

389

+hi

Erona

7867 orest (e.

ier Mist

(

92123

$321

"a4in

-re,

9 E. a0hie (e.

hester
(

92122

$731

Marchant

o4erta

56$ al# (enue

Aanis

(

9212

515

ri,,s

"cott

ier Mist

a

92123=2232

6

o4ertso n

ir*

Malin

(

92121

7287

o#an

(nita

23$8 ". ala Dr.

Malin

(

92121=37$

8391

uiC

EnriQue

35 al# "t.

hester
(

92122=1268

117$7

Aetto0

&an

358 Ma'le Dr.

Malin

(

92121=37$

1219$

olons*&

Mitch

871 E. "herian

Malin

(

92121=37$

12213

?oun,

i#

89 olle,e (e.

Aanis

(

9212

1223

eie

"uCanne

932 E. ar*0a& Dr.

Aanis

(

9212

122$7

ath

ath&

87 E. (urora (e.

(

92122=1268

12258

Delano

-oron

(

92122=1268

12366

"tace&

Dai

(

92122=1268

12389 1251

lac*#a n DeAuca

 Jennifer EliCa4eth

$5 E. a#el4ac* . 832 ". :illia# (e.

State

B6P -ode

131 !. "'rinrift Dr. 737 ". olle,e .

hester
773 E. Aaurel "t.

ier Mist

(

92123=2232

21 :. "outhern

Aanis

(

9212

Page 24

Microsoft Oce Excel (e. 12583

"ullian

Marie

78 O#e,a Drie

hester
(

92122=1268

1259$

eie

Mar*

9 :. a#'us Dr.

Malin

(

92121

12612

Aetto0

Melissa

23$ !. 1st "t.

ier Mist

(

92123

12655

Aahti

Jill

5$1 E. +ho#as .

Aanis

(

9212

Exercise 33

Ne" -ar Sales  Januar&

e4ruar&

March

+otal "ales

(lfre

6856

87657

67865

22$82

(ntonie

7$768

123$

95$65

27$67

ass

875$6

98555

83655

269756

1765

1235$3

3$999

25937

unnis

88765

1876

98655

288296

heris#a

35

65987

56787

15777$

Dela

6798

87657

56766

212$3

Dixon

82987

12675

$5673

231335

Dear4orn

98765

132987

15$67

337219

leurior

765$6

1265$7

11675

3$768

/e&t

65785

87657

67865

22137

/inton

6575$

123$

95$65

261$53

in,

98673

98555

83655

28883

1$65$

1235$3

92876

32173

88765

1876

98655

288296

rale&

Aa#ons !uel#an

Page 25

Microsoft Oce Excel "un

$5676

65987

65$78

1771$1

 +ullos

98765

87657

98675

28597

:ashin,ton

82987

67876

3$765

185628

Ba''a

98765

8965$

87678

27697

Bela&a

765$6

99765

99678

275989

Maxim&m

1$65$

132987

15$67

337219

Minim&m

35

65987

3$765

15777$

Average

8$3

97$26

7859

256$19

18852

1848522

185+18++

581283+1

Total

Exercise 34 Animal Angels >ol&nteers 1st 0tr

2nd 0tr

3rd 0tr

4th 0tr

Average

Total

$5

3$

12

35

5$

216

16

$5

55

16

78

312

arer athi

3

83

3

3

29.75

119

horle& est&

68

2

235

96

1.25

$1

lar* Ja#el

51

3

28

58

$1.75

167

o& Martin

28

66

6

$5

36.25

1$5

Dic*son Diane

72

19

77

32

5

2

E0ars Mi*e

12

2

61

28

3.25

121

er,uson o44&

99

12



$3

38.5

15$

orester i#4erl&

32

66

3$

3

$.5

162

ran*lin "tace&

57

98

93

8

82

328

ulton (nne

13

25

55

1

$8.25

193

ell atricia are& onnie

Page 2

Microsoft Oce Excel -arcia Maria

5

23

61

36

31.25

125

-atens hris



1

58

85

6.75

2$3

/enerson Ja#es

9

76

51

6

$9

196

@n,ra# /elen

29

12

33

12

21.5

86

@s4ell "on&a

$6

65

$7

3

$.25

161

5

25

18

7

13.75

55

7

83

38

79

67.5

27

13

78

52

88

57.75

231

$

59

57

8

32

128

ull#an one&

28

3

35

16

27.25

19

Aa a,lia "all&

39

1

12

13$

$8.75

195

Aee "u

56

6

5



16.75

67

Ae,,e ristan

3

81

73

3$

$7.75

191

Ao'eC (nre0

83

3

165



62.75

251

Marcus Danielle

3

19

2$

2

12

$8

Mer0in Michael

$$

9

95

37

$6.25

185

!elson aith

1

115

8



33.25

133

 Johnson +ha#an  Jones ('ril ell& :illia# ettonhoeer ill

Exercise 35 .ast Name

(irst Name

Address

-it'

3333

(rtea,a

Ella

58 Aan,le& (enue

2222

arrin,t on

in&

7777

runer

5555 6666

6;

Stat e

Bi# -ode

(urora

!

2837

271 Aatrell oa

alti#ore

!

2836

M&ra

182 irch0oo "treet

efu,io

!

2835

aruso

Jill

52$ i,e oa

"'rin, Aa*e

!

2839

harlton

ara

52 /iro*o "treet

"'rin, Aa*e

!

2839

Page 2+

Phone 91F $13= $728 91F $28= $137 91F 331= 552 91F $2= 963 91F 38$= $911

Microsoft Oce Excel 81 olu#4us oa 72 :hite Ea,le "treet

123$

-ett&

:illia#

1111

-iens

r&an

$$$$

/aller

-enea

9999

eane

;ic*ie

8888

Mai

+on&

985 Aisa "treet $7 arol&n (enue 732 Ore,on "treet

uena ;ista

!

283$

a&etteille

!

2831

"'rin, Aa*e

!

2839

Mileton

!

2839

Maison

!

2832

91F $75= $153 91F $56= 566 91F 357= 362 91F $73= 7752 91F 35= 939

Exercise 3 T'#e o9 Transaction -ategor'

0tr

;escri#tion o9 Transaction

!ithdra"al

De4it ar

-rocer&

1

"tartin, (ccount alance

hec*

Mort,a,e

1

Mr. -Rs

De4it ar

-rocer&

1

aceless Mort,a,e or'

Electric

1

Mr. -Rs

reit ar

1

E-H"&ner,&

De4it ar

-rocer&

1

o0er an*

(+M

(+M

1

Mr. -Rs

92.6$

ell hone

1

ash

68.6$

a4le

1

us& si,nal hone o

3.

(+M

(+M

1

ostl& a4le o

7.

(+M

(+M

1

ash

115.35

De4it ar

-rocer&

1

ash

28.72

(uto#atic :ithra0al

:ater

1

:in,sR  s

1.

(+M

(+M

1

it& tilities

39.63

(uto#atic

Electric

1

ash

(uto#atic :ithra0al (uto#atic :ithra0al

(uto#atic :ithra0al (uto#atic :ithra0al

Page 2

128. 11$.$2 37.9 35. 71.1$ 1.

112.59

Microsoft Oce Excel :ithra0al (uto#atic :ithra0al

-as

1

E-H"&ner,&

De4it ar

-rocer&

1

!atRs -as "erice

Direct De'osit

a&chec*

1

Mr. -Rs

(+M

(+M

1

Direct e'osite

hec*

Mort,a,e

1

ash

$.

(uto#atic :ithra0al

reit ar

1

aceless Mort,a,e or'

93.76

(+M

(+M

1

o0er an*

(uto#atic :ithra0al

ell hone

1

ash

(+M

(+M

1

us& si,nal hone o

(uto#atic :ithra0al

a4le

1

ash

8.

De4it ar

-rocer&

1

ostl& a4le o

7.

(+M

(+M

1

Mr. -Rs

(+M

(+M

1

ash

128.

De4it ar

-rocer&

1

ash

11$.$2

hec*

Mort,a,e

1

"tartin, (ccount alance

178.$9 5. 128. 35.

1. 68.6$ 3.$3

158.18

37.9

Exercise 3+ :egion

:e#

6tem

nits

nit -ost

East

Jones

encil

95

1.99

189.5

entral

iell

iner

5

19.99

999.5

entral

Jarine

encil

36

$.99

179.6$

entral

-ill

en

27

19.99

539.73

:est

"orino

encil

56

2.99

167.$$

East

Jones

iner

6

$.99

299.$

entral

(nre0s

encil

75

1.99

1$9.25

Page 2

Total

Microsoft Oce Excel entral

Jarine

encil

9

$.99

$$9.1

:est

+ho#'son

encil

32

1.99

63.68

East

Jones

iner

6

8.99

539.$

entral

Mor,an

encil

9

$.99

$$9.1

East

/o0ar

iner

29

1.99

57.71

East

arent

iner

81

19.99

East

Jones

encil

35

$.99

17$.65

entral

"#ith

Des*

2

125.

25.

East

Jones

en "et

16

15.99

255.8$

entral

Mor,an

iner

28

8.99

251.72

East

Jones

en

6$

8.99

575.36

East

arent

en

15

19.99

299.85

entral

iell

en "et

96

$.99

$79.$

entral

"#ith

encil

67

1.29

86.$3

East

arent

en "et

7$

15.99

entral

-ill

iner

$6

8.99

entral

"#ith

iner

87

15.

East

Jones

iner

$

$.99

:est

"orino

iner

7

19.99

139.93

entral

Jarine

en "et

5

$.99

2$9.5

entral

(nre0s

encil

66

1.99

131.3$

East

/o0ar

en

96

$.99

$79.$

entral

-ill

encil

53

1.29

68.37

entral

-ill

iner

8

8.99

719.2

entral

iell

Des*

5

125.

625.

East

Jones

en "et

62

$.99

39.38

entral

Mor,an

en "et

55

12.$9

686.95

Page 3

1619.19

1183.26 $13.5$ 135. 19.96

Microsoft Oce Excel entral

iell

en "et

$2

23.95

15.9

:est

"orino

Des*

3

275.

entral

-ill

encil

7

1.29

9.3

:est

"orino

en

76

1.99

151.2$

:est

+ho#'son

iner

57

19.99

entral

(nre0s

encil

1$

1.29

18.6

entral

Jarine

iner

11

$.99

5$.89

entral

Jarine

iner

9$

19.99

entral

(nre0s

iner

28

$.99

825.

1139.$3

1879.6 139.72

Exercise 3 A7cionado $&itar Parts Monthl' Acco&nts :eceiva)le *alance :e#ort -&stomer

*eginn ing *alanc e

-redits

Pa'ments

P&rchase s

Service -harge

Ne" *alance

erantes atriel

83.1

56.92

277.2

27.9$

12.9

689.91

285.5

87.$1

182.11

218.22

.$3

23$.18

72.13

79.33

18.9

36$.2

12.17

818.9

$38.37

6.9

331.1

19.39

1.28

238.$

Aanctot o&ce

378.81

$8.55

126.15

211.38

5.61

$21.1

a,lo0 Dora

71.99

55.62

231.37

27$.71

11.66

71.37

$82.7$

85.1

129.67

332.89

7.37

68.32

Totals

381 1

4+3+4

1845+51

18+55

5142

38+22

Maxim&m

83.1

87.$1

331.1

36$.2

12.9

818.9

u##in,s  +renton Danielsson Olier alino0s*i  Ja0i,a

 +uan Ain

Page 31

Microsoft Oce Excel Minim&m

285.5

$8.55

126.15

19.39

.$3

23$.18

Average

5$3.1

67.68

28.22

257.8

7.35

531.55

!oteL serice char,e  2.75% P  4e,innin, 4alance N creits N 'a&#ents N 'urchases F !e0 4alance  4e,innin, 4alance  creits  'a&#ents  'urchases  serice char,es

Exercise 3

 +?/=1M!3

Prod&ct N&m)er 1123

 +=2M!$

1$56

98 %

$95

$876

 +?/=1M!3

1356

99 %

378

3769

 +=2M!$

1$87

99 %

$95

$777

!;=9M!1

1876

96 %

$9

$$35

 +?/=1M!3

11

9 %

5

$57

 +?/=1M!3

11

91 %

$5

$6$1

Prod&ct Name

98 %

6n#&t 0&antit' 5

?&t#&t 0&antit' $95

 /ield

Exercise 4 Transaction

-ategor'

hec* 21

Mort,a,e

De4it ar

-rocer&

;escri#tion aceless Mort,a,e or' Mr. -Rs

Electric

E-H"&ner,&

reit ar

Aar,o reit or'

De4it ar

-rocer&

Mr. -Rs

(+M

(+M

ash

(uto#atic :ithra0al

ell hone

us& si,nal hone o

(uto#atic :ithra0al (uto#atic :ithra0al

Page 32

!ithdra"al 78 11$.$2 37.9 15 71.1$ 1 $2.6$

Microsoft Oce Excel (uto#atic :ithra0al

a4le

ostl& a4le o

(+M

(+M

ash

3

(+M

(+M

ash

7

reit ar

-rocer&

:in,sR  s

115.35

(uto#atic :ithra0al

:ater

it& tilities

28.72

(+M

(+M

ash

Electric

E-H"&ner,&

-as

!atRs -as "erice

112.59

De4it ar

-rocer&

Mr. -Rs

178.$9

(+M

(+M

ash

hec* 22

Mort,a,e

aceless Mort,a,e or'

78

15

(uto#atic :ithra0al (uto#atic :ithra0al

28.6$

1 39.63

5

Direct De'osit (uto#atic :ithra0al

reit ar

Aar,o reit or'

(+M

(+M

ash

(uto#atic :ithra0al

ell hone

us& si,nal hone o

(+M

(+M

ash

(uto#atic :ithra0al

a4le

ostl& a4le o

hec* 19

;oi

(+M

(+M

ash

8

(+M

(+M

ash

7

:ater

it& tilities

28.72

Electric

E-H"&ner,&

39.$5

-as

!atRs -as "erice

(uto#atic :ithra0al (uto#atic :ithra0al (uto#atic :ithra0al

Page 33

$ $3.76 1 28.6$

12.77

Microsoft Oce Excel (+M

(+M

ash

hec* 23

Mort,a,e

aceless Mort,a,e or'

8 78

Direct De'osit (+M

(+M

ash

reit ar

-rocer&

Mr. -Rs

169.8$

De4it ar

-rocer&

Mr. -Rs

$$.8

(uto#atic :ithra0al

reit ar

Aar,o reit or'

(+M

(+M

ash

a4le

ostl& a4le o

28.6$

ell hone

us& si,nal hone o

5.7$

De4it ar

-rocer&

Mr. -Rs

(+M

(+M

ash

(uto#atic :ithra0al

:ater

it& tilities

28.72

De4it ar

-rocer&

Mr. -Rs

81.79

(uto#atic :ithra0al

Electric

E-H"&ner,&

35.52

De4it ar

-rocer&

Mr. -Rs

9$.59

(uto#atic :ithra0al

-as

!atRs -as "erice

73.87

(uto#atic :ithra0al (uto#atic :ithra0al

7

15 9

131.51 3

Direct De'osit hec* 2$

Mort,a,e

aceless Mort,a,e or'

De4it ar

-rocer&

Mr. -Rs

78 133.6$

Exercise 41 A##lication (irst Name  123 Maril&n

.ast Name

Address

-it'

oster

55 Aincoln (e.

rent0oo

Page 34

Microsoft Oce Excel 125

Mi*hail

"ieerho

17 "'&,lass ir.

Oceanie0

138

?onne

ra&

31 anoe (e.

al#ale

139

(elle

aenou,h

999 "eas'ra& Dr.

al#ale

1$6

Olef

orisno

$3 "*i ir.

rent0oo

1$7

Aenn&

re0ster

21 al# "t.

Aexin,ton

15

arol&n

:elsh

186 (la#ea "t.

rent0oo

158

Danielle

!ash

725 :ater0a& An.

Oceanie0

167

?on,

:u

326 oc*0ell "t.

Oceanie0

173

Jessica

le,,

532 ( "t.

al#ale

177

hristo'her

in*le

323 Aorr& (e.

Aexin,ton

18

aul

;ishon

212 /unt .

Oceanie0

199

+erence

ratt

172$ Aa*e0oo .

Aexin,ton

26

(h#e

Ja#al

511 a4rillo ir.

rent0oo

29

Ail&

/a##on

6$ "'rin, "t.

al#ale

211

Ernest

/el#s

$9 :ilson (e.

al#ale

222

o4erta

Dre0

23 "canlan .

al#ale

232

Aeon

rench

188 1th (e.

Oceanie0

2$1

:en&

+ho#'son

19$7 &'ress Dr.

Aexin,ton

256

Moha##e

atan

297 5th (e.

Oceanie0

263

o4

(lareC

616 ;asser :a&

Oceanie0

26$

;incent

(shton

387 (la#o :a&

Aexin,ton

3

/ere

#eCa

812 -rant (e.

rent0oo

31

hilli'

o4erts

1221 erret "t.

Oceanie0

Exercise 42 ;ata Entr' 9or (inancial (orecast Anal'sis 26

27

Page 35

28

29

our ?ear  +otals

Microsoft Oce Excel Sales 8538   8538 

"ales

21.

26.

21218.

23918.

Other









21.

26.

21218.

23918.

32 5 1255 

3296 515 12875 

339$88 53$5 132613 

38988 5$5$5 186363 

183+81+ 288 5+28+25 

9$5

97335

12551

11291

484181

165

18665

111925

1279

485418

19

19

19

19

+8

5

515

53$5

5$5$5

28

3 5 3

39 515 39

31827 535 3183

32727 5$55 3273

1258454 28 128545

1

13

161

161

48152

1 2133 11 $

13 2197 1133 $12

161 2263 1167 $2$$

161 2263 1267 $2$$

48152 85 48+ 18+

6

618

6365

6365

24811

1

13

161

161

48152

3

39

3183

3183

128455

1

13

161

161

48152

1

13

161

161

48152

1 1 6

13 13 6

161 161 6

161 161 6

48152 48152 248

 +otal "ales

.ess -ost o9 $oods Sold Materials Aa4or Oerhea Other  +otal ost of -oos "ol -ross ro
?#erating Ex#enses "alaries an 0a,es E#'lo&ee ene
Page 3

Microsoft Oce Excel Ex'ense Other

Total ?#erating Ex#enses











31+8133

328++

324851

32815

18285

Exercise 43 .ast Name

(irst Name

;octor Name

S#ecialt'

Sam#le s

.&nches

/ollars

"tace&

/ollars "tace&

a#il& Meicine

1

no

"#ith

arol

"#ith arol

E#er,enc&

9

&es

-riese#er

Joshua

ariolo,&

5

no

Mconnell

(licia

"'orts Meicine

15

&es

ro4us

ell&

ro4us ell&

E#er,enc&

9

&es

o,ers

Michael

o,ers Michael

a#il& Meicine

1

&es

Mur'h&

+ina

Mur'h& +ina

ariolo,&

5

no

ates

(lex

ates (lex

eiatrics

7

no

-laish

Juith

-laish Juith

eiatrics

5

no

Aa0

+ara

Aa0 +ara

eiatrics

8

no

(sh

her&l

(sh her&l

aiolo,&

1

&es

lanton

"a#uel

ariolo,&

13

&es

-riese#er

Joshua

ariolo,&

8

no

$

&es

7

no

-riese#er  Joshua Mconnell (licia

lanton "a#uel -riese#er  Joshua

Jennifer

Jones Jennifer

Mconnell

(licia

Mconnell (licia

"'orts Meicine "'orts Meicine

(sh

her&l

(sh her&l

aiolo,&

3

no

-laish

Juith

-laish Juith

eiatrics

2

no

 Jones

Page 3+

Microsoft Oce Excel "#ith

arol

"#ith arol

E#er,enc&

15

&es

Mur'h&

+ina

Mur'h& +ina

ariolo,&

3

&es

"#ith

arol

"#ith arol

E#er,enc&



&es

ro4us

ell&

ro4us ell&

E#er,enc&



&es

o,ers

Michael

o,ers Michael

a#il& Meicine



no

ates

(lex

ates (lex

aiolo,&

2

no

Jennifer

Jones Jennifer

"'orts Meicine

1

no

Mur'h&

+ina

Mur'h& +ina

ariolo,&

15

&es

ates

(lex

ates (lex

aiolo,&

1

&es

Jennifer

Jones Jennifer

"'orts Meicine

5

no

Aa0

+ara

Aa0 +ara

eiatrics

6

&es

lanton

"a#uel

lanton "a#uel

ariolo,&

1

&es

Aa0

+ara

Aa0 +ara

eiatrics

15

no

-riese#er

Joshua

-riese#er  Joshua

ariolo,&

11

&es

 Jones

 Jones

 Jones

Jennifer

Jones Jennifer

"'orts Meicine

9

no

Maris

Jonathon

Maris Jonathon

E#er,enc&

1$

no

arnes

Ethan

arnes Ethan

eiatrics

1

no

artner

De4ra

artner De4ra

a#il& Meicine

15

&es

Mco&

"arah

Mco& "arah

E#er,enc&

1$

&es

"#ith

arol

"#ith arol

E#er,enc&

3

&es

ariolo,&

1$

&es

 +ho#'son

Jennifer

 +ho#'son  Jennifer

ates

(lex

ates (lex

aiolo,&

1$

&es

Aa0

+ara

Aa0 +ara

eiatrics

2

no

lanton

"a#uel

lanton

ariolo,&

6

no

Page 3

Microsoft Oce Excel "a#uel -riese#er

Joshua

ro4us

ell&

o,ers

-riese#er  Joshua

ariolo,&

1

&es

ro4us ell&

E#er,enc&

13

no

Michael

o,ers Michael

12

&es

/ollars

"tace&

/ollars "tace&

a#il& Meicine a#il& Meicine

6

&es

lanton

"a#uel

ariolo,&

5

no

-riese#er

Joshua

ariolo,&

1

&es

lanton "a#uel -riese#er  Joshua

Jennifer

Jones Jennifer

"'orts Meicine

1

no

"#ith

arol

"#ith arol

E#er,enc&

6

&es

-riese#er

Joshua

ariolo,&

12

&es

 Jones

-riese#er  Joshua

Exercise 44 Part N&m)er

T'#e

1116$539

+

1116$5$

(

1116$5$1

(

1116$5$2

+

1116$5$$

(

1116$5$5

DE

1116$5$6

DE

1116$5$7

DE

;e#artmen t De'art#ent 2 De'art#ent 5 De'art#ent $ De'art#ent 2 De'art#ent 5 De'art#ent 5 De'art#ent 2 De'art#ent $ Page 3

-ost

0&antit'

Total >al&e

55.3

15

829.5

69.58

7

$87.6

$7.87

1

$7.87

16.22

5

81.1

5$.36

=

7$.$5

13

967.85

52.3

11

572.33

25.7$

8

25.92

Microsoft Oce Excel 1116$5$8

D

1116$5$9

DE

1116$55

D

1116$551

+

1116$556

DE

1116$557

(

1116$558

DE

1116$559

(

1116$56

+

1116$561

+

1116$562

DE

1116$563

DE

1116$56$

(

1116$565

+

1116$567

(

1116$568

(

1116$569

DE

1116$57

D

De'art#ent 5 De'art#ent $ De'art#ent 1 De'art#ent 2 De'art#ent $ De'art#ent 2 De'art#ent 1 De'art#ent 1 De'art#ent 5 De'art#ent 3 De'art#ent 2 De'art#ent 1 De'art#ent 5 De'art#ent 2 De'art#ent 3 De'art#ent 1 De'art#ent 3 De'art#ent 3

Exercise 45 Page 4

39.12

1$

5$7.68

1.97

3

32.91

18.56

12

222.72

$5.8

17

778.6

88.39

2

176.78

79.8

12

9$8.96

15.28

7

16.96

2.77

15

$1.55

$.96

=

25.7

12

3.8$

.8$

12

1.8

9.$2

3

28.26

16.2

7

112.1$

77.83

$

311.32

1.5$

15

23.1

9.81

1

9.81

1.77

8

1$.16

7.99

13

13.87

Microsoft Oce Excel $ro" More Hos#italit' Services Private .imited

Page 41

Microsoft Oce Excel Salar' Statement 9or the month o9 ;ecem)er 211 Sl No 

6; No

Name

*asic

>;A

H:A

-?N >

Medic al

!ash Allo"

5  3 

1 1 1 1 1 1

2 

8



8

2

8



6

S#l Allo"

?the rs

Total



1 



6

599



1

Administration 1 2 3

-M (llen 1  +i#oth& J -M ersha0 2 Dai Aa'ha# arrie (

5

125  125 

6 

263$ 9 269$ 9

Total

58 

38 3

228 

284 

285 

182 

538 +



18+8 

(4el Mar& E

3

11

$





6

999



6

Total

3

1 1

4













"entell +ricia  J

6

11

215

8

125



799



12

roer rian

225

11

55





6

99

1$8

$6$8

325

11

6

25



6

799



65

35

11

6

5



6

799



7

Sec&rit' $

Acco&nts 5

113

6 7

652

8

ea#ish oleen Mason  +i#oth&

9

ose -ina M

$25

11

8

6



6

12$9



85

1

"tre4& aul -

75

11

26

8

125



18$9



15

Total

2+5 

 

+3

25 

25

24 

554

14

534

325

11

6

25



6

799



65

Maintenance 11

82$

+err& (nrea

Page 42

Microsoft Oce Excel Total

325

1 1



25





+



5

aner)ee u#a

325

11

6

25



6

799



65

13

a'tist Jan

2$5

11

$





6

1$9



55

1$

artlett Aisa

2$5

11

$





6

1$9



55

2$5

11

$





6

1$9



55

2$5

11

$





6

1$9



55

Total

135 

5 5

22

25



3 

45



25

17

D&er Ju& (

$5

11

7

7



6

1$99



9

18

al#a -race 

$5

11

7

7



6

1$99



9

Total



2 2

14

14 



12 

2



1

;rivers 12

11$

15 16

arne& Aina M oon#en  Ja#ie

*o&ncer

( F * Services 19

i ea J

6

11

2$

8



6

1199



12

2

 Jaurs "heri E

75

11

26

8

125



18$9



15

21

/ale& John J

$5

11

7

7



6

1$99



9

35

11

6

5



6

799



7

25

11

75





6

1$9



5

22 23

-loer or& M l&nn r&stal (

2$

Ellis Joel

225

11

55





6

99

3$2

$8$2

25

here# ar4ara

3

11

$





6

999



6

26

ur ein 

25

11

75





6

1$9



5

27

l&e aul "

$

11

16





6

799



8

Page 43

Microsoft Oce Excel 28

l&e aul "

225

11

55





6

99

3$2

$8$2

29

lar* "usan M

225

11

55





6

99

3$2

$8$2

3

oo*  Jane

3

11

$





6

999



6

31

on* Mario

225

11

55





6

99

3$2

$8$2

32

o#o Darrin

225

11

55





6

99

3$2

$8$2

33

"alata Diane A

225

11

55





6

99

3$2

$8$2

3$

Bhou huan

225

11

55





6

99

3$2

$8$2

35

Kue Kiaolin

$

11

16





6

799



8

36

!ichols Aarr&

3

11

$





6

999



6

37

Total

525 

1 1

15 

2 

125

12 

13 2

23 4

12 4

$rand Total

1993 

363 6

$995

1 5

625

192 

821$

25$ 2

335$2

Exercise 4 :andol#h Academ' 336 Main St, Randolph, NY 14772, United States @nco#e I ex'eniture for the &ear ene 31st #arch 21

PA:T6-.A:S

29 N 21  s. F

28 N 29  s. F

6N-?ME G Donation @n @! @n orei,n urrenc& EQuialent to @!

Page 44

9527$8

1231$3$6

17791

25758

Microsoft Oce Excel an* @nterest On an* Ds

$11$7

195983

3$799

3817

37$$6$

337385

8$9



138+5845+

15848+54

$26121

38788

325

275

83535

87$3968

619

6695

1285285

12838+

"A" H  DE@@+ F EOE DEE@(+@O!

92251

3$6956

AessL De'reciation

813776

8589

18+25

2818+

On an* (ccount

ro)ect ecei'ts

Other @nco#e

T?TA.

EPEN;6T:E G (#inistratie Ex'enses Donation ro)ect Ex'enses (liation ees

T?TA.

"A" H  DE@@+ F +(!EED +O O" !D

Exercise 4+ :andol#h Academ' 336 Main St, Randolph, NY 14772, United States @nco#e I ex'eniture for the &ear ene 31st #arch 21 Page 45

Microsoft Oce Excel PA:T6-.A:S

29 N 21  s. F

28 N 29  s. F

O'enin, alance

235



eceie Durin, the &ear

66

235

285

2385

1129$27

883256

18725

2196867

118138152

1182842+

Sched&le No 1 Me#4ershi' un

Total

Sched&le No 2 or'us un O'enin, alance Excess of @nco#e oer Ex'eniture

Total

Exercise 4 *alance Sheet @ /ears 1 to 4 ?#ening

/ear 1

/ear 2

/ear 3

/ear 4

576$ $3 393928 $52$ 11255

$51 12 35 $ 1

$6$53 32 365 $12 13

$78$66 3 371315 $2$36 169

$9282 3$ 382$5$ $3791 1927

183+82 1

1821282 

1825853 

182+8+5 

18328 2

27122 1 $52$

2$  $

2$72  $12

25$616  $2$36

26225$ 5 $3791

ASSETS -&rrent Assets ash !otes eceia4le (ccounts receia4le net @nentor& Other Total -&rrent Assets .ong@Term Assets ro'ert& 'lant an eQui'#ent Aess accu#ulate e'reciation

Page 4

Microsoft Oce Excel 22511 8 58765

2  55

26  559

21218  56827

2185$5 $ 57782

Total .ong@Term Assets

2838+ 3

28558 

281158 

281+82 +

28243823 

Total Assets

38++8+ 4

382+82 

383843 

38483+ +

38582 

67535

6

618

6365$

655636

112551

1

13

169

19273

112551 33765 11296 188

1 3 9 16

13 39 927 16$8

169 31827 95$81 1697$

19273 32782 983$5 17$8$

185384+ 

38

48

382

18228+ 2

692156

612

62$2

6$563

66838

112551 8593

1 79

13 865

169 8235

19273 8$11

81

+82

+85

348+

182

18448 

18+182 

18++183 

182+8+ 2

18484+ 4

1 1 56275 157571 2

1 1 5 1$ 

1 1 515 1$$2 

1 1 53$5 1$8526 

1 1 5$636 152981 8

Total ShareholdersI EJ&it'

18+328 

185518 

185485 

18383 5

185845 4

Total .ia)ilities and ShareholdersI EJ&it'

38++8+ 4

382+82 

383843 

38483+ +

38582 

!et 'ro'ert& 'lant an eQui'#ent Other lon,=ter# assets

.6A*6.6T6ES AN; SHA:EH?.;E:SI E06T/  -&rrent .ia)ilities "hort=ter# e4t urrent #aturities of lon,=ter# e4t (ccounts 'a&a4le @nco#e taxes 'a&a4le (ccrue lia4ilities Other Total -&rrent .ia)ilities .ong@Term .ia)ilities Aon,=ter# e4t less current #aturities Deferre inco#e taxes Other lon,=ter# lia4ilities Total .ong@Term .ia)ilities Total .ia)ilities ShareholdersI EJ&it' o##on stoc* (itional 'ai=in ca'ital etaine earnin,s Other

Exercise 4 Page 4+

Microsoft Oce Excel -isco S'stems 6ndia Pvt .td Em# -ode ;e#artme nt *an< Name P( No -om# ?L  .!PA)se nt -.-. *alance MA.*alan ce

1671

Name

 Jose'h

*ranchSi te

isco "&ste#s

O'eration

;esignation

 +ech. "u''ort

$rade

"$

";

Acco&nt No

$78

;ivision

acilit& Mana,e#ent

!H!H358

ES6- No

289$56781

$H

;a's Present

22

Pan No !?LPd ?L 

H5

;a's Paid

3

H

S.S. *al

H

H

PA.*al

H

Month

$H e4 21

P.*alanc H e .*alanc H12 e

Exercise 5 Salar' Sli# E#'lo&ee !a#e Desi,nation "chool !a#e @nco#e tax (! Month an &ear Emol&ments asic 'a& /ouse rent allo0ance Dearness allo0ance Meical allo0ance ;ehicle allo0ance :ashin, allo0ance Other allo0ance Other allo0ance

$ross #a'

Ja#es (sst. +eacher "t. (nne hi,h school Aa0rence roa (#ritsar 1$3 1 (((1111A Dece#4er 21 Amo&nt :s ;ed&ctions Amo&nt :s 15 rofession tax 2 3 -eneral 'roient fun $ ontri4utor& 'roient 75 = fun 1 Aife insurance cor'oration 5 ostal life insurance 2$ -rou' insurance 15 @nco#e tax +D"F 1 reit societ& 3

258

P!et 'a&  -ross 'a& N +otal euctions

Page 4

Total ded&ctions

18

Net #a'

148+1

Microsoft Oce Excel Exercise 51 Sl No

-it'

*an<

1

(,ra

@@@

-roun Soor 18 (H51 ateh4a oa (,ra = 2821

2

(,ra

@@@

= 8 H $ a#la !a,ar (,ra = 2825

3 $ 5 6

(h#ea4 a (h#ea4 a (h#ea4 a (h#ea4 a

@@@ @@@ enturio n

Address

 JM /ouse O''.ari#al -aren O. .-. oa (#4aai (h#ea4a 38 6 2 "hashi "ho''in, o#'lex "0a#inara&an ho0* ali ;asna (h#ea4a "ar*he) -anhina,ar /i,h0a&

/"

"ho'!o.A12@nra'rastha+o0erDrie=@noa(h#ea4a385$

7

(#ritsar

@@@

(ir'ort (uthorit& of @nia a)sansi (ir'ort (#ritsar = 1$3 1

8

(#ritsar

@@@

".. 39 a4ir ar* O'' -urunana* De niersit& (#ritsar = 1$13.

9

(#ritsar

@@@

!ihi 2= Aa0rence oa (#ritsar 1$3 1.

/D

"ho' !o. 16  -roun loor

/D

arle iscuits ahaur,arh

@@@

1292 25th Main oa Ja&ana,ar 9th loc* an,alore = 5669.

@@@

!o 6$1 11th Main  $6th ross 5th loc* an,lore N 56$1

1 11 12 13 1$ 15 16 17 18

(uran,a4 a (uran,a4 a an,alor e an,alor e an,alor e an,alor e an,alor e an,alor e an,alor e

@@@ @@@ @@@

(sea ro0n oeri At. lot !o.5 I 6 @@ hase een&a @nustrial (rea 5658. (nna'urna @OA u#' .;.oa !ext +o ;i)a&a olle,e an,alore = 569. 8H7 Ele'hant oc* oa loc* @@@ Ja&ana,ar an,alore 56 $1.

@@@

366=367 1st ( Main ;@@ loc* ora#an,ala an,alore 56 95.

/D

!o. 6 o&al (rcae

Page 4

Microsoft Oce Excel Exercise 52 Proected *alance Sheet 6ntegral 6ndia So9t"are ;evelo#ment -entre Pvt .td !o. 99 #ittal to0ers 3 r #ain 2n cross an,alore N 56 1   J     a n  u  a r    &

6   e  4  r   u  a r    &

M  a r   c  h 

(    ' r  i    l   

M  a   &

  J     u n  e

  J     u l      &

(   u   ,  u  s  t  

1  2 

1 5 18 

12  2 

1  17 

13  16 

2  179 

21  178 5

22  19 

182 5 25 

26  26 

22  21 

25$ 5 18 

(ccounts receia4le

12 

15 

139 

17 

21 

13 

15 

18 

2 

157 

1$ 

16 

re'ai ex'enses

1 

1 

1 

1 

1 

1 

1 

1 

1 

1 

1 

1 

























438 

448 5

48 

458 

518 

518 

548 5

8 

482 5

8+ 

58 

84 5

alance sheet

ash @nentor&

Other current assets  +otal current assets

 e  "  r   e   ' t    e #  4 

 O  c  t    o  4   e r 

 e !  e D r   o r   e 1  c   e  e # #  4   4 

Exercise 53 Pro@(orma *alance Sheet ASSETS -&rrent Assets ash !et accounts receia4le @nentor&  +e#'orar& inest#ent

K&C co#'an& ro# 23 = 26F 23 2$ 5$ 367 177 12

Page 5

57 396 191 12

25

26

59 $26 23 12

6$ $35 12

Microsoft Oce Excel re'ai ex'enses

2

2

2

2

8128

858

+828

58138

$2 656 93 68 61

$3 656 928 631 65

$3 68$ 983 6$2 68

$6 727 121 65$ 72

Total 7xed assets

228+8

1+85581

24828

25828

T?TA. ASSETS

2828

2481381

318228

38338

Total c&rrent assets (ixed Assets Aon,=ter# inest#ents Aan uilin,s net of e'reciationF lant an eQui'#ent netF urniture an
.6A*6.6T6ES -&rrent lia)ilities (ccounts 'a&a4le "hort=ter# notes urrent 'ortion of lon,=ter# notes (ccruals an other 'a&a4les

256 2$

252 25

258 26

277 28

1$

1$

1$

15

1$

1$

1$

1$

Total c&rrent lia)ilities

388

3858

38128

38348

.ong@term lia)ilities Mort,a,e Other lon,=ter# lia4ilities

897 $$3

931 1$16

978 155

121 1597

13848

2384+8

24838

2818

3 9$$

3 96

3 15

3 17

 +otal shareholers eQuit&

128448

1288

13858

138+8

 +otal lia4ilities an eQuit&

2828

38128

4188

42858

Total long@term lia)ilities Shareholders eJ&it' a'ital stoc* etaine earnin,s

Exercise 54

Page 51

Microsoft Oce Excel Sales

Page 52

Microsoft Oce Excel  %an&a r'

(e)r& ar'

Marc h

Total Sales #er :egion

(#os (n&

52 

35

$55 

8371

o& ett&

$5 

275

52 

12$5

ox arole

65 

325

515 

1$9

Dell Denice

75 

85

75 

235

Eans Eerett

$5 

75

851 

26

ountain ran

35 

375

7852 

-arner -a4e

275 

81

75 

179

/enr& /er4

325 

$5

375 

115

@n,ra# @an

85 

825

81 

2$$

 Jac*son Ja*e

75 

75

$5 

186

25 

375

825 

81 

85

75 

2$1

565 

65

$5 

162

Sales :e#ort e,ion 1

e,ion 2

e,ion 3

in, arl Ae##ons Aeslie Muroch Martin

Page 53

8752

167

Total Sales #er Em#lo'ee 1325

1512

1$5

Microsoft Oce Excel !eil !ell&

9$ 

97

5 

3$1

7 

755

325 

178

ine h&llis

$85 

$55

35 

>uartC o&

52 

52

275 

1315

ussell &an

515 

515

325 

1355

75 

52

85 

275

851 

$5

75 

26

7852 

65

375 

;arner ;ince

$585 

75

81 

2185

:e44 :&att

7585 

$5

$5 

16585

6589 

35

825 

18339

7888 

275

825 

18888

Or#on O'rah e,ion $

"teens "tuart  +ate +ho#as e,ion 5

n,er l&sses

 ?ounts  ?olana Bi##er#an Bac*

8$1

9299

129

1812

Exercise 55 Sl No

;ata)ase Mar
Price

Microsoft Oce Excel 1. 2. 3. $. 5. 6. 7. 8. 9. 1.

Mu#4ai Delhi an,alore /&era4a -u)arat Maharashtra /ar&ana erala (nhra raesh

6 la*h 1 crore 6 la*h 2$ la*h 1.5 crore 1.2 crore 9 la*h 35 la*h 2 core

2 3 2 15 35 35 3 15 5

Mah&a raesh

25 la*h

2

 +a#il !au

1 crore

3

ttar raesh

2.5 crore

6

un)a4

$ la*h

2

11. 12. 13.

Exercise 5 -ategor'

-it'Stat e

0&antit'

1.

(ll @nia (resses Data4ase

(ll @nia

15 lac aresses

2.

/!@ Mu#4ai

Mu#4ai

3.

Jo4 "ee*ers

(ll @nia

$.

EO ersonal E#ail @s

(ll @nia

5.

o#'anies in Mu#4ai

Mu#4ai

6.

o#'anies in Delhi

Delhi

Sl No

Price 1

2 Aa*h  95% (ccurate F $ Aa*h  95% (ccurate F 5  9% (ccurate F 6 Aa*h  85% accurate F 5 Aa*h  85% (ccurate F

89 1 $5 1 1

Exercise 5+ (amil' *&dget Planner  Jan

e4

Mar

('r

Ma &

 Jun

6ncome Page 55

Jul

(u,

"e'

Oct

!o

Dec

+o t

( ,

Microsoft Oce Excel :a,es I +i's @nterest @nco#e Diiens -ifts eceie ei#4urse#e nts "ain,s Other

1  2  3  $  5  6  7 

5 1  15  2  25  3  35 

1  11  12  13  1$  15  16 

2  25  3  35  $  $5  5 

5 6 7 8 9 1  11 

35  3  25  2  15  1  5

13  16  19  22  25  28  31 

12  1$  16  18  2  22  2$ 

32  36  $  $$  $8  52  56 

18  2  22  2$  26  28  3 

1  16  22  28  3$  $  $6 

5 7 9 11  13  15  17 

 +otal

Exercise 5 (amil' *&dget Planner  Jan

e4

Mar

('r

Ma &

 Jun

Jul

(u,

"e'

Oct

!o

Dec

Home Ex#enses Mort,a,e H ent Electricit&

35  5

35  55

35  6

35  65

35  7

35  75

35  8

35  85

35  9

35  95

-as H Oil

75

8

85

9

95

75

8

85

9

:ater H "e0er

1  6 3 2  35 3

1  61 3 2  $ 3

1  62 3 2  $5 3

1  63 3 2  5 3

1  6$ 3 2  55 3

1  1  65 3 2  6 3

35  1  95

1  66 3 2  65 3

1  67 3 2  7 3

1  68 3 2  75 3

1  69 3 2  8 3

1  7 3 2  85 3

35  15  1  1  71 3 2  9 3

1

2

3

$

5

6

1

2

3

$

5

6

1  2 

1  2 

1  2 

1  2 

1  2 

1  2 

15  2 

15  2 

15  2 

15  2 

15  2 

15  2 

hone a4le @nternet urnishin,s Aa0n H -aren /o#e "u''lies Maintenance @#'roe#ent s

Page 5

+o t

( ,

Microsoft Oce Excel Other

=

=

=

=

=

=

22 

36 

=

75 

=

=

 +otal

Exercise 5 (amil' *&dget Planner  Jan

e4

Mar

('r

Ma &

 Jun

Jul

(u,

"e'

Oct

!o

Dec

6 5

65 5

6 5

65 5

6 5

65 5

6 5

65 5

6 5

65 5

6 5

65 5

3  1  $  1  3

35  1  6  1  3

3  1  2  1  3

3  1  5  1  3

35  1  $  1  3

3  1  3  1  3

35  1  2  1  3

3  1  1  1  3

35  1  2  1  3

3  1  3  1  3

35  1  1  1  3

=

=

=

35  1  3  1  3  =

=

=

=

=

=

=

=

=

Jul

(u,

"e'

Oct

!o

Dec

5

1  $5  8  3  1  2 

15  5  8  3  1  2 

2  55  8  3  1  2 

25  6  8  3  1  2 

3  65  8  3  1  2 

+o t

( ,

+o t

( ,

;ail' .iving -roceries ersonal "u''lies lothin, leanin, "erices Dinin,HEatin, out Dr& leanin, "alon H ar4er Other  +otal

Exercise  (amil' *&dget Planner  Jan

e4

Mar

('r

Ma &

1  $5  8  3  1  2 

15  5  8  3  1  2 

2  55  8  3  1  2 

25  6  8  3  1  2 

 Jun

-hildren Meical

5

lothin,

$  8  3  1  2 

"chool +uition "chool Aunch "chool "u''lies a4&sittin,

3  65  8  3  1  2 

Page 5+

$  8  3  1  2 

Microsoft Oce Excel  +o&s H -a#es Other

6  =

6  =

6  =

6  =

6  $

6  3

6  2

6  1

6  5

6  =

6  =

6  6

 +otal

Exercise 1 (amil' *&dget Planner  Jan

e4

Mar

('r

Ma &

 Jun

Jul

(u,

"e'

Oct

!o

Dec

1  3  7 3 $ =

1  3  7 3 $ =

1  3  7 3 $ =

1  3  7 3 $ =

1  3  7 3 $ =

1  3  7 3 $ =

1  3  7 3 $ =

1  3  7 3 $ =

1  3  7 3 $ =

1  3  7 3 $ =

1  3  7 3 $ =

 Jun

Jul

(u,

"e'

Oct

!o

Dec

+o t

( ,

+o t

( ,

+o t

( ,

Trans#ortation ;ehicle a&#ent uel us H +axi e'airs e,istration Other

1  3  7 3 $ =

 +otal

Exercise 2 (amil' *&dget Planner  Jan

e4

Mar

('r

Ma &

7

7

7

7

7

7

7

7

7

7

7

7

3

3

3

3

3

3

3

3

3

3

3

3

2

25

3

35

$

$5

2

25

3

35

$

$5

1  =

15  =

1  =

15  =

2  =

35  =

1  =

25  =

3  =

32  =

25  =

3  =

Jul

(u,

"e'

Oct

!o

Dec

Health Doctor H Dentist Meicine H Dru,s /ealth lu4 Dues E#er,enc& Other  +otal

Exercise 3 (amil' *&dget Planner  Jan

e4

Mar

('r

Ma &

 Jun

*&siness Ex#ense Page 5