[go: up one dir, main page]

0% found this document useful (0 votes)
9 views529 pages

Exercise Word and Excel

The document provides an overview of computers, detailing their definition, generations, and advancements from the first generation using vacuum tubes to the anticipated fifth generation focused on artificial intelligence. It emphasizes the continuous evolution of computer technology and the necessity for ongoing education in this field. Additionally, it includes a job application letter from a candidate seeking an engineering position, highlighting their qualifications and experience in computer science and English teaching.

Uploaded by

densoeurt680
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
9 views529 pages

Exercise Word and Excel

The document provides an overview of computers, detailing their definition, generations, and advancements from the first generation using vacuum tubes to the anticipated fifth generation focused on artificial intelligence. It emphasizes the continuous evolution of computer technology and the necessity for ongoing education in this field. Additionally, it includes a job application letter from a candidate seeking an engineering position, highlighting their qualifications and experience in computer science and English teaching.

Uploaded by

densoeurt680
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

nJtrn

ii
Ms.
Office
word
RPITSSR
Introduction
to
Computer
I.
What
is
a
computer?
Computer
is
an
electronic
machine
that
can
follow
instructions
to
after
data
in
a
desirable
way
and
to
perform
at
least
some
operations
without
human
intervention
.
Computers
represent
and
manipulate
text,
graphic,
symbols,
music
,
database
management,
and
communication
to
other
computer
by
(network,
internet
&
e-mail
system).
II-
Computer
Generation
There
was
since
Computer
has
been
changing
and
has
multiply
power
and
as
efficiency.
This
changing
has
been
recognizing
of
technologies
generation
that
provide
a
basic
for
generation
on
industry
.
Today
there
are
5
generations
of
Computer.
J
I
Fist
generation
(1942-1955):
There
are
ENLAC,
EDVAC,
ENDSAVand
other
computer
has
designed
and
used
"Vacuum
tube"
it
be
size
same
as
a
lamp
now.
It
need
more
power
full
of
electric
and
increase
more
heat.
It
memory
is
stored
in
"Magnetic
Storage"
Primarily
magnetic
trap
and
magnetic
dump
.
All
data
was
input
to
computer
by
Punched-Care
is
the
same
to
using
in
Jacquard
process.
Binary
and
Assembly
degage
has
been
using
for
program
computer.
This
operation
is
control
by
human.
2
1
Second
Generation
(1955-1960):
This
generation
computer
used
"Translator".
It
is
small
then
first
generation
and
has
confidence
and
has
speeded
fast
the
Vacuum
Tube.
Translator
has
been
made
in
Bell
Labs
in
1947
by
William
Shockey
J.
Bardeen
and
W.A
Brattain
and
used
by
the
public
in
out
heat
least
than
Vacuum
Tube.
Magnetic
tap
has
using
for
general.
Magnetic
Disk
has
been
used
for
more
store
data
and
fast.
3
1
Third
Generation
(1960-1975):
This
generation
computer
used
by
Integrate
Circuit
it
has
more
efficiency
and
confidence
than
last
generation.
One
Intergraded
Circuit
(/Cs)
has
more
electric
circuit
and
small
part
of
Silicon
this
time
is
called
"Chips".
This
operation
is
step
forward
with
ICs
technology
for
make
Microprocessor
Chip.
In
1960
They
used
ICs
for
make
CPU
and
in
1970
as
CUP
is
prepared
by
Intel
in
CPU
is
called
"First
Microprocessor
4004"
it
has
14
bit
data
bus
and
2300
transistor.
4
1
Fourth
Generation
(1975-to
now):
First
ICs
has
only
10-100
transistors
and
for
Medium
Scale
Integration
(MSI).
In
Large
Scale
Integration
(LSI)
in
1970
Very
Large
Scale
Integration
(VLSI)
that
it's
ICs
has
more
100000
transistors;
Intel
Company
is
a
producer
CPU
Microprocessor
8086
has
27000
transistors,
In
1993
Pentium
Processor
have
3.1
millions
transistors
it
came
computer
90
millions
per
second
(fast
than
1500
of
4004).
5
1
Fifth
Generation
(Jn
the
future):
However,
the
human
is
not
agree
to
begging
fifth
generation
technology,
they
sad
stating
use
computer
with.
Artificial
Intelligence
(This
AI
can
tell
about
capability
on
thinking
for
human's
problems
.
This
first
arm
isn't
official
that
could
think
in
1990.
However,
the
computer
is
still
developing
non-stop
from
one
generation
to
the
other
generation
.
All
programmers
are
trying
their
best
to
find
the
way
to
develop
the
program
to
meet
computer
user
easer
and
easer
from
day
to
day.
The
non-stop
developing
of
computer
system
or
software
requires
people
have
to
learn
more
and
more
about
computer.
Not
only
computer
system
that
has
been
developed
but
also
the
other
technologies
·
such
as
"Weapon,
Car,
Train,
Airplane,
Medicine,
Electronic
Product.
.
.
).
That
is
the
reason
why
all
people
around
the
world
have
to
study
more
and
more
non-stop
whole
their
lives
to
find
what
is
the
new
technology
or
new
idea
that
better
than
before
to
meet
the
requirement
of
the
local
or
world
career
.
Finally,
I
recommend
to
the
young
generation
to
try
to
study
more
and
more.
Don
't
think
that
I
have
enough
education
and
not
prostituting
to
study
more
.
I
strongly
hope
that
the
young
Khmer
generation
will
try
to
study
hard
for
their
own
self, for
their
family,
for
their
child,
and
our
nation.
1
Hw_jH
rlJl
:u
rwn
ru1rri
dt:
thlJ
H8U
.
I
,
'
I
'
.
..,
<Jr:H:
;
1
.·,.i:··
.
JAPAN'S
10-YEAR
BONDS
RISE
ON
FACTORY
OUPUT
DROP,
BOJ
OUTLOOK
By
Yoshiaki
Novara
\
April
29
(Bloomberg)
-
Japan's
10-year
bonds
rose
for
a
third
week
after
a
report
showed
industrial
Ł
fell
by
a
record
,
\dernonstrating
the
effect
of
last
month
'
s
deadly
earthquake
and
tsunami
ory.
the
,
Ł
nation'
economy
:
Ten-year
yields\reached
the
Lowest
Le
·
_j
on
speculation
evide!Jce
the
1
economy
i
weakening
will
rom
the
Bank
of
Japan
to
keep_interest
rates
near
zero
mainta'in@
r/
urc
1
s
to
s
ur
owth
..
Demand
for
bon
s
mcrease
as
e
bank
cut
its
gross
domestic
product
growth
forecast
for
the
year
ending
l'Vfarc112012
to0.6
percent
from
1.6
percent,yesterday.
"The
economic
data
_--were
really
supportive
of
bonds,"
saidJun
a..IDQ.!.iey
manager
.
filJOut
$16.6
bill1on
Asset
Management
Co
.
in
Tokyo.
"The
BOJ
is
likely
to
111aintain
Its
.
[Link]}etary
easin
for
a
lon
time."
he
yield
on
the
1.3
percent
bond
due
March
2021
fell
·
one
basis
point
to
1
.
2
the
lowest
since
March
24.
e
price
gained
{0.086
yen
to
100.881.
A
basis
point
is
::--o.O
1
percentage
point\fen-:Year
bond
fUfures
for-:tun
delivery
rose
.
0.30
to
140.05
this
week
at
the
Tokyd'
_J:>tock
Exchange
.
;£hh
140.08yester
ay,
the
.
highest
since
17
.
Japan's
._ylosed
for
a
public
o
1
ay
Japan's
factory
ou..!J?.ut
felldl5.3
percenijn
March
from
the
est
drop
since
data
began
in
1953,
and
household
spen
mg
sank
8.5
percent
from
a:
year
earlier,
emment
repots
showed
data
.
"I?ake
it
to
_
sell
sa!d
Hirakata
who
helps
to
manage
the
billion
at
M1tsu1
Sumitomo
K1am1ch1
Life
Insurance
Co
.
"
The
is
very
big,
and
I'd
like
to
see
more
data
to
the
whole
effect."
The
central
ban_k
[Link]
a
30
trilliori
($368
billion)
credit
a
10-trill
.
ion
yen
[Link]
fund,
while
keepmg
the
benchmark
mterest
rate
at
a
range
of
zero
tOli.1
percent
yesterday.
The
bSank
of
Japan
has
injected
a
record
amount
of
cash
in
the
money
market
and
doubled
its
fund,
while
.
-
keeping
the
benchmark
cas.b:Jo-
the
money
market
and
doubled
i_g>
progfj<lm
since
the
March
11
earthquake
that
has
killed
or
left
missing
a
lmost
26,000
peopTe.
Primemtmster
Na9fo
Ken
last
week
unveiled
a
4
trillion
yen
spending
package
for
relief
efforts
arid
indicated
that
tax
in
d
eases
may
be
needed
to
fund
.
stimulus.
Japan
'
s
sovereign-rating
outlook
was
cut
on
April
27
to
"negative"
by
&Poor's
which
said
the
nation
'
s
reconstruction
needs
will
likely
add
to
what's
already
the
world's
biggest
load.
SOME
COUNTRIES
IN
THE
WORLD
A
FGHANISTAN
ANDORRA
BAHAMAS
CAMBODIA
DENMARK
ECUADOR
GERMANY
HAITI
INDIA
IRELAND
KENYA
LAOS
·
NEPAL
OMAN
QATA
ALBAN
IE
ANGOLA
BAHRAIN
CAMEROON
EGYPT
FIJI
ISLANDS
FIJI
ISLANDS
.
GHANA
HONDURAS
INDONESIA
ISRAEL
KIRIBATI
LIBERIA
MALAYSIA
NETHERLANDS
PAKISTAN
ROMANIA
ALGERIA
ANGUILLA
BRAZIL
CANADA
EQUATORIAL
FINLAND
GREECE
HUNGARY
IRAN
ITALY
KOREA
LIBYA
JllEXICO
NEW
ZEALAND
PARAGUAY
RUSSSIA
AMERICA
SAMOA
ANTARCTICA
I
BRUNEI
DOMINICAN
DOMINICAN
ESTONIA
FRANCE
GREENLAND
ICELAND
IRAQ
f\t.q'R
'<l
:
e
eiisT
.
KUWAIT
LUZEMBOURG
MONGOLIA
NORWAY
PHi
tTP
PiNEs
...
..:
·:..
-
.
:
.
:
:
'..'
:
RWANDA
Taught
by:
Nhim
Bunthoeun
Microsoft
Word
2010
E-mail
:
nhim_bunthoeun7@[Link]
'
·
'
.
..

...
H
ilJ
BM
ru
u
M
:
u
nm
ru
1m5
t:
t
2
n
t
ti5J
H
nu
2
'l
n
L)
n
gfo'.
ALIGNMENT
USING
and
PRINT
PRIVIEW
COl\tiPUTER
COURSE
IN
2009
MICROSOFT
WORD
2003
.
>if.
March
18
1
h,
2009
NHIM
BUNTHOEUN
#
Vikroetka,
St
Boredom,
Sangbad
Chaktomok,
Khan
Dun
Penh,
Phnom
Penh,
Cambodia
Contact:
092
735
263
E-mail:
hem
bun
t
hoeun7
1'.Cl{
[Link]
TO
Human
Resources
and
Administration
Department
Monee
Co.
,
Ltd
#721,
Motiving
Blvd
,
Sandakan
Boeing
King
Kang
iii
.
Khan
Shankar
Mom
,
Phnom
Penh,
Cambodia
E-mail:
HRrucruitment@mfone
.
biz
Website:
mfone
.
com
.
kh
·
Tel
:
023
300
467
Apply
for
the
position
of
Engineer
Dear
Recruit
er
Please
accept
my
enclosed
resume
in
Engineer
application
which
was
advertised
in
Money
Co.,
Ltd
which
located
in
#721,
Motiving
Blvd,
Sangbad
Hoeing
King
Kang
iii,
Khan
Chama
Morn,
Phnom
Penh
City.
I
am
confident
that
my
education
and
my
experience
have
prepared
for
me
for
the
available
position
that
you
have
and
my
unique
ability
will
provide
me
with
main
contribution
your
objectives.
I
graduated
from
Cambodian
University
for
Specialties
with
a
bachelor
degree
in
Computer
Science.
As
you
see
in
my
resume,
I
had
studied
many
courses
of
English,
so
1
can
write
,
speak,
read
,
and
listen
.
fluen
t
ly
.
Meanwhile
,
I
have
completed
pedagogy
as
a
Senior
Technical
Training
Teacher
(Bachelor+
1)
from
National
Technical
Training
Institute
in
2008
and
I
have
successfully
completed
TESOL
(Teaching
English
to
Speaker
of
Other
Language)
as
an
English
Teacher
from
Newton
.
.
Thinly
School
in
2008.
My
experience
such
as:
in
2006-2007,
I
volunteered
in
IT
Department
at
Cambodian
university
for
Specialties
.
I
think
my
qualification
will
meet
your
requi
r
ement.
,
.
I
am
confidents
that
I
make
a
very
positive
contribution
to
your
company
and
I
forvvard
to
discussing
·
my
capabilities
in
detail.
I
am
available
for
a
personal
interview
at
convenienc
d
1
.
that
you
can
contact
me
by:
092
73
52
63.
Thank
you
for
your
consideration.
.
.
Sincerely
yours
,
Taught
by:
Nhim
Bunthoeun
-
..
\
Send
to
Human
Recotn-se
Department
in
Penh
Please
After
Receiving
This
·
Information
Quickly
Microsoft
Word
2010
E-mail:
nhim_bunthoeun7@[Link]

:-:
.
.
.
Hwf'tHtn
ruuru-i
:urun
ru1m
tls:rn
fittu'1m1u
ruJ
a
n
n
"
n
U
I
.
KINGDOM
OF
CAMBODIA
NATION
RELIGION
KING
Ministry
of
Labor
and
Vocational
Training
Sier:n
Reap
Provincial
Training
.
Center
g
£1
i:
.Ł-
}
:
..
Microsoft
Office
2011
Course
Start
Course:
18-July-2011
ADB
'
s
Fund
through
State
Ministry
Header
and
Footer
Symbol
Using
Kind
of
Courses
in
2008
0
Microsoft
Office
2003
);;-
Hospitality
-+
Poultry
Feeding
Program
OVegetable
Planting
Program
Location
to
train
..-Microsoft
Office
2003
is
trained
in
the
center
and
the
exam
will
be
held
in
the
center.
Ł
Hospitality
is
trained
in
the
center
to
be
a
hotel
employment
at
all
level
of
hotel
+-
Poultry
Feeding
Program
is
trained
in
the
field
where
farmer
feed
·
W
Vegetable
Planting
Program
is
training
in
the
field
where
farmer
feed
®Post-Hard
West
Program
is
trained
in
the
field
that
something
was
over
needed
*Please
Tick
0
if
you
want
but
Cross
if
you
reject
[8)
o-wfiat
Program
above
do
you
want
to
study?
0
Microsoft
Office
2003
(Microsoft
Word
&
Excel)
.
0
Hospitality
(Hotel
English,
F
-
ront
Office,
House
Keeping,
and
Restaurant)
0
Poultry
Feeding
Program
(Du
'
ck,
Chicken,
Royal
Duck,
Goose,
and
...
)
.
0
Vegetable
Planting
Program
(Bean,
Cabbage,
Carrot,
Water
lily,
Cucumber,
Potato,"
Tomato,
Chili
Paper,
Eggplants,
String
Bean,
Mushroom,
Garlic,
Watermelon,
Pineapple,
and
...
)
"1:5.
What
do
you
want
to
be
in
the
future?
0
Police
Man
or
Woman
(The
person
who
secure
social
security)
8
Engineer
(A
person
who
is
a
man
of
inside
in
Construction,
Electronic,
[Link],
or
.
..
)
@
Farmer
(someone
who
owns
or
manages
a
farm
or
someone
who
feed
cow,
buffalo,
sheep,
poultry,
fish,
pig,
planting
vegetable,
fruit
tree,
or
...
)
0
Non-Government
Organization
(a
group
such
as
a
club
or
business
that
has
formed
for
a
particular
purpose)
o-
Time
Schedule
(or
all
this
courses
in
2009
under
abroad
organization
(und
CD
Half
past
one
(PM)
[It
the
first
class
that
trains
students about
Microsoft
Word
and
Excel]
CO
Half
past
two
(PM)
[It
is
also
the
first
class
that
trains
students
about
Hotel]
CV
Half
past
three
(PM)
[It
Is
the
second
course
that
trains
students
about
Poultry
Feeding]
G
Half
past
five
(PM)
[It
is
the
third
course
that
trains
students
about
Post-Hard
West]
X
The
end
of
Microsoft
Office
Course
students
can:
A.
Change
Page
Setup
·
,
create
Header
and
Footer,
and
Show
any
tool
that
was
hided
A
Insert
Symbols
whatever
they
want
to
insert
to
their
text
box
and
find
or
change
word
,
A
Insert
Bullets
and
Numbering
and
Tab
stop
Taught
by:
Nhim
Bunthoeun
Academic
Year:
-2011
..!!!
.
....
Microsoft
Word
2010
E-mail:
nhim_bunthoeun7@[Link]

.
-
-,
.
..
.
-
.
:
-
-
----
Hi;LJH
rui
ruu
rui
:u
run
ru1i:n
ti
f:
t
2
n
t
fU]
HflU
a
'l
n
u
n
KINGDOM
OF
CAMB
.
ODIA
NATION
RELIGION
KING
Ministry
of
Labor
and
Vocation
Training
Siem
Reap
Provincial
Training
Center
;._;._;._;._,.I..,
,.I..,
,.I..,;._;._;._
,.I..,
,.I..,;._;._;._)..
t
A
Microsoft
Office
Word
and
Excel
2010
Under
Annual
ADB
Fund
in
201
l
Human
Resources
Development
<4!<4!<4!<4!<4!<4!o!Q!<4/<4!o!Q!<4/o!Q!o!Q!
.
Lesson
Overview
);>How
to
Save
Document
-
Click
on
File
=>
Choose
Save
or
Save
As
=>
Choose
Location
to
·
Save
=>
N
I,
aming
your
document=>
Click
on
Save
button
,
);>
How
to
Open
Document
·
.
I
-
Click
on
File
Menu=>
Click
on
Open=>
Choose
Path
that
your
file
location=>
Click
on
Your
file
name
=>
Click
on
Open
button
\
);>
How
to
set
Page
Setup
·
·
.
-
Click
on
File
Menu=>
Click
on
Page
Setup=>
Click
on
Paper
tab
to
choose
kind
of
paper
(A3,
A4,
Letter.
..
)
and
then
click
on
Margins
tab
to
set
margin
of
the
paper
and
then
choose
Portrait
or
Landscape
paper.
After
format
it
already,
please
click
on
button
OK
to
finish.
);>
How
to
copv
-
Copy
Word=>
Copy
Word=>
Copy
Word=>
Copy
Word=>
Copy
Wor[Link];>
Copy
Word
-
nhim
bunthoeun7@.[Link]
-
nhim
bunthoeun7({.l!vahoci
.
corn
-
nhim
bunthoeun7@.[Link]
-
Microsoft
Office
word
and
Excel
2010
start
from
18-July-2011
to
30-September-2011
-
Microsoft
Office
word
and
Excel
2010
start
from
18-July-2011
to
30-September-2011
-
Microsoft
Office
word
and
Excel
2010
start
from
l
8-July-2011
to
30-September-2011
);>How
to
Print
Preview
-
Click
on
File
Menu=>
Click
on
Print
Pre,
.
:
.
.,
,
.
);>
How
to
Undo
or
Redo
-
on
Edit
Menu
=>
Click
on
Undo
Typing
to
Backward
or
Click
on
Redo
to
Forward
);>How
to
Show
or
Hide
toolbar
-
Click
on
View
Menu=>
Click
on
Toolbar
and
then
Tick
or
Un-tick
to
on
(Formatting,
Standard,
or
Drawing
tool
bar)
to
show
or
hide
tool
bar.
*
Cancer
Overview
Cancer,
also
called
malignancy,
is
characterized
by
an
abnormal
growth
of
cells
.
There
are
more
than
100
types
of
cancer,
including
breast
cancer,
skin
cancer,
lung
cancer,
colon
cancer,
prostate
cancer,
and
lymphoma.
Cancer
symptoms
vary
widely
based
on
the
type
of
cancer.
Cancer
treatment
includes
chemotherapy,
radiation,
and
surgery.
If
you're
considering
complementary
treatments
for
cancer,
discuss
this
with
your
doctor
as
they
may
interact
with
other
cancer
treatment.
What
should
I
talk
about
with
healthcare
provider?
Patients
on
antidepressants
and
their
families
or
caregivers
should
watch
for
new
or
worsening
depression
symptoms,
unusual
changes
in
behavior,
·
thoughts
of
suicide,
anxiety,
agitation,
panic
attacks,
·
difficulty
sleeping,
irritability,
hostility,
aggressiveness,
impulsivity,
restlessness,
or
extreme
hyperactivity.
Call
your
healthcare
provider
right
away
if
you
have
thoughts
of
suicide
or
if
any
of
these
symptoms
are
severe
or
occur
suddenly.
Be
especially
observant
within
the
first
few
months
of
antidepressant
treatment
or
whenever
there
is
a
change
.
in
dose.
·
Taught
by:
Nhim
Bunthoeun
Microsoft
Word
2010
E-mail:
nhim_bunthoeun7@[Link]
-:
-'-
Hd
1tHlJl
ruu
rui
u
run
ru1t:h
flt:
rn
cHtU"
Hn
u
NJ
a
n
n
i..o
n
U
I
Ministry
of
Education
and
Spots
UK's
Cambridge
University
KINGDOM
OF
CAMBODIA
NATION
RELIGION
KING
0
,.,
c;rrn:
Annual's
TOEFL
Testing
Program
Under
United
Kingdom
Supervise
II
HOW
TO
INSERT
CLIP
ART
II
8
First
Stage
of
Testing
Perhaps
it
was
his
own
lack
of
adequate
schooling
that
inspired
Horac
_
e
Mann
to
work
so
hard
for
he
accomplished_
While
he
was
_
brother
died,
and
he
became
.,.;
family
.
Like
most
of
the
".-
"'''i'"
.
school
only
two
or
three
.
.
,.!
of
several
teachers,
he
.
-
·
"
the
Massachusetts
bar,
Pa
i
i
Taught
by:
Nhim
Bunthoeun
Microsoft
Word
2010
E-mail:
nhim_bunthoeun7@[Link]

:
,
--
HCJJHM
[Link]
M
'[Link]
ru1m
di:
t2
ti
ttiJ
1
tJflU
CUJ
a
n
n
1.3
n
U
I
0
...,
.
:
g
:'
6
<
WORD
ART
AND
SHAPE
DRAWING
.
..
...
·:..
.··
:
.
.
.
-
-
.
.
·
..,,..
.
.
.:'
.:
·
d
.....
,
..
·
o
"'"
·.
:
·
,,
'
11
l
.
.
x
i
.
\
f
'
C
"
.
.
..
1
;
·
\
\
.
;
·
·1.
__
1
.
.....
Ł
.;.
.E
.
....
e\
11

1
!
.
l4J.i
"
'
+i:
'
..
·
·
.
.
-
M"
'"'f
"
=
«
>!.
'*;
·:1
:;
;:
Ł1
1
"
l'
Jf
l
?f
lt
··
',.,,
·
.
i
·
._
.,
..
,.-.;--
!
.
;,_f
.
.
.
.
'
.
.,
.
1dl11
.
t
1
i
·
y
=
·;
]
r
·rra·,
»
-
,-;
·
tf}
l
..
..
:·j
Taught
by:
Nhim
Bunthoeun
Microsoft
Word
2010
E-mail:
nhim_bunthoeun
,
@[Link]
I
I

t:rt:i
rt:r
n..n
ruu
n.n:
u
run
ru?m
JS
i:
t
2
ft
t
ftJ.,
t:rn
u
ru.J
a
n
n
<.>·
n
U
I
J11.i1tistry
of
La6or
ana
Vocationa[
tfraining
S
ei
m
<R.§ap
<Provincia[<Training
Center
KINGDOM
OF
CAMllODtA
NAUON
[Link]
KlNG
(
Wore[
}lrt,
jluto
Snape
ancf
Pont
l
PROJECT
OF
THE
GOVERNMENT
g
\}
T
government
<
p[anning
<Program
:Microsoft
wonrf
1
na
2
003
*******
*****
.
.
.
Vocational
Training
For
Employment
General
This
project
will
contribute
to
the
alleviation
of
poverty
in
Cambodia,
by
facilitating
employment
and
income
generation
through
the
provision
of
vocational
skills
to
unemployed
and
underemployed
groups.
The
project
focuses
its
attention
on
vulnerable
groups
such
as
women,
particularly
those
providing
the
main
source
of
:
income
for
their
households,
displaced
persons
and
returnees
.
Ł
...
,.i.·::.·
.
:.:::-·-
..
...............
A
program
Soft
short-cycle
demand
based
vocational
training
course
will
be
delivered
through
a
flexible
network
of
two
Provincial
Training
Center
(PTCs),
six
Outreach
Training
Units
(OTUs)
and
a
National
Training
Secretarial
(NTS).
The
·
planning
and.
co-ordination
of
the
project
will
be
through
arranged
of
different
modes
including
existing
NGOs.
r.ŁŁ·-----!·.
I
nm
studvlna
CDlllPHUICDir
II
Ł
.
.
Ł
11
Aut-0Shape
I
..
_______
#.
M-
f
.
t
.
o.t£;···!·
·
w
d
2003
---- ----
1
cro
so
·
c
e
·
or
.
4*6
Photos
Taught
by
:
Nhim
Bunthoeun
Siem
Reap
Province
0
0
0
-
.
Microsoft
Word
2010
E-mail:
nhim_bunthoeun7@[Link]

Br::in:HlfHUUM
:u
run
t2ri
tfl5
1
m1u
iUJ
a
n
n
l.-'
n
U
I
j_
0
.,,
·.·:
-.
·,·
··:
ca
ri
l'
Ł
-:,,,
8
,
.
..
"'·
.
J_
MINISTRY
OF
LABOR
AND
VOCATIONAL
TRAINING
SIEM
REAP
PROVINCIAL
TRAINING
CENTER
KINGDOM
OF
CAMBODIA
NATION
RELIGION
KING
..
<¢>-
<¢>-
<¢>-
<¢>-
<¢>-
<¢>-
<¢>-
<¢>-
<¢>-
<¢>-
<¢>-
<¢>-
<¢>-
<¢>-
L
I.)
Tab
Set:
SIZE
A:
DURATION
1.1
1.2
1.3
1.4
1.5
Ll!18SON
PLAN
OF
GENERAL
STUDEN'IS
JN
BASIC
OOMPUfKR
COURSE
INYEAR:
·
20011-2012
.....
L
.:j
j_
SIZE
B:
SONG
NQ
SONG
To
nigh
I
miss
you
1
I
miss
you
like
crazy
2
Dream
about
you
3
Super
woman
4
The
prison
of
love
My
heart
wi
11
go
on
To!Jight
I
celebrate
my
love
Mouse
_
love
rice
Because
you
love
me
5
_
If
tomorrow
never
come
INDEX
ffl
.Affl
illr
1
1C
'
\
(
v-
1.
·,;
.
:
1
DUN
271-288
.
J
J
Select
_j
DURATION
1.1
-
1.2
l.3
_
1.4
1.5
312
Installing
DUS,
J22-325
Text
file
defined,
37
.
I
·
Serial
port,
1
72
Described,
226
SET
internal
command,
159:
160
·
-
l
-
T
Tape
backup
device,
and
modem
13
Target
defined,
and
goal
in
the
future
204
Terminating
EDLIN,
275
[Link],
71-73
Text
Creating
a
file
with
EDLIN,
273
TIME
internal
command,
109-11O,:B15
Tracks
of
diskettes,
63-64
I
Transferring
text
between
files,
286
1
-287
Video
adapters,
225
.
,
\_
w
Wide
listing
defined,
38
Wildcard
character,
73-
74
Work
disk
defined,
26
"1
My
good
students
.
.,
-:;.,l
-.
"'
_,.,
......
r--:1.
I
,v.
:'Y't
-
u
J
1
:-
1
.rn
......
...
Taught
by:
Nhim
Bunthoeun
Microsoft
Word
2010
E-mail:
nhim_bunthoeun7@[Link]

::
::
l:HWi:[Link]
ru
u
rul
:
u
[Link]
ru
1
dl
d
f
:
t2
ri
t
nJ
'l
l:Hl
u
fW
a
n
n
u
n
U
I
l-
Ministry
of
Labor
and
Vocational
Training
Faculty
of
Business
and
Administration
L
t-L
A.
}lcatfemic
'Year.
2009
J
+TOEFL
PAGE
-
Irregular
Past
Form
1-2
-
Logical
Conclusion
3-4
-
Knowledge
and
Ability
5
-
Past
Custom
5
-
Advisability
(Had
Better)
6
-
Preference
(Would Rather
That)
7-8
+SENTENCE
4
.
PAGE
-
Determiner
-
Pre-deter
B.
IRREGULAR
PAST
F
Verb
Word
Be
Beat
Become
Begin
Bite
Bl0w
_
I_
j_
g
\
9
.
,_.;....::
THE
UNITED
KINGDOM
NATION
RELIGlON
KING
LL
L
l
__
+
PART
OF
SPEECH
-Notm
-
Definition
-.-.
-
-
Classification
__.,.
.
PAGE
-
Formation
of
Abstract
Noun
1
2
3-4
s
5
-
Plural
of
Noun
.
-
Gender
.
-
ADJECTIVE
nt
to
study
faU:Se
it
is
the
gram
rt'
r
learning,
know
some
of
-
ITTaf
.
;,,
·
)illi\:
9
".
Good
luck!
1
2
3-4
5-8
.
KINDS
OF
WELCOME
Say:
Hello,
How
are
you?
:
TIME
OF
USING
:
Using
general
PRACTICE
-
Please
learn
by
hard
Good
morning,
How
everything?
Good
Afternoon,
What
can
I
help
you?
Good
evening,
What
wrong
with
you?
,·.
>:
;;,
.,,
.
,.
.
"
,
..
·
..
0:
·
..
··'
:
Using
in
the
Morning
:
Using
in
lhe
Afternoon
:
Using
iŁ1
11
'
e
Evening
d
i
Łt
.
.
.
Ii
'
..
_
..
,,
.'
"
;
"
<
'
"
;
"'"
-
·
Please
study
more
and
more
·
-
After
lunch
is
OK
··
-
From
5:00
PM
to
12
PM
Taught
by:
Nhim
Bunthoeun
Microsoft
Word
2010
E-mail:
nhim
-
.

-
-
::
L'Uttll
t2£1
tN'lm1u
ruJ
a
n
n
'-'
n
U
0
,)
gm:
·.
JO
*
1.
2.
_,
.J.
4.
5.
6
.
7.
8
.
9.
10.
*
1.
2.
_,
.J.
4
.
5.
6.
I
Microsoft
Office
Word
2003
·
CONTENTS
Definition
.
........
..
......
...
...........................................
,
.
........
.
.............
......
.
....
.
..
.................
.
.........
.
......
......
...
1
How
to
inter
to
Microsoft
Office
Word
2003
.
...
..
...
...
.
.......
......................
............
....
00
.
..
00
...
00
......
oo
...
oo
......
2
-
.
How
to
Exit
Microsoft
Office
Word
2003
....
00
..............
00
...
..
..
00
...............................
00
................
0000
.......
..
2
Save,
Save
As,
and
Open
document
.
..
..
...
...
...
...........
...
..
...
.
00
.............................
:
.....................................
3
Page
Setup
....
.....
.....
..
.....
..........
.
.........
...
00
..
...
.
...
......
.....
.
.
..................
...
..
.
..
..
...............................................
4
Text
Alignment
............................
:
.....
..
.....................................
.....
..........
...
...
.......
......
.
....
...
'.
...
00
Ł
Ł
ŁŁ
0000
Ł
ŁŁ
Ł
ŁŁ
4
Header
and
Footer
......
......
.....
.
....
.
...
..
.
...
....
.......
..
......
.
.
00
..
..
00
...........................
:
ŁŁŁŁŁŁŁ
:··
··
..
···oo
...
oo
..
.....
.
........
oo.5
Border/
Page
Border/
Shading
............................
.
....
.
..........................
..
...
......
.
.
.
-.
...
..
..
.
.....
:
.
.
..
...
00
.:
...........
.
5
Insert
Symbol
....
..
..
.
oo
.....................................
.
.....
00
......
........
.
...................................................................
6
Font
Formatting
...
oo
.
..
.
.
'.
·
...
.
.
...
.
.
.
..........
.........
.
..
..
....
00
.....
....
....
................
.
..
.....
._
............................
.
00
.....
.
:
........
.
Microsoft
Office
Excel
2003
Definition
.
....
.................................................
...
..
.
..
...
..........
:
.......
.
.
..
.
.
...
..
..
.
.............................................
19
How
to
open
Microsoft
Excel
..
........
.
.......
....
.......
00
......
...
.....
....
...
.........
.
.
......
............
.
..........
...
._
ŁŁŁŁ
oo
.........
20
Cell
understanding
.........
.
..
..
........
.
...
....
.
.................
.
......
..
.....
...............
..
..
.
......
.
.......................................
20
Delete
Cells,
Rows,
or
Columns
.
.
.
...............
.
.
.
...
.
....
..
..
..
.
..
....
....
.
..
....
.
....
..
...............
.
..
.
...
....
......
.
..
....
.........
21
Hide
Rows,
Columns,
and
Worksheet
··
··
····
··
··
·
········
··
····
······
··
·····
·
······
···
·
··
··············
··
···
:
·······
......
..
..........
22
Inse11
Rows,
Columns,
and
Worksheet
............
..
........
.
...............
...
....
......
....
......
.
..
...
..
........
..
...
.....
.........
23
CONTENTS
Tools
Envelopes
and
Labels
View
Header
and
Footer
Command
....
..
..
..
.
.........
...
..
...
....
.
...
:
....
14
Tools
Grammar
command
.
..
...
.
....
..
...
...
..
.
.
.
.
61
Tools
Grammar
command
.
.
.....................
..
73
Tools
Mail
Merge
command
..
.
......
.......
.
....
78
Tools
Menu
......
......................................
.
152
Command
..
..
..
.
..
.
..
...........
....
...
....
.
.
........
.
Tools
Spelling
command
.....
...
.................
111
Tools
Thesaurus
command
.
.............
..
.
....
124
Top
Margin
...
.
....
.........
.............................
130
Traub
leshooting
.
..
.
.
.
..
.
..
.
........
.
................
...
..
.
..
Display
.......
..
...
.............
.............
.
....
138
Document
Saves
...............
.
.......
.
..
..
.
140
Phnom
Penh,
25
December
,
2009
Check
by
1
!
Director
of
Siem
Reap
Provincial
Training
Center
Signature
Phang
Puty
Command
................................................
71
Viewing
field
codes
..........................................
47
View
Master
Document·command
.
.......
:
..
..
......
34
View
Menu
..
....
.
......
.
.....
...
.......
..
....
...
..
....
00
.......
150
View
Normal
command
.....
.................
.
.........
..
..
I
0
View
Page
Layout
c
·
ommand
...
..
.
................
...
...
34
View
Toolbars
command
.........................
.....
..
125
w
Windows
...........
..
..
..
...
.
.....
..
.....
...........
'.
....
....
.
...
127
............
..........
......
....
.
........
See
also
orphans
Wiidcard
characters
.........
...
...............
.
.....
....
...
113
Seim
Reap,
25
May,
2009
Class
patron
Signature
Nhim
Bunthoeun
Taught
by:
Nhim
Bunthoeun
Microsoft
Word
2010
E-mail:
nhim_bunthoeun7@[Link]

·.
-II
HtifH
M
ruu
M
[Link]
ru1m
8s:
t2fi
n'.tJ
a
n
n
l3
n
U
I
SEMESTER
l
'
s
EXAMINATION
COMPUTER
COURSE
IN
2011
Student
Name
Sex
Date
of
Birth
Major
Class
ID
Table
ID
:
......
.
.
...
./
.
:
......
.
..
./
·
·
··
·
··
·
·
····
·
··
"!)
'\
Score
Accuracy
Percentage
:
Lecturer
*
Please
tick
0
the
following
answers
or
Cross
!8J
if
is
false
·
1
.
·
Computer
Hardware
0
:
Monitor
0
:Table
0
:
Classroom
0
:
Mouse
D
:
System
Unit
D
:
Book
D
:
Chair
D
:
Calendar
D
:
Copier
D
:
Printer
D
:
Monitor
LCD
D
:
Mouse
Mat
2.
How
to
save
document
at
the
first
time
D:
Click
on
Format=>
Click
on
Tab
0
:
Click
on
Edit=
>
Click
on
Undo
D:
Click
on
File=>
Click
on
Save
D
0
:
Click
on
Insert=>
Click
on
Header
and
footer
D
,.,
:
Click
on
File=>
Click
on
Sa
lv
e
As
:
Click
on
Format=>
Click
orl
Font
.)
.
How
to
change
Font
size
D:
Click
on
Insert=>
Picture=>
Clip
Art
D:
Click
on
Format=>
Border
and
Shading
D
:
Click
on
Click
on
File=>
New
*
Please
Translate
from
English
.to
Khmer
D:
Click
on
File=>
Page
Set
up
0
.
:
Click
on
Format=>
Drop
Cap
D
:
Click
on
Table=>
Formula
1.
Do
you
the
reason
why
I
try
my
best
to
teach
you
from
my
hard?
2.
I
hope
you
will
succes
.
s
your
goal
3.
Do
you
want
to
strengthen
your
ability
to
speak
English
well?
4
.
Grammar
kills
your
speaking
so
you
feel
shy
when
you
speak
English
Speaking
English
Fluently
The
four
rules
of
learning
to
speak
English
w
e'.'
you
will
see
the
above
paragraph
·
that
l
have
prepared
for
you
all
in
Reap
Provincial
Training
center
under
the
Hun
Sen
'
s
budget.
On
be
haft
of
government
official
l
will
try
my
·
best
to
teach
you
all,
so
all
the
students
in
computer
class
have
to
study
harder
and
harder
to
archive
your
personal
goal,
on
the
other
hand
you
all
are
my
power
.
.
r
hope
my
entire
students
are
punctual
for
class
every
day
and
come
to
study
regularly
non-
absent.
Do
you
know
the
reason
why
I
don't
want
you
to
be
absent?
Taught
by:
Nhim
Bunthoeun
Microsoft
Word
2010
E-mail:
nhim_1?l1nthoeun7
@
[Link]

L:
5
utH11nobn.N
Y1Bw
Ql
LY:
m
rn
tfu
Ql.H[BEHW(l-1
hi
t:J
m
Ei
u:iqu
:
srn
Llln1mfi
s
wm11Hsu;:i1s1J\flntJ1ru
mru
p8ru
r...m
w.w
oo
G
p
0
I
II
0
f::a
fQ
('"
!J)l
p
lD
[Link]
U:!SQ
wru
p
5
ru
s
lD
ufnH!D
iii
LHStR!J(IJ
!J
si.P!:!millsu:in1
mhJsh
:wu1!.J
·
.
nof;
punoJB
J84l0
8ljl
WOJJ
P8J!WP
_:
eq
ll!M
nof;
'pooB
6LI!4
·
lewos
op
nof;
JI
·pey
JO
I
'
f...Je11e
pe
nof;
lB4l
BLI!4l8Wos
lB4l
PU!W
Jnof...
LI!
>1LI!4l
7
A
r
oi
e11e4
os
'
f...iepos
LI!
e1doedJI
v..J
.
JOJ
\
lLIBlJOdW!
/i.Je11
S!
Al!IBJO
l:1
n
,,
l:1
L
Qffil
flJ
Dl!J.
LJ;:lR
QflJ
LP
8
!J
!LS\l
!J1B
Qf\J
f::a
I
'Q
:;-
Q
b
1-fll
C
qB:\lrB!BflJ
S
S
[031
q
[iJ11
nw11
m
unf\J
q
rung
l
µ:i
l
ru
i
!;;!
s
LB
'"1
"11
.
n
nn
l!t
!=l
uu
s1
ru
ll
tm
u:i
:
2
w
LJ
w
flJ
2
!J.
2
!J.
u
l1
l
cs
n
,:;;>
o
-o<or
:
D
1
L
Q
P
C
S
fl
8
DJ
DB
lflJ
U1
Q
S
Q
P
Q
Q
S
'
...
Qj
Q!U:!
911-£>
1
:
S
l
Q
lfUl
[B
g1
I
I
U
U
U
¥
LQ
w
8
!:!
Q!dffi
m
w1:
mru
wun:
lfU
n
s
ltl
ru
Jij
BI'PBru
m
.
lfUl
D![Link]
![Link]!:!11
C"
p
0
'
2
!:!
2
!11
ru
!:[Link]
flJ
u;:i
cs
fl
q
h!
lfU
l
D
o
-
C"
-
._
<"o
I
S
!:J
flJ
l
f
n
flJ
flJ
S
5
![Link]
n
LSlJ
l
UJ
Q
H
flHlfU
n
..
C"
Rfu
D.-11
ql89unQrn
ltlru
p
n
n
I
n
JJJ)ru
pru
!;!
LP
!11
S
lf!TU
b
flJ
p
-
:J
l
l
¥
U!
-
ill
rnflliJ-G
-
0
:B
LY11
Q
l8
D
p
LPl8
RDJl
IJ)l
LS\1LPD6
w
1Lfu
nlfu
ll
ms
p
w
1qfu1
qn11
r
fl:>
o
<"
r
q
l1
s
LD
nu
B
(ru
l
11
21
:
s
2
LP
l
ru
LLfu
n
:[Link]µ:ll
GGOQ
tJrobµ:i1
._.,
'
p
&.
f;;;;J
o
·6u,oueuu
iqep
pLIB
BupuBLI!!
f...i!nbe
'BU!OUBU!!
JO
sedf...l
O!SBq
OMl
sesn
UO!lBJOdJOO
\I
"OLijOLIBU!J
SB
UMOU>j
S!
rel!dBO
S!4l
Bup!nboe
!O
e4.i
·
sseu,snq-,_/
Sl!
puedxa
pue
'aieJedo
'dn
lJBlS
l{J
oi
JepJo
LI!
JBl!deo
spaau
UO
!
lBJOdJoo
d\f8
dOCIO
puB
NV\Jnl08
0
'g
'§;>o'{;>o'{;>o
'{;>o'{;>o'{;>o
Ł
.
.
-.
:

I
I
WO
'
YOOljtlA
@
Lungo4
l
unq-W!4U
:
!!tlW-3
0
lOZ:
plOM.
lJOSOl:}!J/\l
n
n
IL
Yl
Y
ISDJ
lfUl
DJS
'
p
0
s
[Link]
5
8l
QPJ!1:;!W!
l!J
!1
IJ1J
)
1IJ5
nt
s
s
[Link]
8
5
D
lH0'
HQ
lfa
!J(rt.1
U!d[\l
B!J:
h
ru
lj
l
Q
rn
Q
y
L
Al
a1qB8
4LI8d
WOU4d
'.1aw4)i
Li!W08
'5upaau,5u3
u-eqq4nlAJ
'LI!4:-JWB8
'18l!qOlAJ
n
n
n
/1
P
\J
U
.f1
,....
I
8VllO
803
!:1!Sf:!LNfUWUDBWµ:llLJY01BY:Dj..t:il
s
s
QQl,;8
!J[ru
§
Q
f1J
LR£f
S!0W
DQDµ:ll
W1£1J
B!r:u
upQ1
LP
C"'-
,....
.q
C"'-
u
!JlYDQL.8
w
lJj
P!YBYDJ
Bl
wmnw
tJ:l
p
P
pg
o
o
o
n
'
u
t.,
"'
n
Ql2
!f\J
SB
s
UJ
s
nru
wun:
lfUD!:HYDl!El
I'>
£l
UJU.H
B
flJ
SS
ru
B
8
S
[Link]
(ldd)
:
Sl
H
0
'V
-
v
.
l:J
l
rt
I
BLY
0
C"
,:a
.
c:
.
-
.
0
t.B
n
L
.
..1aiua8
Bu!ure.1J.
1euO!lB:-:>of\
'
'
n

""'--
1
Ł
n
PUSl
OGG
8fUl!!JY!SHBWWt:BNY:IJ!
.
-
'V
PUB
IBO!U4881
d!4SPL!8!.l.:J
B!pOqWB8
I
N
51
YDl
n
ml.1
ru
LJJ1.1
n:
[Link]!!
s
t..N
Un
lW
n
l8!AOS..
tJ,:l
:
UTU
1
!J
lJ;:!
1J
1
k!
l
S
lD
S
!J1
ru
l
'
<"
"
f\:J
£'\!
nr,
I
I
n
M
:BruY:u
:si;iLPt
YQtfu
l3
l!JU1N
W
IJl
Qlf,TI
B
8
.
I
ru51w81nruLJJ1Jn:[Link]!B
U
M
U
1
w
s
LRru
c
nt,tn
nLP:
ru
UJU
n
\;!I
L
k![U
YD
I
u
,......
n
u
q
u
:
lfUDtlJBk!SS
ru
p
s
lD
N
Bl
wrnnru
UJUD
,.,...
'
I
srut!JHQS
r:;
E
lfU!1JD21J
wn
-
-

,,.
.
0
C"
-
U
b
n
l::t
I
:u-un
UJ
UU!J
a
Ł
a
r?
n
tPU
P
f'H
DSDQU1J1J
LPDrl
I
('-
,,a
'V
BHEl
WtQ[n1
s
LD
:
Bruh!:
u1
[B
g
10'
LD1
o1
lS
ln
s
1'n
ti
ru
R
:
m
m
§
It
I
M
<?
U
U
!!:
81!JDlnru
UJUn:
uun
ru
UUB
I
I
n
M
qu1i:.:m1BUJ
L:RDJY:U
f\J81
rn
R
p>
(lJ
p>
G
ill
u
y
fl
81
(lJ
B
1
m
UJ11
a
<'
"
I
w81nru
LJJ1.1n:
Lfu
nru
Lfu
BIT!B
r:u
ri
9n1£i1
L
:LlfU1h
p>(IJp>G
l£r!Jl
.
It
0
('"
rum
sov
n
s
ru
.Rru
8
5
s
[Link]
(iuauodwo8
"
......
13Al)

n
"'-
S
LJ;:!fUBW
u:l
PQU1Y
a
a
n
""
2
rs:!:!
f1JolY£l3DrulfUB
:
LlfUlh!JlfU
LfuBfPB
LJ;J!JlS
L.Y1:
SlS
tStJ
II
C"
Ł
C"
I
ruLJJ1.1n:iluri!tt
sp
pt;p>G
p
mf!
![Link]!J1
(ldd)
tJ,:ll,fl!d!J-Dl:lJTl.11
....._
I
I
n
M
,.--
I
I
n
.q
I
'\..)
.ri
LPWt
,,
8f\.l>ld
..
:BDJY:L.1
Nol
SLRD
:BDJY:l.1
f\JolYDlDLnLHllf'JLJo
........
cS?ats'J
.._,
t
u
n
u
L,
2
r;\:!
nu
B
[ru
l
!J
31
:
s
LP
t
ru
w-u
n
:
uu
n
ru
uu
B
!
PB
:
-
.

.-
L
D
UEI
G
0
y
U1J1
h!Y1hDJ
h!
Lill
D
Q
RD
ti[\
DJ
1-
1
fO
0
0
I
p;;t
"
(
,_.
)
/\JI
t>
:
ISrul
S
8Rl0J
IQ
"
GO
t>
r>
,
.
Ł
.....
GOG\L.£t
.............
81
........
eip1···
...
...
.......
0
<"
p;;t
c;
t-'...I

L:
ill11
S
Hffi
Lt!
l!
L'.l
Rtfu
flJ
Rill
LS!
W
lJ
LS!
W
LH
0
::>
'O
.:>
D
Q1
LtlY,
U3
[Link]
QLnl
m
LHl
SHUhll
wru1tns
L5ru
.Q
m
LJ!lffi
,
n
·
.
I
l
L
!
[Link]
!t1
q
s
m
w
IJ
LD
w
LH
1J
fu
n
uu
Rill
s
ill1
n
!t1
ti
f
R
ru
:
U1J
!d
ru
s
LB
3
LP
q
LH:
HR
fu
3
.
'Q
,:>
'O?
·
pop
I
I
I
'Q
0
0
I
·
u
.
i3
I
.
.
.......
.
..............
...
.......
....
..............
..
.....
Qh!1/Y
31··
·
·····
·
..
·······
·····
····
··
····
·
·:·······
·
·····
·
··
..
·
··
··
··LfU8/h!flJ1
"
.
.
u'
n
l..
f?.l=ln
.
·
Ł
·
·
·
Ł
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
tA
1-0ru1
m
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
·
······Ru·····
···
8
R
!::!1
·
·
·
·
·
·
·
·
·
·
B
ru
l
:
p
s
!
n
D
n
1
c;:!
l
ru
1
Al
I
0
'Q
r::J
·
t'""-'
0
r--u
I
·
b
n
.
...
..
....
...............
.
.........
..
....
..
...........
!D!8R
..........
r
..
·······r
...........
JJU1Jlh!L£f8l:..il··········
..
····ylill0J
ro
oa
cc;
-
.
.
.
I
..........
f:i!Jl
....
...
..
..
....
..
.
....
....
....
..................
..
:
UTulffiRLP
U1W
L'.l
LHU1W
LHDQltiD!t1N
s
LD
3
QLS
:::>
-
·
:;>
-
r-
a
l,
"r
....
rut
QL.8
YSRh!RUJ
IQ
u
'
e
1212
q
c..'1
Ł
0
""'
-
··--·
-·-
-
Ł·
-
-
-
!.,.
I
r-
"'
b
l
,_.
U
............................
S!!1DD!D!8R
(flJ!D
D
DLruO)L.£t
·
·
..
·
..
:mLH
..................................
:LSrulffilB
I
.
I
0
bn
I
...--
·
f\:J
b
I
I
.
.
.
.
.........
.
.
...
.....
...
..
S!DDD!D!8R
(ru!D
n
[Link])l£f""""""ffilH"""""""
"."
"""""""
"""""""
"
""
"
''
":LSrul!JIJ!:=!
I
Ł
I
0
·
.......
.
........
·
···
Q
81
...
..
.
-
.
-
.
-
:.
-
.......
.
.
.
81h!ru1
·······
·····
·
......
..
.
....
ii
wru1m
..........
·
··
·
··
..
·
·
·
·
···
·
..
RlJ
("'
I
0
.
'Q
·
I
R,
t?
'\J
I
·
····gru1
.
z
p
§fnoni-s
..
.
.
.......
s8
r:u
LP
lj
ws
UlJ"'Ł······
·····
·
·
···························
·
····
s
!DDD!D!8
R
J
.
Ł
I
I
.
b
'1
.......
("'I...
"-
..
.....
r
..
·
1
T""'"'"
Y
LfU1
h!
L.£t
........
.
JJ
Lill
f\J
··········
o
!Jl
..
.
..............................
.
.........
:
IS1U18
QLS/5
LD
8
I
fQ
ao
....
·
a
a
I
.
.
l:.
-.:
.
J28C!:6C!:6
--
g1f
t.srnli1J
gl$1
...

:
Hl::liHM
rliUM
ru1d1
tlr:rnfi
tN'lm1u
nu
:;a
n
nu
nu
gf1r:1s
I
RSASJa·
uii1.1;'i»j
usmJ
mH
9
\1131f58
d
smt\58
9
Fi.
.ij_'[Link]!Il
Un
Save
As?
0
ol
-Gtruw:
Ł
Click
on
File
Menu
Ł
Click
on
Save
As
·
Ł
Choose
location
·
to
Save
Ł
Type
your
document's
name
Ł
Click
on
Save
Button
2.
GruUJlurlnu)uwifi28nnHTn?
i)
"'
--
-8
truw:
Ł
Click
on
Insert
Menu
Ł
Click
on
Symbol
Ł
Choose
symbol
as
you
want
Ł
Click
on
Insert
Button
fi
.
gruUJlUrtnujutubtun
Column?
-t3truw:
Click
on
Format
Menu
Click
on
Columns
-r
$
Choose
number
of
columns
''
*"
Click
on
OK
Button
tiJ.
tTI
Hardware
computer
tfl
SH
2:?
.
d
CJ
.
""
-Gtruw:
·:·
Monitor
Ł!Ł
Keyboard
·:·
Mouse
Ł!Ł
System
Unit
Ł!Ł
Speaker
·
Ł!Ł
Scanner
Ł!Ł
Printer
Ł
Ql-d
o
'
I
b.
lJ
rliUJl
U
rl
H3
n
'1..fHi
Page
Setup?
0
""
-Gtruw:
1.
Click
on
File
menu
2.
Click
on
Page
Setup
3.
Click
on
Margins
tab
4.
Set
margin
(top,
buttoi:i,
.
left
and
right)
5.
Click
on
Portrait
or
.
Landscape
6.
Click
on
OK
button
G
.
rnn\5nflffHi.flH6mfl.Hf1Sthns820?
U
CV
-CT
tru
W
:rn
f
t'iJ
fiJlHb
Ntfl
S
u
ft
:
a)
Listening
b)
Speaking
c)
Writing
d)
Reading
l)
There
are
2
kills
in
Computer
Science
A)
Programming
1)
Microsoft
Access
2)
Programming
in
CIC++
3)
Web
Programming
4)
Visual
Basic
Programming
5)
Oracle
Programming
6)
Java
Programming
B)
Network
·
1)
Peer
to
Peer
network
2)
Workgroup
3)
Domain
4)
Internet
II)
There
2
skills
in
Studying
English
A)
Teaching
B)
Interpreter
IIJ)
Part
of
speech
A)
Noun
B)
Pronoun
C)
At!jedive
D)
adverb
E)
Verb
JV)
Sentence
Skill
A)
Pre-determiner
J.)
Such
2)
Both
3)
half
B)
Pre-central
determiner
1)
The
2)
Possessive
C)
Post
determiner
1)
Ordinal
number
2)
Cardinal
number
D)
Pre-modifier
1)
Adjective
2)
Noun
Taught
by
:
Nhim
Bunthoeun
Microsoft
Word
2010
·
E-mail:
nhim_bunthoeun7@[Link]

pp
w1::rG]p
·
Gp·
op
fJGJ
·
r::GJ
[Link]
oG·G
:J
;J
G
/\I
111
II
me,
r
Ł
r
Ł
c
QfolHH!lfUfY
"
QS
runLmHH1
·
o
0
<a
I
"=t
c
Qforn
Ltu:u
u.U
n
·q
,..
lfUR!LHDllfU
!J
.B
:>
'
Ł
,n
,....
I
,_..
WR
U1J
fY
QS
ub!fY
D
Lfl1
R!lHD
llfl1
£l
·
111
G
0
'V
-
:;:>
I
0
Bi
LD
n1
uu
fY
f!
ld
1
w
1
w
u
w
f!
u
fY
ufl
h!
lfU
u
·
GJ
G
c;
0
'O
I
0
Bis
LJ}1HJfY
81
:
!UJ0'
_
s
Qrn1
·e
·p
s
LCT
LSffY
ti
s(Cr1\;SwE1w
s
01
m
·o
·q
l_,
.q
I
,ri
,.n
,_..
t
UJRldfY
8
l
ld
DrnLn
u
UJ
s
[Link]
u
8
LS!
uld.[lJ
Rb!:
D
!1
UJtru
w
'.B
I
.
U
I
0
q
!lBl!UJQY!Dk!
sQ1BBUJQY1Dk!
at
LB
n1
Lf
w
N
fl!.!!
lQ
!
UJ
uf!
y
lJ1j
y
«;
O
'Cl
I
0
.n
°I""'
I
L.d.!
[1J
BY
:
D
q
lJ1j
[Link]
Ud
l
LPBYru
e,i
YDt
nln1..1
g
.
UJs
LMJ
n1nqi
ru
tisn1
I
LPBYru
e,1Y.5inlnu
Y
LPS
LMJ
ue,srun1qn
01
I
u
LOYB!LH
I
N
U
lJ1j
ht
!
lfU
H
Q
fJ
l
!.!
D
0J
l
.
lfU
!U!ffi
l.D!S
l
µJll
DYl
:>
"
QPl
[Link]
"'
.
.
1N
-
::i
-
1N08
I
"G
G
·o
G
·p
.
(lj
.
t;
·s
;J
w
G\
G
n
u
B
[fl.J
1
h12
1
:
t
2
u3
t
ru
ufu
n
ul5
n
ru
uiJ
B
IP
B
Ł
·
..

"
,..,,
S8fl!\l
..
:
s12
illiru
unrn:
Ju
nq
fl
s
UJn1
....
G
0
G\
L£r
...................
Pl
"'
"
'"'"''"'"
"
''"'"'
I
<;lJ
fit
Ł
<'
,..
c;
f'"'C-'
ra
"
·
SB1$!1lBY1UJY
Ll!lJl
Ql.2
QLH:HS
[Link]
('
p
...
I"='
..................
....
..
.......
...
..
...
.
.
......
b!
lJUl
...
GOG\
L£r
···
....
·
..
·gr·
·
....
5fii
..........
..
.......
....
1-31n1
UH!LWr!QSWffilSL!J
D
("
,.
C::.
,.
<"
..,
'
Ł
fO
.
'
n
A
I
L
SEHJ
b!
LD1irn
siflB1,fl
u:i
irnrurn
L2
w
Lltns
LRY
u
u:irnJ1rnf!:
wrnpJlDJ
2
ru
8
B
LS
UJBfu
§
r
Ł
p
-
,.
Ł
...
1
a
Ł
I
I
I
I
I
I
I
I
I
I
I
'
'
"""
"'1
""
11r.
:
:12LPirnusrm:1SUn
:
·q
....................................................................................................
...................................
·
........
:
[Link].Q
·m
'
pr...
.................................
.
........
..
............................................................................
,
..................
:
S1'1Bil9Ulffii"Lff
'
"
!;!LS
.......
...
...
.
...........
sh!ss9
-
.
I
..
........
..
....
...
.....
..
..
..............
...
...........
.
.
..........
.
..
.
......
1-'
UJQH
...
...
................
.
.
.........
....
....
......
.
.........
.
.
...............
..
...
...
!D!8B
t>
,.,
Ł
/)i!..
.
u
,,
n
,....
.
.......
....
....
.
.,Gw
..
..
...
......
..
..
81
........
BPIYb!l
o
N!
o
nulJ
.................
.
..................
......
..........
n
sun1:1Jru1
-
p
Ł
('
..
c;
..
l
Ł
,.
.
·
a
I
B
I
.
U
....
..........
........
.
........
..
.
..
.
[Link];tl,,
1
....
...
.
................
......
...
..
............
LfU
2/b!
DJ1
.....
·
··········
...................................
..
..
(
y
L.q!\l)
-o
r-
'
m
.............
...................
.
....................
BlJI
<;lJ
Yb!l
"
"''
''"
![Link]
.......
G
L£r
.......
...
..
........
gr·
................
ti
Pl
h1
b!l
-
0
.
.
<QI
r-.u
,.
..
0
('

c;
p
ONn1oN1:B!Jl"''
'
'
'
'''
'
'""
"'""'
'
"'"
"
''"
''"[Link]
.
GifYH"""'""""''''""'""""''"'
'
'"''"BLS
QS
BLSru
U!l-
..
.
.
'31fm.1m:i:a1
LSP.21..rn
..
samt$SIBM
·g
.
"'
.......
..........
.
...........
..........
SLPh!ffilS
.,
.............
.
...
.
....
...
...
..
....
[Link]\:m1
----------------
-
--
-
-
-

_.
·
-
-
I
-,;
I
.
HwfHM
r1..H5M
:urun
n
teu'lm1u
ruJ
a
n
n
u
n
U
I
0
..,
<Jm:1s
CW'l
G
&ffi)fC"l
l
C1
ii
cV1
cV
CJ
:
ffiJ
.
..
--.:._-
9G
I
.
SIEM
REAP
PROVINCIAL
TRAINNG
CENTER
cl-clclcl
cl
clclclcl.
clclclclclclclcl
C::J
0
.
ifDfJf)j:J£
HwfHM
ruuM
:uMl
ru1trtfl$:tsHsHnHrn
2ttuM
:urun
ruic:nflf:
t2nteuQHnu
ruJ
a
n
n
u
GI
n
n
u
n
I
I
.
m
s
w
eu
w
Ltfl
u
i;J
s
rih
ti
.
w
ru
rui
m
M
w
s
«ii
ti
H
r0
2J
m
s
t1J!l
um
:
H
WJ
H
b1J1
ru
2
ti
m
s
°'
.
0
Ł
..,
tUnHiu
M:
u
ruTJ
ru
tr:s
nn
m
<JH:fl
s
tl
otrt:
t:=l
'l
n
ct
I
'd
·
V
9
Microsoft
Word
&
Excel
2010
Ci
ta
08
:
00AM-
09:30AM
05%
10%
15%
40
$
l'.J
Microsoft
Power
Point
2010
08:00AM
-
09
:
30AM
10%
15%
s
rn
05%
20
$
m
Adobe
Photoshop
CS5
l'.J
t2
09:30AM
-
11
:OOAM
05%
10%
15%
60
$
Ci
:
Corel
Draw
XS
.
b
t2
09:30AM
-
11
:OOAM
05%
10%
15%
40
$
Adobe
In
Design
CS5
.
b
t2
09:30AM
-
11
:OOAM
05%
10%
15%
50
$
b
Publisher
2010
.
b
t2
02:00PM-
03:30PM
05%
10%
15%
40
$
nl
Computer
Repair
bt2
03:30PM
-
05
:
00PM
05%
10%
15%
60
$
cl
HTML
03
:
30PM-
05:00PM
10%
15%
s
rn
05%
50
$
a
Web
Design
b
t2
02:00PM
-
03:30PM
05%
10%
15%
90
$
I
[Link]
Cl
fa
03
:
30PM
-
05
:
00PM
05%
10%
15%
250
$
9
9
I
Quick
Book
2010
b
fa
02:00PM
-
03:30PM
05%
10%
15%
90
$
or
u
WI
ii
:
mug
rum
nJ
t
g
i;J
s
a
rih
ti
rn
:
n
mi
sc:l
nntll
mboss
u
v
u
n
c:i
t
NJ
H
nu
,lg
g
s
ct
fa
n
R
wi
iii
b
o
s
.
s
.
Ulft
Ul521
"'
mH
UBtuQS
......_,
I
Taught
by:
Nhim
Bunthoeun
Microsoft
Word
2010
E-mail
:
nhim_bunthoeun7@yahoo
.
com

p
::i
lJj
"Q
G
/\I
Ill
II
f'3S
"'
.
!;!LS
p
!;!LS
G\G
!o;JLS
PG
!;!LS
J.)
!o;JLS
G\G
!;!LS
PG
!;!LS
OG
¥LS
p
!;!LS
OQ
!;!LS
PG
Pl
LD
n1
Lf
w
.ru
B
w
1
w
1
UJ
u.n
!J
lJU
Ll
t;
0
'O
I
0
·[Link]
Lfl
,_.
I
Llf\J
H.!J:
D
cw
nru
LY1
...
.
I
U
47'
I
V
U:
8
U
n
[Link]
5l
wrn
LP
s
l0J
ei
sru
n1nq1
.ru
iJsn
.
Q
Ł
'O
·oc:
,
!;!LS
PW
!o;JLS
OG
l;!LSPG\
!;!LS
OP
.
p
G\
l;!LSPG
!;!LS
PW
!o;JLS
PG
!;!LS
OG\
l;!lll
J.)W
!o;Jlll
Ul:i
¥WPG\
!;!LS
op
!o;JLS
PG\
!;!LS
PG
!;!LS
OW
l;JLS
OG
!;!LS
OG\
!;!LS
pUl
!o;JLSQG\
!;!LS
G\G
!;!LS
PW
!;!LS
OG
!;!LS
PG\
!;!LS
OW
!;!LS
PG
!;!LS
PG
!;!LS
PW
!;!LS
PG
!;!LSOG\
8Nl)j
NOl8113C:I
NOllVN
""'
.
\11008VIJ'v'8
::IQ
V'J008Nl)i
e
I
U
-Q
I
u
U:
ru
LPflh!flJ
51
!JDl
DLnLI
s
l0J
n!
gn
G
G·irn-o
G
GG·pO-OG\
GG-110-PG
GG·i10-0G
G
0-0
G\
GG-pO-OG\
G
G-irn-p
G
GG-pO-OG\
G
G-irn-o
G
G
G-p
0-0
G\
I?
fllSflJ533!J8fU
......
U'
U1Llfl!LH
I
"'
u
UU
lfU
HQ
Ql
Ll
Df\J
1
.
(""'
!UJ!JLA
...
.
Ll)J!UJm
lt1!Sl!JJ11nJJ1
qf!1qgi}
fu{l!;!g

,
sin
OG
GG-pO·OQ
g
L!JR!J
g

LD1fJ11!W
"
QtpJ
Yl}Q§
YP1RQ'.i
Q
G
G-90-0G
[U
,,
GG-pO-OG\
QlJlJYL,tQS
[Link]
0
u
-.a
I
p
..
G
G-po-o
G\
fu{l!;!gQ§
En1iYpw
p
U
I
N
DJD!;!2Q§
sin
p
.,
G
G-p
O-O
G\
QIJlJYL,tQS
[Link]
w
D
I
II
...
I
p
fuhyp
QS
SHl
..
.
,..
-
<"
GI
.,
GG-PO-OG\
QlpJ!;!IJ
.

f?LRRIJ.'Q
G
.
31nll1SNI
9NINI\fC:l1
l'v'JINHJ31
lVNOUVN
.
e
.
t':;I
1i:i:I'
Ł
Ł
J
-
.
,;
Ł
.
r
.
-
.
Ł
-
Ł

.··
..
·
JissHll!a1
N
U}mrn1
-
'
N
N
-
-
EPt:tBB
.
.....,
,
.
i..
[Link]
al,![Link]
·
EUJn1
EUJn1
ITT1asasLDn1
:
ei.t1.m11
c-
,..
o
.
o
rt
o

n
o
nco
I
Ł
Ł
.
u
,[!
I'\
-
n'
"'
n
ruuruutu.µBt5!L!JB!J:
Eilill55
.
......
...
..
..
.
.
...........
!JIJ\jl
-
.
mLH1
wLE
0
c;urn1
·
.
0
"'-
n
a
rutnwmJLrumill
t:tbl1UJL1ru
rutnul,fitpurum
:Jiif16
1
um
1
PUl
w1EH
aru1Hrn16Hwmrntn-
o
0
p
'°"°
0
Ł
fO
e....
""
Ł

.
Ł
Ł
....,..
::ifC.+
·
t
..
Ł·
·
··
....
n
-
·
·
Yt.:l
v
[Link]
..
......
....
....
.......
.......
.
...
.
.
..
.....
..
...
:aru1
8NINl'v'Cl.l
l'v'NOl.l'v'80(\
ON\f
Cl08'v'l
.:lO
AC:[Link]/\J

!OOQ:JG
!OOOOlJ
QLJ\l
qn11
0
Ł
II!}.
!OOG:JG!
!OOGPG
!OOOOQ
"'
"'
<i!
Q!JHll
0
,..
.
0
"'
G:\..
!OOG:JG
!OOO:JG
!OOPl?G
!OOOO:J
!.!ti
Pl
c:
..
.
e-
!OOlJPQ
!OOOO:J
B
u.:rn1
<i!
0
\:>
\:>
.
'
Vil
V3HOS
8NVHl.
n
V'JOHC>
V3HC>
\:fl:I08
HC>Ol:IHC>
n
Hl.
VH
>H:IOHC>
n
VNilVl:l>IOS
NVHC>
n
>l\f3HdV'Jn>I
NVHC>
SOHS
A3HS
N81>1
n
8NVNV'JVS
NHOH>l
n
8N0l:I
03>l
J....AVN
O'.'.:Dl
e'tO'A40'WBl
mu
e'tO'W-O'WBl
'
.
0
n.
fl::;
'
ttqtwig
ttqtwqrng1
-
--
-
lJ
p
w
Gl
OG
IU
.
w
G\
,-
.-
9
--
11/1.
.
...

Ł
;.""
--
o.
e
CO"'U.J
s
.L
n
;._,
--&
mnli
3
r
rum
fi1
fiTl
rl
h':l
c:.;
(-3
.....
ATTENDANCE
SHEET
Month:
.
........
.
......
.
......
.......
.
Lecture
:
....
.
..
.
..
.
.
.
..
....
....
..
Subject:
.
......
..
.....
...
.........
..
.
(Evening
class)
.....
l
Date
of
Attendance
!\Jumber
of
No
Full
Name
Sex
Absence
I
t]lb
I
M
'
b
I
)Ulb
I
M
"'
m
)tiLrl
.
M
M
d
''\""
9IB
rn
'
..
M
tl
0
,,
Q'
3j1
mruru
M
a
)b
j\1
rl
nm
s
'
'
'
...
nl
mb
M
M
G
Cl
mill
fi5
m
fi
'
F
&:::-'
,
&::II
ru\:J
,,
..
t10
)VJ
M
0
:f
t:J
t1
fu
F
M
t1b
"'
,,
fifl
ill
H\5
fi.m
b
'
:im
)ITTb
'fo
M
n'
<>'
Si
fi
.
M
:id
n
Phnom
Penh,
Date
..
.
......
.
.
.

ru
0
.
.
'
·
-
,
.
""'

Excersise
1
Microsoft
Excel
A
B
c
D
E
F
h-
CD
Warehouse
3
Gneral
Journal
4
'i:t
l
,
:'\,,
L.P
1
'',Ł
1
,,,
-nebit
'
"
I
,
credit
,
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
'·:
·
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
42
Phnom
Penh,
Date:
.....
.!.
.
.
..
./.
.
..
Signature
45
46
47
Nhim
Bunthoeun
Prepared
by
:
Nhim
Bunthoeun

Exercise
:
2
Microsoft
Excel
2003
A
B
c
D
E
F
1
CD
WARE
HOUSE
L-
2
3
General
Ledger
4
!Account
Name:
5
·.
·(·F
Oate
:r.
:
·
1ahtatio
ft
.ifif'::'
1
'
:··:f''
.-
·
Debit
;,:_''·
.
Credit
····
·
:
6
7
8
9
10
11
12
13
14
16
General
Ledger
18
IAccount
Name
:
19
..
"
....
;:!:
13ijlance!
·::·
20
21
22
23
24
25
26
27
28
30
General
Ledger
31
32
Account
Name:
33
Ł

·
.
1r
<-·
.
34
35
36
37
39
40
41
42
Prepared
by:
Nhim
Bunthoeun
Inside
document
,
Copy
Right

1
2
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
A
B
c
D
E
F
G
H
JIKI
LIMINIOIPIQIRISITIUIVIW
x
y
Student
List
of
Computer
ADB
2009
1
fNA
vv
r
F
:
:
--
-
-----:
:
T:
_:
____
r
____
T
_____
T__
:
:
:
:
:
:
:
:
:
:
:
---1-------r---:--
:
--:-----:-----:---:
.
,
,
2
:RONG
:
M
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
Ł
----T-----------------r-----r---------T----T----,----,----
...
3
:SAMNANG
:
M:
:
:
:
:
:
:
:
:
:
.
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
......
......
......
......
4:
SREY
SRO
S
·
:
F
:
:
:
:
:
:
:
:
:
:
:
.
:
:
:
:
:
:
:
:
:
:
:
:
:
:
.
:
:
:
:
:
:
:
...
...
...
5
:KUMPHEAK
{
M
::
:
:
:
:
:
:
:
:
:
:
·
:
:::
:
:
::::
:
:
:
·
:
:
:
:
:
:
:
6
ŁSOKRATTN"A
I
M
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
7
:HATH
:
M
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
I
8
:BORA
:
F
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
·
----·----------------
........
........
......
9
:vEASNA
:
M
:
:
:
:
:
:
::
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:::
:
:
:
"
10
:cHOM
:
M
::::
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
11
:POUCHA
Y
:
M:
:
:
:
:
:
·
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
12
:SOVANN
:
F::
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
::::
l
·
----1'------------
-
----t------
....
....
....
13
:
SOCflEA
TT
A
:
F
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
!
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
.......
____
,_
____
14
:sAREN
:
F
:
:
:
:
:
I
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
15
l
VO
LEAK
I
F
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
16
:CHIN
:
M
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
17
:BUNNAING
:
M
:
:
:
:
:
:
:
:
:
::
:
:
:
:
:
:
:
:
:
:
::
:
:
:
:
:
:
:
::
·
----·----------------
......
18
:BUNLAY
:
M
:
:
:
:
:
:
:
:::
:
:
:
:
:
:
:
:
:
l
:
:
:
:
:
:
:
:
:
:
:
:
19
:
CHHUNG
:
F
:
:
:
:
:
:
:
:
:
:
:
:
:::::
:
:
:::
:
:
:
:
:
:
:
::
:
20
ŁSAMON
:
M
::
:
:
:
:
:
:
:
:
:
:
::::
:
:
;
I
:
:
:
:
;
:
:
:
:
:
:
:

--
-
-{-----------------,..-----r-----
-
---T----T----,-
-
--"'r---,-----r---
-
r----r----T----T-
-
--,----,-----.-----r-
-
--r----r----T----T----,----,-----.-----r----r----r----T----T----,--
-
-,-----.-----r----r----
21
:KO
E
MLAY
:
M
:
:
:
l
:
:
:
i
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
...
...
...
22
:SARY
:
F
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
,
,
____
Ł
______
_
_________
......,
_____
._
_________
..
____
4
____
.,
____
.._
___
.._
____
,_
____
._
____
.,
____
.,
____
..
____
_.
____
.,.
____
.._
____
._
____
"'
____
..
____
Ł
____
4
____
.,
____
23
:[Link]
:
M
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
·
----.1.-----------------'---
-
--L-----
-
---.L----J.----J----..J..----'-----L----L----L-
-
--L
-
---..&----J----J-----'-----L----L----L----.L----.&----.l-----1----""--
--
-L-
-
--L---
-
L----.&.----.&--
-
-J----.J-----'-----L.----L.----'
24
:vANNAK
:
F
:::
:
:
:
:
:
:
:
:
:
::
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
:
1
25
:
HE
NG
:
M
:
:
:
:
:
:
:
:
:
:
_:
:
_t
_____
l___
:
___
l
L
:
:
:_
:
:
:
:
:
:
:
:
:
:
:
Date
:
.
....
.
...
.
.
../.
.
.............
./.
.
....
.
.
...
.
..
.
..
.
Class
Partron
Nhim
Bunthoeun
+
How
to
format
Number
-
Click
on
Home
Menu
-
Click
on
Number
tab
-
Click
on
Custom
1
1000
2
2000
3
3000
4
4000
fflf
Format
Custom
Formating
Dollar
1000.0
2000
.
0
3000.0
4000.0
01
$2-P""""oRP.:6op;;;
(
l;;;;;;:$
n
::;;;;;;;
....
Q;;;;::
::
-,,
200.00
02
$300.001$
03
$400.001$
04
$500.001$
Riel,
Bath,
.....
Formating
S
01IR
S
021R
S
03IR
S
04IR
iiljjfj
·'
i.
l
"'
==
:<
.<
lii''0
100.00
200
.
00
300.00
400.00
300.00
400.00
500.00
R100.00
R200
.
00
R300.00
R400.00
How
to
format
currency
in
full
word
!!f
=
C:C
,.
'.!1
..
.....
2!!2
_
-..
,
1
Riel100.001
Riel
100.00
2
Rie1200.00IRiel
200.00
3
R
i
el300.00IRiel
300.00
4
Riel400.00IRie
l
400.00
How
to
format
time
'

1
11
:
0
PM
11:00
PM
2
10:0
AM
10:00
AM
3
2
:
0
PM
2:00
PM
4
2
:
0AM
2:00
AM
010
11/12/2008
Sat/Jan/08
011
110/25/2008
Sat/Oct/08
012
12/18/2008
Mon/Feb/08
013
111/20/2008
Thu/Nov/08
_
__
,
1,000.00
15,000
.
000
15,000.000
2,000.00
20,000.000
20
,
000
.
000
3,000.00
25,000.000
25,000.000
4
,
000.00
30
,
000
,
000
30,000.000
200.00$1200.00
300.00$1300.00
400
.
00$1400.00
500.00$1500.00
100
.
00RI
100
.
00
RIB
100.00
200
.
00Rl200.00
RIB
200.00
300.
OOR
I
300.
00
RIB
300.00
400
.
00Rl400
.
00
RIB
400.00
100.00Rie1l
[Link]
Riel
200.00Riell200.00
Riel
300.00Riell300.00
Riel
400.
OORie
l
1400
.
00
Riel
·>.">/···;;,
23
H:OO
mm
23
H:45
MM
23
Hours
:
30
Minutes!
10
H:OO
mm
10
H
:
20
MM
10
Hours
:
50
Minutes'
14
H:OO
mm
14
H:OO
MM
14
Hours
:
OO
M
i
nutes
2
H:OO
mm
15
H
:
OO
MM
02
Hours
:
OO
Minutes
"'<"
Saturday/January/2008
IJan/12/08
Saturday/October/2008
I
Oct/25/08
Monday/February/2008
I
Feb/18/08
Tuesday/May/2008
I
Nov/20/08

;,;.,
.a
·
:1
....,,.
B
.,
,
.,...,
,..
,r,..;y-
"'"
...
c
D
E
F
G
H
J
K
L
M
N
0
1
Soft
Drinks
Orru
2
p
01
Coca
Cola
10
15
12
43
15
7
p
02
Fanta
65
26
45
86
54
8
p
03
7
Up
26
54
85
14
54
9
p
04
Pepsi
15
65
45
55 58
10
p
05
Oranqe
23
26
56
54
25
11
p
06
Oishi
45
25
84
65
45
12
p
07
M150
42
65
87
56
42
13
p
08
Carabao
25
46
58
57
95
14
p
09
Sova
15
64
85
62
54
15
:'
16
01
ABC
40
c
56
c
15
c
46
c
24
c
53
21
p
02
ASHAHI
52
c
248
c
23
c
52
c
56
c
62
22
p
03
TIGER
36
c
24
c
12
c
46
c
54
c
45
23
p
04
ANCHOR
24
c
62
c
54
c
21
c
24
c
14
24
p
05
BAYON
25
c
42
c
68
c
52
c
61
c
57
25
p
06
ANGKOR
46
c
58
c
52
c
62
c
8
c
44
26
p
07
KLANG
58
c
24
c
45
c
31
c
26
c
64
27
p
08
SINGHA
52
c
64
c
21
c
12
c
95
c
85
28
p
'
09
BLACK
46
c
24
c
64
c
32
c
98
c
64
29
...
..
30
32
33
34
35
=Sum(C20:C28)
,i
.
.
·
--·
...
..
_
.
....
;._
6
45
65
46
45
68
65
25
8
45
85
67
68
56
65
42
82
48
c
45
c
45
c
64
c
64
c
58
c
68
c
44
c
56
c
85
c
45
c
64
c
641
c
88
c
64
c
54
c
34
c
64
c
82
54
45
52
'
45
24
52
45
62
66
c
48
c
56
c
15
c
65
c
84
c
21
c
46
c
61
c
46
c
31
c
48
c
45
c
477
c
8
c
24
c
64
c
62
c
54
c
65
c
46
c
62
c
15
c
35
c
46
Phnom
Penh,
December
23,
2008
Signature
=Sum(020:028)

A
B
1
2
6
0
2
Wat
er
$
7
03
E
lectrici
ty
$
8
04
Gasoline
$
9
05
Offic
e
Equipt
$
10
06
Paper
$
11
07
Internet
$
12
08
Misson
13
Total
each
month
1
ABC
R
17
2
TIGER
R
18
3
ANCHOR
R
19
4
BAYON
R
20
5
BLACK
R
21
6
ASHAHI
R
7
ANGKOR
R
0
2
Pen
27
0
3
Dictiona
ry
28
04
T
e
lephone
29
05
Keyboard
30
06
Monitor
31
07
CD
ROOM
32
08
DVD
33
09
TV
34
10
Camera
c
786
.
00
$
568
.
00
$
4,554
.
00
$
45
.
00
$
4,521
.
00
$
1
,
542.00
$
80
,
000
.
00
R
75
,
000
.
00
R
54,000.00
R
45,000
.
00
R
51
,
000
.
00
R
43
,
000
.
00
R
65,400.00
R
$
50
$
10
$
15
$
24
$
12
$
21
$
15
$
10
$
14
$
D
25,600.00
15
,
246
.
00
45
,
684
.
00
756.00
456
.
00
65,456
.
00
90
,
000
.
00
82
,
000.00
62
,
000.00
52
,
000.00
64
,
000
.
00
48
,
000
.
00
75
,
600
.
00
E
F
j-\11111
ilJ
,
·a-
,-·y
$
4
,
544.00
$
8
,
687.00
$
568.00
$
7
,
568
.
00
$
5
,
678
.
00
$
4
,
564.00
G
--
l
:
.
H
=Min(C5
:
F5)
=Max(C5
:
F5)
=Average(C5
:
F5)
=Sum(C5
:
F5)
J

A
G
=A8/4200
2
3
I
I
I
__________
f
8i$
.................................
T$i'8
.................
..
....
.
.....
.
..
...
'\'$HKi$
................................
.
r
........................
.........
............
........
..
.
..............................
:.
.................
..
......
....
.............
l
..........
.
.....
...........
.
.
.
...
.
.
...
....
...
:
ŁŁŁŁŁŁ
ŁŁ
Ł
Ł
Ł
ŁŁŁŁ
ŁŁ
ŁŁ
ŁŁŁŁŁ
Ł
ŁŁŁ
Ł
Ł
Ł
ŁŁŁŁ
ŁŁŁ
ŁŁŁŁ
ŁŁŁŁŁŁŁ
1,000.00
E
_!
1,300.00
x
$
1,000.00
10
R
1,500
.
00
c
$
1,500.00
ii'
11
R
2,000
.
00
H
$
2,000.00
12
R
500
.
00
A
$
2,500.00
13
R
1,200.00
N
$
3,000.00
II
14
R
2,600.00
G
$
3,500
.
00
15
R
4,000.00
E
$
4,000.00
16
R
900.00
$
4,500.00
17
R
1
,
000.00
R
$
5,000.00
18
R
2,000.00
A
$
5,500.00
19
R
3,000.00
T
$
6,000
.
00
20
R
4,000.00
E
$
6,500.00
21
R
5,000.00
$
7,000
.
00
22
R
6,000.00
$
7,500.00
7,000.00
$
8,000
.
00
(;;;
--
-------
---
Weil
25,100.00
.,
x
R
100,000.00
15,000.00
c
R
200,000
.
00
33
B
7,500.00
..
H
R
300,000
.
00
34
B
2
600
.
00
A
R
400,000.00
35
B
4,000.00
v'
N
R
500,000.00
36
B
600
.
00
G
R
600,000.00
37
B
700.00
E
R
700,000.00
38
B
800.00
R
800,000
.
00
39
B
900.00
R
R
900,000.00
B11
40
B
1,000.00
"
A
R
1,000,000.00
41
B
2,000.00
T
R
1
,
100,000
.
001
42
B
3,000
.
00
E
R
1,200,000.00
4,000.00
R
1,300,000.00
5,000.00
R
1,400
,
000.00
6,000.00
R
1,500,000.00j
!

1
2
3
4
5
11
A
8
c
D
E
.
12
1
01
1
KEO
NAVY
1
F
r
500
,
000.00
13
02
KEO
RONG
M
R
55,000.00
14
03
KHORN
SAMNANG
M
R
60,000.00
15
04
KIGN
SREY
SROS
F
R
65,000
.
00
16
05
CHAN
KUMPHEAK
MR
70
,
000.00
17
06
CHAN
SOKRA
TTNA
M
R
75,000.00
18
07
CH
ORK
HA
TH
MR
80,000.00
19
08
CHROCH
BORA
FR
85,000
.
00
20
09
CHHAN
VEASNA
M
R
90,000.00
21
10
CHEA
CHOM
MR
95,000.00!
22
11
CHEANG
POUCHAY
M
R
100
,
000.00
23
12
NHEB
SOVANN
F
R
105,000.00
24
13
THANNG
SOCHEATTA
F
R
110,000
.
00
25
14
DON
SAREN
F
R
115
,
000.00
26
15
NEUNG
VOLEAK
FR
120
,
000.00
27
16
BRON
CHIN
MR
125
,
000.00
28
17
PHAN
BUN
NAING
MR
130
,
000
.
00
29
18
PHAT
BUNLAY
M
R
30
19
PROEUNG
CHHUNG
FR
140,000.00
31
20
PREN
SAMON
M
R
145,000
.
00
32
21
MEUCH
KOEM
LAY
M
R
150,000
.
00
33
22
LUY
SARY
F
R
155
,
000
.
00
34
23
VOENG
KHVOEURT
MR
160,000.00
35
24
VANN
VANNAK
FR
165
,
000.00
36
25
VAY
HENG
M
R
170
000.00
l=E10/4200
"Press
F4
=>Enter"
I
m
39
Ł
.
"
C>
"
Remain
ttufmti:
=
Mod(
E
l0
,
4200)
1$
=
4200
R
'
'
·
42
u
"'
F
+
11
+
Minimum
=surn(Number
l
,
Number2,
...
)
=Min(Number
l
,
Number2,
.
.
.)
+
m'tHJtlrntln
+
m'trnHnUrt:fl"Maximum
USSUmtlm
v
n
y
1J
....
=Numberl-Number:l
,
=Max(Numberl
,
Number2
,
.
.
.
)
+
Average
·.1!
.
'.
.\
=A
verage(Number
l
,N
umber2
,.
.
.
)
54
..
.
G
...
..
H
+
mHatlrntufi
v
n
=Numberl/Number
2
+
mastlrnemn
·
[Link]
v
n
1
=Number
I
*Number2
J
113
.
51
/""'
...
·
'
1
""Product(Numberl
,
Number2
,
...
)
-
.
'
.
.
,.....-
-
'

Al
B
IC
ID
IE
IF
I
GI
HI
I
I
JI
KIL
IM
IN
.,
..

Ł
.
:
.
11·1
'
·
·
--
=Average(d5
:
15)
3
4
:;.;i;·:
...
·;:.
:;;-,
Bioio9y
1
}i
·;
jef
·.·

·
..
·
Rci61
(
..
5
ŁŁ
1
NAVY
F
98 95
"
98
97
97 96
62
RONG
M
24
45
35
46
64
45
<,:
54
.
.
17"
':
:··
2t
<:,
73
S
A
MNAN
G
M
68
59
85
64
56
85
·J··''
56
"
Ł,
,-
85
'
,:·.
69
:
50
.
'.·
··
to
>
:
'
'
84
SREY
S
ROS
F
58
98
65
85
46 45
:
'
"'
::·Ł.:
98
:
;:
""
Ł'
66
;
'
17
·:'.:
·.
12
:
Pass
>
'..
...
,,
'
·
'
'
'
'
'
''
'
.
''
..
,
''
.
'
'
'
'
'
.......
'
95
KUMPHEAK
M
87
59
85
79
57
85
'.'\'
87'
7
·."
3
'.'}:,:,:
>
10
6
SOKRATTNA
M
25
68
54
85
46
54
'
;,
'
1.'
8
..
11
1
HAT
H
M
78
98
58
.
56
46
85
46
.;
..
_
"
..
;-
gs
..
,,
-.
·:
:
..
·:
1
..
-
,.,
'
12
8
BORA
F
75
89
85
75
65
45
:·(f'
..
Pas
·
s
.{'.'
13
9
VEASNA
M
25
45
62
34
85
15
:',";·_,·:
a():
:ii::'{%:
·
..
14
10
CHOM
M
45
68
'
95
85
68
59
.'
15
11
POU
C
HA
Y
M
68
98
58
88
58
75
..
,,.ct
·\::.·
>,,,
1
J
:f11,
:''
1
'..,
·'._.··
L
'.,,
16
12
sov
ANN
F
42
56
45
85
75
95
::'
,:,
11
:
1
'.
8a$s
..
1,;X
17
13
SOCHEA
TT
A
F
84
67
98
58
25
47
!
:'#:'"
25
.'::Łi(:Ł:
:'
.;:!>
9,8
:rd;}"
:.:
..
'
Ł:'Ł:t
:
".":
nc
/.'''·"'·'·
·.,
...
·
·
..
,
...
-..
,.,,,,.,.'1;,
.
.-
o-
·,.,,,
,...,
.
.
,,
.,
.,,,.,.,,,"
18
14
SAREN
F
75
95
82
64
85
35
"ŁŁ::'+'Ł
vv
),'.,C,
,.,,,,:,
;:;,"'

..
Ł'"'
..
,.,
''':r.
q
ti"''fr'
19
15
VO
L
E
AK
F
75
85
48
58
45
75
t:
.,::.,·'·,·
64
:
33
'.;,;
:
M
.,.,,"''1"''
.Ac:
h
Ł·."'···
Ł..
,,,
·
·
·
z
'
c
""''-"
·
....
,
...
6
·
2
···"
6
.
'
7
'·""'·
·.
·Ł
16
·"'·

·
p
'
..
_
..
,.,,
...
;
,
20
16
CHIN
48
68 69
59
78
54
:'J;:,.
ot1)
,
::,.·
:;,,
:
..
u
<:

·
·.,
.:
:
.
!.'
.:!:;>'
'-:',
·
·
..
:.


21
17
BUNNAING
M
42
56
87
54
95
85
..
..
:
""·
$.
?!;",,
::
Ł..
<;:·"Ł»:·"
:11a
·:>{'.i'>'
····
.
·
·'"·
'"
"\"'
.....
,,
..
.,
...
·
··
.,.,
,
22
18
BUN
L
AY
M
78
85
75
85
46
98
i
·:;
!
·:''
,.;
gs,
,,,
{'

>
;
23
19
cHHUNG
F
48
57
25
a4
65
87
i
'.t,
....
·
..
;:,
i
at
..
,.,.
-
"
,
'
;
24
20
SAMON
M
42
65
87
57
85
46
,,..,,.
42
::
,,
'
14
:;.r·
25
21
KO
E
MLA
Y
M
45
68
24
68
54
22
,
·
·
..
·
":·
i.49
:
$3
"
26
27
Number
of
Students
=Count(A5
:
A25)
28
Number
of
Female
=Countif(C5
:
C25
,
"F")
29
Number
of
Male
=Countif(C5
:
C25
,
"M")
30
Number
of
the
Fail
=Countif(N5
:
N25,"Fail")
31
Number
of
the
Pass
=Countif(N5
:
N25
,
"Pass")
1
32
4
5
6
37
........._
'
-,
,
,
.
'
\
.
·
..
.
.
.
..
.
r..
/
/
=RANK(L5
,
$L$5
:
$L$25
,
0)
"=Rank(L5
,
L5
:
L25
J
uqu
F4
JtitriJjM
til'i
-
=
Count(Valuel
,
V
a
lue
2,
..
..
)
l=IF
(
L6>=50
,
"
Pass
",
"Fail")
-
=
Countif(Range
,
Crit
e
r
ia
)
-
=Pass
-
Rang
e
Cells
di
"'
v
'
d
d
-
Criteria
fitnffilj8UJJU'1Jli'i
muMHM1tntrna
1Hl'ij1l'itilf.l

A
B
c
D
E
F
G
H
1
L__
0
'
0

4
......
.
.
.
.
.
.
.
.
!
...
.
.
.
.
.
.
..
.
.
.
.
.........
.
...
.
.
J
.
...........
.....
.
.....
\
.
..
.
.
.
.....
.
...........
.
............
..
.....
...
.
Value
!
4200
.
00
R!113.51
R!37
.
00
8!9
.
00
$HK
5

I
I
team
I
Quantity
I
Unitprice
I
Net
Income
"R"
I
Income"$"
I
income
in
"B"
I
income
in
"$HK'
6
1
ABC
30
Cases
R
90
,
000
.
00
R
2
,
700,000.00
$
23,786.45
B
5,785
.
71
$HK
7
2
TIGER
50
Cases
R
82,000.00
R
4
,
100
,
000
.
00
$
976
.
19
36,120
.
17
B8
,
785
.
71
$HK
8
3
ANCHOR
70
Cases
R
62,000.00
R
4,340,000
.
00
$
1,033.33
38
,
234.52
B
9
,
300.00
$HK
9
4
BAYON
45
Cases
R
52,000
.
00
R
2,340,000.00
$
557
.
14
20,614.92
B
5,014.29
$HK
10
5
BLACK
80
Cases
R
64,000
.
00
R
5
,
120,000
.
00
$
1,419
,
0
_
5
B
10,971.43
$HK
11
6
ASHAHI
60
Cases
R
48,000
.
00
R
2,880,000.00
$
685
.
71
25
,
372
.
21
86,171
.
43
$HK
12
7
ANGKOR
74
Cases
R
75
,
600
.
00
R
5
,
594,400.00
$
1,332.00
49
,
285
.
53
B
11,988.00
$HK
13
Grand
Total
409
Cases
R
473,600
.
00
R
27,074,400
.
00
6,446
.
29
$
238
,
519
.
95
B
58,016.57
$HK
14
15
N
°
I
Iteam
I
Buy
in
I
Sale
I
Net
Income
"$"
I
Income
"R"
I
income
in
"B"
I
income
in
"$HK'
16
1
Radio
15.00
$
20
.
00
$
5
.
00
$
21,000
.
00
R
185
.
00
:t
B
45
.
0Q
$HK
17
2
Speaker
8.00
$
14.00
$
6
.
00
$
25,200.00
R
222.00
'.
B
54
.
00
$HK
18
3
Monitor
35
.
00
$
45
.
00
$
10.00
$
42,000
.
00
-
R
370.00
B
90
.
00
$HK
19
4
Mouse
3
.
00
$
6.00
$
3
.
00
$
12,600.00
R
111
.
00
B
27
.
00
$HK
20
5
KeyBoard
3
.
50
$
5
.
00
$
1
.
50
$
6,300.00
R
55.50
B
13
.
5.0
$HK
21
6
Camera
58
.
00
$
74
.
00
$
16.00
$
67,200.00
R
592
.
00
B
144
.
00
$HKJ
22
7
Exteranal
68
.
00
$
92
.
00
$
24.00
$
100,800.00
R
888
.
00
-
B
216.00
$HKI
23
Grand
Total
190
.
50
$
256
.
00
$
65
.
50
$
275,
100
.
00
R
2,423
.
50
SR
589.50
24
25
I


!
Emp
Nqme
j
Sex
!
Date
of
Birth
!
Address
!
Marrital
Status
j
Function
f
.
Salary
26
01
!NA
VY
!
Female
!
23-Dec-91
!
Phnom
Penh
!
Single
I
Manager
!
800
.
00
Dollarl
··
·
···Ł·ŁŁ
Ł
Ł->ŁŁ
ŁŁŁŁŁ
Ł
Ł
Ł
ŁŁŁŁŁŁ·
·Ł
Ł
ŁŁŁ····
·
····
·
·
·<Ł
ŁŁŁ
ŁŁŁŁŁ
..
Ł
Ł
··
ŁŁŁŁ
····
·····
·l
ŁŁŁŁŁŁŁŁŁŁŁŁŁŁŁŁŁ
Ł
Ł·
··Ł·
Ł··
····
ŁŁ
··I
ŁŁŁŁŁŁŁŁŁŁŁŁŁ
Ł
Ł
ŁŁ
ŁŁŁŁŁŁŁ
··
·
··
·
··
·
··
ŁŁŁ
·
Ł
·
·
·
·

ŁŁŁŁŁ
..
"""""""""""""""""
"
"""
""
"
"
Ł
ŁŁŁ
Ł
Ł
Ł
ŁŁŁŁ
1
27
02
!
RONG
Male
!
26-0ct-88
!
Siem
Reap
!
Married
!
Accounting
j
550
.
00
Dollarl
.
.
........
.
.
,
.
.
.
.....
.
.
.
...
..
...
.
.
.
.....
.....
.
.
.
,
...
.
...
.
.
.
.....
.
.
..
..........
,
....
.
....
..
..
..
..
.
.
.
.
.
...
.
.........
,
...........
.
.
..
........
.
.
..
................
.
,
..
.
.
.
.
....
..
....
.....
.
.
.
.
......
.
.
.
..
,
.
..
.
..........
.
...
..
.....
........
.
..
.....
.
..
.
...
.
...
..
..
....
....
.
.
.
....
.
....
.
....
1
28
03
!
SAMNANG
j
Male
!
1
O-Dec-85
j
Kanda!
j
Single
j
Marketting
!
450
.
00
Dollar!
·
·
·
·
·
·
···
·
·
·
)
·······
·
·····
............
.
........
.
(
......
.
.....
..
.......
....
....
,
.....
.
.................
...
....
.
.
..
.
,
.
........
.
..
...
..
..
.......
..
....
.
.
.
.........
c
....
.
.....
.
..
....
..
.
..
....
.....
.
....
)
.
....................
.
.
..
.
.
...
..
.
.
....
.
;
.............
.
..
.
.
.
...
.
..
.
..
.
....
..
.
.
..
.
29
04
!
SREY
SROS
!
Female
!
8-Sep-89
!
Phnom
Penh
!
Single
1
Staff
!
250
.
00
Dollar
30
31
06
!
Sre
y
Rath
!
Male
!
1
O-Jul-89
!
Svay
Reang
!
Married
!
Security
!
150
.
00
Dollar
32
33
08
!BORA
!
Female
!
15-Mar-88
!
Siem
Reap
!
Married
;
Accounting
!
550
.
00
Dollar
......
...
..
..
·
····
·
·
.....
.
..
.....
....
..
,
.........
.
.
..
..
.
....
...
........
.
...
,
.
.
....
..
..
.
.............
.
..
.
...
.
....
.
...
..
..
{···
··
·
.......
.
....
.....
.
....
.....
..
.,
....
.
..
.
.
.
..
..........
..
....
...
.
....
...
,.
...
.
................
..
..
...
......
...
.
.
.
.
34
09
i
V
EASNA
!
Male
!
2-Jun-83
;
Siem
Reap
;
S
i
ngle
;
C
l
eaner
!
100
.
00
Dollar
35
36
11
!
POUCHA
Y
!
Male
!
1-Jul-92
!
Svay
Reang
!
Marr
i
ed
!
Driver
!
260
.
00
Dollar
37
···
1
·
2··
..
39
I
Number
of
Emplyee
I
Female
I
Male
Married
I
Single
I
Employee
in
PPI
Employee
in
SR
Persons!
7
Personsl3
Personsl3
Persons
40
112
Personsl4
Persons!
8
Persons!
5
41
42
1
-.

.Y
'
....
'*';
..
.
A
-
...
-
.
.
..
....
,,_,,.·
··
'·"·Ł·
'
··fT>_...
R
....
,
,.
....
,.
·
or
.
·
ccess
verage
er:i
43
01
!
NAVY
i
95
.
5
i
98
.
5
i
68
l
87
.
33
i
1
!
Pass
44
···a2
····1
R:o
N
6
..
.
..
.
....
..
......
f
·····
·
·····
75······
···
··
l····
··
·
·
·
·
··
···
9a····
··
·
···
·
····l
·
··
·
···
·
······
·
···
..
5
·
5
·········
·
····
···
·
·
!····
······
·
·
7
·
9
·:
33
··
···
···
·
·
··:··
·
·
·······
·
··3
··
··
···
··
····
··
·
·
·
j
·
·
···
··
.
.
.....
Ł
Ł
Ł
Ł
ŁŁ
Ło
oooŁ
)
""'
"'
''
'''
''''''"""""'
'
''
'
"""(ŁŁOo
ŁŁŁŁŁ
ŁŁ
Ł
ŁŁOo
Ł
Ł
ŁŁŁŁŁŁŁ
.,ŁŁ
l
ŁŁ,.ŁŁŁŁŁŁŁ"''
"
'
'''''
"''''''"''

Łoooooooooooo"'"""
''
'''''
'''
'''"
'
"''"'

ooooo"
''
""''''"'"'"'
''
'
'
''""'''
I'''
"''"
''
'
''
'
'
"'
'
-
'
'
"'"'"
''''
'
''
"
";.
"
'
''
''''"'""
'"
''
''
'''
·
"
''
'""
'''
"
45
03
!
SAMNANG
!
75
i
82
i
12
!
56
.
33
l
7
f
Pass
46
·
··a4
·
··
·1
·s'REY:
..
····
·
·
··
9
··
·
········
···
··
·r·
··
..........
.
.
)
......
....
..
..
...
.
...
.
.............
..
.......
.
.
.
...
......
....
.
...
;
......
.
...
......
.
...
...
.
.
..
...
.
....
;
..
..................
.
..............
..
.
.
.....
:
.......
...
...
.
....
..
.........
....
.
..
).
.
.
..
.
.
.
........
..
.
...
.......
..
....
.
.
:,...
.
.
.
....
..
...
..
..
;
..
...
.............
.
47
05
!
KUMPHEA
K
!
68
l
54.5
l
24
l
48
.
83
l
8
11
Ł
!
,
Fail
48
49
07
!
HATH
l
65
l
48
.
5
l
75
l
62
.
83
l
6
'
Pass
"'''''''
·
·
'>''
·
·
·
''
"
'''
'''
·
'
·Ł
"
Ł'
'
'''''
''
·
'''
·''''''"
Ł·
·
Ł·
''
'
'
''"
·
Ł
...
ŁJ
Ł
Ł
Ł
Ł
Ł
...
Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
...
""
Ł
....
.
"'
Ł
I
··
··
ŁŁ
ŁŁŁ
.....
···
·ŁŁ
..
ŁŁŁŁ
Ł
.....
Ł·ŁŁ
ŁŁ·Ł
..
ŁŁ

Ł
Ł
Ł
Ł
Ł
Ł
Ł
..
.
Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
..
Ł
Ł
Ł
Ł
..
Ł
Ł
Ł
Ł
Ł
Ł
Ł
..
Ł
..
.
Ł
ŁŁ
·
Ł
Ł
Ł
Ł
Ł
..
Ł
Ł
Ł
Ł
..
.

Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
Ł
...
Ł
Ł
Ł
Ł
Ł
Ł
Ł
..
Ł
..
..
Ł
..
Ł
Ł
Ł
Ł
....
"
Ł
50
.
.
.
..
.
.
.
................
!
.
.
....
.
.
.
.
...
.
.
..
...
..
i
...
..
.
.
...
.
.
.
!.
.
?.
:.
?
..
.
.
.
..
......
!
....
.
.
....
.
...
..
.
.
.
.
.....
.
.
....
.
.
......
l
...
..
..
.
...
.
...
.
..
....
..

·
:
·
·
·
·
:
;,;
······3.
;;<
..
.
.
:
.......
..
...........
...
.
..
.
.
.
...
..
....
.
51
09
l
CHOM
j
58
65
j
85
j
69
.
33
j
.
5
-
j
Pass
''
''
'''"'
''>
0
ŁŁŁŁ
00
Ł
Ł
ŁŁ
ŁŁ
Ł
ŁŁŁŁ
Ł
.,ŁŁŁ
Ł
ŁŁŁŁŁŁŁŁŁŁ(oŁŁ
ŁŁ
Ł
Ł
ŁŁ
Ł
"Ł"
"''''''
''"")Ł
ŁŁ
ŁŁ"""'''
''
'
''
'"""'''
'
""'"
''
''"''"'"''
"'
'
''''''
'''"""'
'
'
''
''
'
'
"
''
(
ŁŁ
ŁŁ
ŁŁŁ
Ł
Ł
Ł
ooooooooooo0oo
o
oŁŁ
Ł
ŁŁŁŁŁo)
Ł
Ł
ŁŁŁŁŁ
ŁŁŁ
ŁŁ
Ł"
'
"''"'
'
'
'
'
'
"''
''
''"

o
"''
''''"
'
"'""
''''''
'''
'
'
"'
"
'
"'
52
10
!
SOVANN
!
75
!
85
!
68
!
76
.
00
L
_
·
,
4
!
Pass
=Rank(Number
,
Ref
,
O
)
I
=
'
f(F
43
>
=
0
"
P
,,
"
F
ii
")
=Rank
(
G43
,
G43
:
G52
q
u
F4
![Link]
CIJ
SJ
1
5
Ł
ass
Ł
a
54
Number
of
Students
10
Persons
i--..
=count(A43
:
A52)
55
Fail
3
Persons-+
=countif(H43
:
H52
,"
Fail
"
=counif
(
H43·H52
"
Pass
"
56
Pass
7
Persons
I--'
·
·
,
57

-
A
B
-
6
IS
002IRONG
7
IS
003ISAMNANG
8
IS
004ISREY
SROS
9
IS
005IKUMPHEAK
10
S
006
SOKRA
TTNA
11
S
007
HATH
12
IS
008IBORA
13
IS
009IVEASNA
14
l
,
S
01
OICHOM
15
IS
011
IPOUCHA
Y
16
IS
012ISOVANN
18
I
Number
of
Female
c
I
"b
I
E
I
F
I
.
G
r
H
I
1-i-
J
'
T
K
I
-
-
L
r
M
M
I
75
I
84
I
68
M
I
75
I
82
I
88
F
I
24
I
52
I
62
M
I
84
I
68
I
75
M
I
32
,
421
35
M
75
84
65
F
I
75
I
68
I
21
M
I
75
I
45
I
24
M
I
42
I
56
I
54
M
I
45
I
26
I
54
F
I
75
I
87
I
69
54
82
32
84
65
24
42
25
21
26
85
75
75
42
57
42
-
58
58
85
54
54
79
t\J
4
Number
of
Very
Good
-nsm1thl:l
lio
=we
ak
-nBl:mmli
lio
t:lm
Cllcl
=
Fair
4:
"
"';
..
0
8
2
-
=
Good
-nsmulili'!l
t:lm
<i>OO:Very
Good
":
...
";
19
I
Number
of
Male
20
I
Number
of
Pass
Nurnber
of
Good
7
Number
of
Fair
4
21
I
Number
of
Fail
5
Number
of
Weak
5
=IF(L5<50,'Weak",IF(L5<=75,"Fair"
,
IF(L5<90,"Good"
,
IF(L5>=90,"Very
Good"))))
27
s
002
RONG
M
2-Jan-08
28
s
003
SAMNANG
M
3-Jan-08
29
s
004
SREYSROS
F
4-Jan-08
30
s
005
KUMPHEAK
M
5-Jan-08
31
s
006
SOKRATTNA
M
6-Jan-08
32
s
007
HATH
M
7-Jan-08
33
s
008
BORA
F
8-Jan-08
34
s
009
CHOM
M
10-Jan-08
35
s
010
SOVANN
F
12-Jan-08
36
38
I
timgimttifoml:l
39
I
ti11tg1mfitimti
40
I
til'itgimttlmmsumit@stlll:l
mooo
41
til'itgmrttlmmstmnfititlll:l1tcg
mooo
42
00-tmn-l!:Jooc!
43
I
l!:lm-1rnri-l!:Jooi5
44
I
a
Ł
..,.
.,
Ł
+
i'ilHJl'i
r
ta
[l
(Datedif)
=Datedif(Start-date
,
End-date,unit)
I
I
\:
10-Apr-09
5-Dec-08
26-Sep-08
23-Aug-09
9-Aug-09
=COUNTIF(H26
:
J35
,
">=365")
=COUNTIF(H26:J35
,"<=365")
=COUNTIF(M26
:
N35,">3000")
=COUNTIF
(M26
:
N35,"<=3000"}
=COU
NTIF(F26
:
G35,
"<=1
-1-09
"
)
=COUNTIF(F26
:
G35,
">1-23-2009")
Unit=
"
D"
Unit=
"M"
=SUMIF(C26
:
C35
,"F",
026
:
036)
=SUMIF(C26:C35
,
"M"
,
026:035)
=COUNTIF(M26:N35,"<2000")
=COUNTIF(M26:N35
,
">2000")
=COUNTIF(H26:J35,">=365")
=COUNTIF(H26
:
J35,"<365")

I
A
B
c
D
E
F
G
H
I
1
w
'il
--
2
,____
3
&
,____
i=H9*4050
I
4
5
=Hour(Serial
Number)
Ex
:
=Hour("3
:
25"6
Result=3
l=E9-D9
6
=Minute(Serlal_Number)
Ex
:
=Minute("3
:
3
")
Result=25
>---
tl\e
4050
7
No
Name
x
Timein
Time
Out
Fee/Hour
Amount
in$
A
:nount
in
Riel
<!>
Wo
1nq
Hours
8
(f)
9
001
NAVY
F
7
:
30
AM
11
:
30AM
Al4
H
:
00
MM
$
5
.
00
$
-20.00
R
81,000
.
00
10
002
RONG
M
7
:
30
AM
12
:
00
PM
4
H:
30
MM
$
2.00
$
I
9
.
oo
R
36,450.00
11
003
SAMNANG
M
7
:
30AM
11
:
00
AM
3
H:
30
MM
$
.
1
.
00
$
I
3.50
R
14,175
.
00
12
004
SREY
SROS
F
7
:
30
AM
11
:
25AM
3H
:
55
MM
$
0.50
$
7
1
.
96
R
7,931.25
13
005
KUMPHEAK
M
7
:
30
AM
12
:
00
PM
4
H:
30
MM
$
4
.
00
$
[Link]
R
72,900.00
14
006
SOKRATTNA
M
7
:
30AM
11:20
AM
3
H:
50
MM
$
2
.
00
$
7.67
R
31,050.00
15
007
HATH
M
7
:
30
AM
10:30
AM
3
H:
00
MM
$
2
.
50
$
I
7.50
R
30,375.00
16
008
BORA
F
7
:
30
AM
11:45
AM
4
H:
15
MM
$
2
.
00
$/
8.50
R
34,425.00
17
009
V
E
A
SN
A
M
7:30AM
12:05
PM
4
H:
35
MM
$
1
.
00
'JI
4.58
R
18,562.50
18
010
CHOM
M
7
:
30AM
11
:
45
AM
4
H:
15
MM
$
1
.
00
$
4.25
R
17,212.50
19
011
POUCHAY
M
7
:
30AM
11
:
00AM
3
H:
30
MM
$
4.00
f$
14.@0
R
56,700.00
20
012
SA
REN
F
7
:
30
AM
12
:
20
PM
4H
:
50
MM
$
4
.
00
'$
R
78,300
.
00
21
013
VO
LEAK
F
7
:
30AM
11
:
00
AM
A
3
H:
30
MM
$
11.00
$
38.50
R
155,925.00
22
Total
I
$
156
.
79
R._
635,006.25
23
Number
of
Employee
13
-
"=COUNT(A9
:
A21)
I
I
I
24
Number
of
Female
5
......
=COUNTIF(C9
:
C21
,"
f')
IH
"H":MM
"MM"
j=Sum(H9
:
H21)
25
Number
of
Male
8
I-
=COUNTIF(C9
:
C21
,
"M
"
)
26
Salary
>=20$/day
2
I-
=COUNTIF(H9
:
H21
,
">=20'
'
)
I
=(Hour(F9)+Minute(F9)/60)*G7
=COUNTIF(H9
:
H21
,
"<20")
27
Salary
<
20$/day
11
...
28
I
then
Press
F4
I
-
I
29
Dateif
Function:
Datedif(Start_Date,End_Date,
UJ
lit)
30
31
,....__
32
I
=F35*G31;.
I
;
4050
,___
33
"'-..
tl'e
34
No
Name
Sex
Start
Date
_
.
_
End
Date
Number
of
Days
Dailv
Rate
Mmol!nt
.
i111
$
A'mount
in
Riel
35
001
NAVY
F
01/01/00
12/31/10
4,017
Days
$
2
.
00
$"8,034
J
OO
R
32,537,700
.
00
36
002
RONG
M
01/01/09
12/31/10
729
Days
$
2
.
00
$
1,458.
J
OO
R
5
,
904,900
.
00
37
003
SAMNANG
M
12/01/08
12/31/10
760
Days
$
2
.
00
$
R6
,
156,000
.
00
38
004
SREY
SROS
F
01/25/09
12/31/10
705
Davs
$
2.00
$
1,410
i
00
R
5
,
710
,
500
.
00
39
005
KUMPHEAK
M
05/25/08
12/31/10
950
Days
$
2
.
00
$
1,900
f
00
R
7,695,000
.
00
40
006
SOKRATTNA
M
12/12/07
12/31/10
1,
115
Days
$
2
.
00
$
2
,
230
00
R
9,031,500
.
00
41
007
HATH
M
06/08/06
12/31/10
1,667
Days
$
2
.
00
$
3,334
1
00
R
13,502,700
.
00
42
008
BORA
F
05/05/08
12/31/10
970
Days
$
2
.
00
$
1,940
00
R
7,857,000.00
43
009
VEASNA
M
02/26/09
12/31/10
673
Days
$
2
.
00
$
1,346
00
R
5,451,300.00
44
010
CHOM
M
09/03/08
12/31/10
849
Days
$
2.00
$
1,698
{
00
R
6,876,900.00
45
011
SOVANN
F
02/26/09
12/31/10
673
Days
$
2
.
00
$
1,346
\
00
R
5,451,300
.
00
46
012
SOCHEATTA
F
05/24/08
12/31/10
951
Days
$
2
.
00
$
1
,
902
!
00
R
7,703
,
100
.
00
47
013
VO
LEAK
F
06/04/09
12/31/10
575
Davs
$
2
.
00
$
1,
150lOO
R
4,657,500
.
00
48
$
26.00
$
29,26&00
R
118,535,400
.
00
49
Total
Female
'
s
salary
R
63,917'
100.00
50
Total
Male's
salary
R
54,618,300.00
=Datedif(D35
E35
"D")
51
Salary
high
.
er
than
2000
$
Person
3
Or
'
'
Ł
1-........
52
Salary
less
than
2000
$
Person
10
=E35-D35
r-....
l"D"
or
"M"
or
"Y"
I
53
54

A
B
1
!----<
2
ru
.
r
4
tJ;t!flg
5
I
1
{111
am1
6
2
3El
tUlliTitl
7
3
fi
l!l
lftl
L
fi1
ft1
8
4
ms
riJamm
I
5
9
10
6
i;ri
11
7
mi;
vn
8
th
t3
I
12
runtl
n'ti:.;
v
9
13
14
1
O
I
t'Jlfis
11
I
mtl
filthm
I
n
15
16
12
I
f'JS
fUIUEl
17
13
iStl
rruiJ
18
14
I
LUEl
ns
15
I
tls
fimuritl
I
19
20
16
I
mfi
qst9J
21
17
I
tfflJtl
ffiltl
18
I
fis
flfliis
I
22
23
19
I
fit:r@u
t
24
I
20
I
rum
flfl1
I
25
26
I
27
I
28
1
fCl
D
EF
G
OJ
tc;
....
F
M
F
M
M
M
F
M
M
F
F
F
F
M
M
M
F
M
M
F
'
A
_,
I
I
\
98
92
85
99
85
65
48
68
85
45
65
48
42
58
.
35
85
86
75
95
75
75
82
45
65
56
58
55
44
48
56
85
65
55
62
15
35
42
65
-
24
25
85
95
99
85
75
I
65
85
45
75
I
85
'
12
55
'
42
';
,
,.
45
68
54
85
I
75
84
55
62
I
85
75
85
42
I
12
32
12
75
I
45
75
32
42
I
35
24
62
82
75
66
85
20
H
J
K
L
MN
0
p
Q
=MIN(D5
:
M5)
,
lflll
=MAX(D5
:
M5)
·
=SUM(D5
:
M5)
:
.
.
I
\
=AVERAGE(D5
:
M5)
I
p
L
l
'f;,
"'
<f:'-$
f
\
98
86
98
I
94
I
95
I
92
I
I
+99
1Ł937
93
.
7
54
87
68
54
85
45
45
87
659
65.9
58
75
65
24
55
65
24
85
585
58.5
46
85
45
65
85
47
35
85
593
59.3
68
54
85
65
48
65
48
95
716
71.6
55
48
75
45
65
45
82
600
60
54
55
85
65
55 55
44
85
582
58.2
45
85
75 65
42
12
12
85
578
57
.
8
42
52
42
51
42
62
15
62
458
45.8
85
24
22
15
62
42
15
85
406
40.6
95
86
75
85
75
99
75
99
879
87.9
65
45
85
75
12
I
65
12
85
617
61.7
43
25
35
62
42
I
52
12
85
486
48.6
25
45
65
45
85
I
68
25
85
542
54.2
55
75
86
32
66
I
42
32
86
655
65.5
52
62
51
50
52
I
51
50
85
625
62
.
5
14
25
35
44
55
I
61
12
61
332
33.2
52
14
25
62
42
I
52
14
75
474
47.4
42
51
12
52
65
I
44
12
65
429
42.9
65
75
65
85
75
42 42
85
715
71.5
14
t1SJffi
=RANK(Q5,Q5
:
Q24
F4
R
Ł
'i)
r1
00
'i)Q
m
5
0[)
0rn
0nl
05
[J
ct
'i:lrl
0rS
@
nl
[Jo
0e:i
0ct
rS
s
t?
i0
\°"o>
'$'
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Pass
Fail
Fail
Pass
Pass
Fail
Pass
Pass
Pass
Fail
Fatl
.
Faff
Pass
9
6
l=IF(Q5>=50
,
"Pass","Fail")
-]
11

fA
I
B
ICI
DI
El
FTGlHI
11
JI
Kl
LIMfNIOI
Pl
QI
R
i-J_
2
Students'
Name
00
4
5
I
01
IPHATBUNLAY
I
M
6
I
02
IHEOUN
KIMHO
I
F
7
I
03
!CHHUN
SONITA
I
F
8
I
04
ISIN
SREY
LOT
I
F
9
I
05
ILUY
SARY
I
F
10
I
06
ICHROCH
BORA
I
F
11
I
07
I
HEANG
V
ANNAK
I
M
12
I
08
!CHAN
SOKRATNA
I
M
13
I
09
I
CHHAN
VEASNA
I
M
14
I
10
!CHEA
CHOM
I
M
15
I
11
IORMONORETH
I
M
16
I
12
IHEN
SININ
I
F
17
13
IKEO
RONG
I
M
18
14
ISUM
SIN
I
M
19
15
INHAM
PANHA
I
M
20
16
ICHEANG
M
21
17
IPROEUNG
CHHUNd
F
22
I
18
I
SAN
SENOUDAM
I
M
23
I
19
ICHORK
HATH
I
M
24
I
20
IDON
SAREN
I
F
25
I
21
INHEB
SOVANN
I
F
26
I
22
IOEUNG
KUNTHEA
I
F
27
I
23
INAB
SAMLEY
I
F
28
24
ILANN
LEN
I
M
29
25
INEUNG
VOLEAK
I
F
30
26
ILOENG
CHANDAM
M
311
27
IMECHKOEMLAY
IM
32
I
28
ICAHN
KUMPHEAK
I
M
33
I
29
IVAN
VANNAK
I
F
34
I
30
IKIGN
SREY
SROS
I
F
35
I
JI
IVOENG
[Link]
M
36
I
32
IPHAN
BUN
NAING
I
M
37
I
33
ITHANNG
SOCHEA
11
F
38
I
34
IBRON
CHIN
I
M
39
I
35
IVAYHENG
I
M
40
I
36
ISOEUM
SREY
ROA1
F
41
I
37
IKEONAVY
I
F
42
I
38
IKHORN
SAMNANG
I
M
40
44
IN°
of
Students
36
45
IN°
of
Male
21
46
IN
°
of
Female
17
47
IN°
of
Pass
26
IN°of
Fail
10
IN°
ofVeiv
Good
Students
2
oU
IN°
of
Good
Students
4
m-
@
54
Sort
and
Condition
Formatting
"O
...
0
"'
5
7
7
as
u
.,;
6
5
5
-
i..
0
.,;
8
i
6
"'
"'
u
c.>
<
.,;
c.
0
..c:
"'
0
.....
0
..c:
7
I
"
4
1
''
I
:
4
·
4
I
8
715161418
51
'
4161518
4
I
7
I
5
I
6
I
7
8
I
5
4
I
6
5
2
1
-
-
'
4
_
1-
-
8
I
5
1
6
I
2
8
I
4
5
5
I
8
4
..
1
6
7
65
8
9
8
9
8
5
7
6
3
I
"
4
59
8
8
6
1
.
2
4
5
3
5
I
·
4
·:
8
6
3
2
I
1
5
2
5
I
6
4
I
8
I
9
3
I
2
·
f
'
I
5
1
·
4
.
...
as
...
0
u
6
8
9
6
2
8
7
6
7
5
7
8
7
8
5
6
7
3
....:l
E--
=
3
5
7
8
4
4
8
4
6
8
5
5
6
4
VI
C:
·-
ell
0
a.
I
c:
>
......
iii
:E
=
-
0
0
00
I-
5.5
144.51
3
3
I
35
I
1
6
I
52
I
4
7
I
51
I
4
6
I
40
I
2
7
I
48
I
4
2
I
45
I
2
5
I
35
I
1
7
I
45
I
2
6
I
49
I
4
8
I
56
I
5
4
52
4
4
46
3
6
43
2
4
'"
1
7
42
3
3:
I
1
23
8
9
56
4
4
6
2&
><
n:s
:a:;
n:s
c:
...
n:s
a::
<(
:::
::s
I/)
o.>
a::
c:
0
:;;
c:
o.>
:a:;
8
5.56
I
23
I
Pass
fair
8
4
.
38
IDoffFail
Weak
9
6.50
8
Pass
I
Pretj:y
Good
8
6.3&'1
12
Pass
I
Preti;)'
Good
8
28
Pass
IRair
8
[Link]
15
Pass
I
Pretjty
Good
8
5.¢31
18
Pass
Fair
8
14/381
30
Fail
1
Ł
Weak
8
I
I
18
Pass
Fair
8
I
i6.13
I
1
Pass
I
Pretcy
Good
9
1Foo1
Pass
I
Good
9
6.50
Pass
I
Prej:ty
Good
9
5.751
Y7
Pass
Fair
8
/
5
.
38
I
15
Pass
Fair
8/
5
.
25
I
(27
Pass
Fair
q
2.88
I
/37
I
·
..
Fail
!Weak
·
p
7.001
/
4
Pass
Good
/6
3.501/35
Fail
Weak
.
6
I
5
8
I
4
·
I
7
6
5
7
48
4
1
/
8
6
.
00
I/
15
I
Pass
I
Pn!tty
Good
J
I
4
5
I
1
I
.
3
5
4
2
27
I
1/
5
3
.
38
I
36
1
·Ł
Fail
I
IWeak
·
3
·
1
5
I
I
4
I
'
2
6
4
6
31
6
3
.
88A
33
I'
Fail
I
!Weak
6
I
5
8
I
4
I
7
5
9
8
52
4
9
6
.
5(jl
8
I
Pass
I
Pretty
Good
3
I
2
1
I
3
I
2
I
5
3
20
I
I
5
2.50
I
38
[Fail
I
I
Weak
314161512
4
5
30
i7
6
3
.

I
34
1
:
Fail
Weak
3
I
5
13
.
1
6
I
5
7
6
8
44
8
5.5bl
24
Pass
Fair
6
8
I
7
5
9
47
9
55
1
9
6.88
7
Pass
I
Good
4
5
r
·.
1
·
3
.
65
4
7
35
I
{1
7
4J8
I
30
Fail
Weak
..
6
5
I
'
3
5
8
5
4
3
39
I
/3
8
4
.
881
29
Fail
Weak
3
6
I
5
4
6
8
I
7
6
45
1
/
3
8
5/631
18
Pass
Fair
4
6
I
5
8
7
6
I
5
4
45
1/
4
8
I
5L63
I
18
Pass
Fair
6
8
1
·
4
7
6
5
7
6
49
I
4
8
16.131
13
Pass
I
Pietty
Good
6
5
I
4
78
6
5
4
45
/I
4
8
.63
I
18
Pass
Fair
9181517110
9
9
9
66{1
5
IO
IB
.
251
2
Pass
I
\(
ery
Good
6
I
5
1
,
4
I
8
I
7
9
76
4
9
1/6.50
I
8
Pass
I
Ftetty
Good
6
I
5
I
4
I
6
I
5
4
5
8
4p
I
4
8
25
Pass
Fair
618171918
7
8
9
I
6
9
7.75
3
Pass
Good
9
I
10
I
10
I
9
I
7
9
8
9
/71
I
7
10
/18.88
Pass
I
'If
ery
Good
618171817
5
8
7
1/56
I
5
8
7
.
00
4
Pass
I
I
Good
=RANK(05
,$
0$5
:$
0$42
,
0)
mum
I
I
=IF(05>=5
,"
Pass","Fail")
I
=RANK(o5
,
o5
:o42
Jtitjti
F4
JlltriJjM
riJBJ
I
=IF(05<5
,'
Weak"
,
IF(05<6
,"
Fair'
',
IF(05<7,
"
Pretty
Good
",I
F
(
05<=8,
"
Good"
,
IF(05>8
,
"Very
Good")))))
tlSJm:
-Point
<5
=>Weak
-Point
<6
=>Fair
-Point
<7
=>Pretty
Good

A
B
CIDIEIFIGIHI
1
IJIKILIMINIOI
P
QI
RI
s
1
Y'EAR
RESULT
·
4
f---t
No
5
,,
·
·
.
Students'
Name
'
.....
..
..
.=
.
I
-=
..
g.
·
><
.
....
Q.I
c<:
;;...
0
rn
.c
-
£
.....
-a
.;J
Ł
=
·-
V,)
1-
.
"SsJ
b1l
=
c<:
0
....
Ł
Q.I
I;/).
""
··
1
CJ
.
:a
c.
f
""
Ł,
Q.I
:"'.:''!
g
>-
E-<
·
.
i:Q
Cl)
.
c:
·-
CJ
::I
=
·:;
"'
O'
·
01
..
Cl)
Cl)
>
<
-
I
.x:
'
::I
C'IS
c
(/j
-
C'IS
Cl)
6
01
KEO
NAVY
F
90
89
97
98
95
94 96
95 95
98
89
98 94
.
70
947
7
02
PHA
T
BUNLA
Y
M
75
82 86
45
82
65
48
46
26
48
26
86
60
.
30
603
T
c:
0
;:;
c:
Cl)
·
:z:
8
I
03
IHEOUN
KIMHO
I
F
I
25
I
86
I
95
I
45
I
68
I
25
I
46
I
85
I
85
I
24
I
24
I
95158.40
I
584A
7
I
Pass
I
I
Fair
9
04
CHHUNSONITA
F
85
95
47
58
26
85
98
65
78
82
26
98
71.90
7"1'9
3
Rass
P1ettyGood
10
05
SIN
SREY
LOT
F
35
84
32
58
47
85
20
50
58
14
14
85
48
.
30
400
9
fa#
·
Weak
11
06
LUY
SARY
F
90
84
68
86
76
98
95
80
47
95
47
98
81
.
90
8i9
2
pass
Good
12
07
CHROCH
BORA
F
45
68
25
52
35
56
87
25
59
41
25
87
49
.
30
Lr93
8
/
Weak
13
08
HEANG
VANNAK
M
68
95
75
62
45
68
58
35
95
75
35
95
67
.
60
676
4
Pass
Fair
14
09
KEO
RONG
M
45
50
52
48
52
24
42
62
51
32
24
62
Weak
15
10
SUM
SIN
M
82
45
26
47
92
75
68
84
98
25
25
98
Pass
Fair
=IF
P
<50
'
Weak"
IF
P
<7
"
F
ir
"
IF
P6<80
"Prett
16
17
Number
of
Student
10
-couNT
(
AB
:
A
1
s
i
Number
ofVerv
Good
01
18
Number
of
Female
6
=COUNTIF
(
CB:C15,"F
"
)
V
Number
of
Good
01
=COUNTIF(S6
'
S15
"
Pass
"
)
19
NumberofMale
4
,
NumberofPrettvGood
01
20
Number
of
Pass
7
Number
of
Fair
4
21
Number
ofFail
03
of
Weak
3
-Po
i
nt<50
=>
"Weak
"
-
Point<70
=>
Fa
i
r
-P
oi
nt
<
BO=>
"
Prett
y
Good
-Po
i
n
t<
90
=
>
"
G
oo
d
"
-
Point
>=90
=>
"
Very
Good"
=RANK(P6,$P$6:$P$15
,
0)
tlSJffi
=RANK
(
P6
,
P6
:
P
1
5
I
Bath
'
26
IN°
llteam
I
Qty
Unit
Price
Amount
in
DollarŁ
Amount
in
Riel
!Amount
in
Bath
27
I
1
IABC
175
Cases
$
25.00
$
.
Riel
7,875,000.00l
65,625.00
..
·
''
"'::
Bath
28
I
2
ITIGER
185
Cases
$
20
.
00
$
.
1,
700.00
I
Riel
7,
140,000.00l
59,500.00
·
Ł·
·
Bath
29
I
3IANCHOR
175
Cases
$
15.00
$
1,125.00
IRiel
-
-:;
__
4,725,000.00l
39,375.00
,,_
·
Bath
30
I
4IANGKOR
142
Cases
$
18
.
00
$
756.00
I
Riel
3,
175,200.00126,460.00
Bath
31
I
51
Black
Panter
I
65
Cases
$
14
.
00
$
910.00
I
Riel
_
3,822,ooo.00131,[Link]
·
.
·
Bath
32
I
61
Bakyon
I
35
Cases
$
13
.
00
$
·
..
·
·
455.00
I
Riel
1,911,[Link]
15
,
925
,
00
:
.
\.
Bath
33
I
71
Klang
169
Cases
$
1'1
.
00
$
·
·
.
:
.
-
966.00
I
Riel
'1,057,200.0QI
33,B10.00
f.:\
..
.
..,/,1
Bath
34
I
81Singha
I
85
Cases
$
16
.
00
$
·
.
1,360.00
I
Riel
'
5,712,000.00l
47,600.00
..
-:
;i.
Bath
I
$
9,
147.00
I
Riel
Total
38,417,400.00l
320,
145.00
·
:.
Bath
CSsil34.,00
.··
..
··;
Batti
I
..
,
;c
··:·.''·
41
IN°
llteam
-
-
-
Qty
I
Unit
Price
I
Amount
in
DollarlAmount
in
Riel
..
!Amount
in
Bath
.
..Ł
42
I
1
IABC
75
Cases
I
$
25
.
00
I
$
·
·
1,875.00
17,875,000.00
.-
Riell
63,750.00
·.
:.
.
43
I
2ITIGER
85
Cases!$
20
.
00
I$
·
1,700.0017,140,000.00
TRiell57,800.00
·
..
/
,:.
-:}.)-·,>
Bath
44
3IABC
75
Cases
I
$
25
.
00
I
$
:.
·
1,875.00
17,875,000.00
·
I
Riell
45
4IANGKOR
142
Cases
I
$
19
.
00
I
$
:
13,351,600.00
I
Riell
27,
132.00
46
5IBLACK
PANTER
195
Cases
I
$
15
.
00
I
$
·
.
1
;425.00
I
5,985,000
.
00

I
Riell
48,450.00
47
6IABC
165
cases
I
$
25.
oo
L
$
I
6,825,[Link]
:
.
1
Riel
I
55,250.60
48
7IANGKOR
135
Cases!
$
19
.
00
I
s
·,.
.
[Link]
·
\2{793,000:00
·
\Riell
49
8IBLACK
PANTER
152
Cases!
$
15
.
00
I
$
-,
"
\Riell
50
9IANGKOR
175
Cases
I
$
19
.
00
I
..
1;425.00
i
I5,985;000.00
s:.
\Riell
51
10ITIGER
169
Cases!
$
20.00
!'$
;;:
...
..
1;380.00
\
\5,796,000.00
·
52
11
ITIGER
185
Casesl
$
20
.
00
l
.
7
r
t40,00Q.00
·
Fiell
;i:{
Bath
54
53
$
·
15;248.00
I
·
..
,··,:
Bath
55
Total
[Link]
.
;>,.
.
.··.
...
'-
=SUMIF(B42
:
B52,"abc",142
:
L52)
I
56
Total
amount
of
TIGER
''·
=SUMIF(B42
:
B52
,
"Tiger"
,
142
:
L52)
57
Total
amount
of
ANGKOR
Ł··.Ł.
=142*$M$37
58
Totat
·
amount
of
Black
Panter'
.
2205
;
:

=142*$S$37

-----·--·
A
B
c
D
E
F
G
H
J
K
D
nv-1
A
Ł
li
+
data
=>
Validation
=>List
Jl
e
=>at
source
Field
type
rM::EJ
Director,Manager,Staff
,
Security,Chet
,
Accounting,Marketting,Teacher
2
BUNLAY
M
I
5-Jan-91
25-Dec-08
Phnom
Penh
7
Makara
Married
Foreigner
3
KIMHO
M
l-Feb-89
14-0ct-07
Takeo
Toi
Kork
Single
Cambodia
Staff
/$
250
.
00
4
SOPHON
F
25-Aug-90
23-Jan-04
Kampong
Cham
Doun
Penh
Married
Cambodia
Staff
$
250
.
00
5
SREY
LOT
M
16-May-88
27-Nov-08
Phnom
Penh
Toi
Kork
Single
Cambodia
Security/
$
190.00
10
6
SININ
M
27-Nov-85
15-0ct-09
Abroad
Russey
Keo
Married
Cambodia
Chef/
$
200
.
00
11
7
SARY
M
5-Mar-85
25-Feb-05
Siem
Reap
Toek
La
Ork
Married
Foreigner
Account,lng
$
500.00
12
8
BORA
F
12-Jul-87
15-May-06
Kam
pot
Toek
La
Ork
Single
Foreigner
Markef{ing
$
250.00
13
9
VANNAK
M
18-0ct-92
27-Aug-08
Abroad
Toi
Kork
Single
Foreigner
C!fef
$
200
.
00
14
10
SOKRATNA
M
14-Apr-89
1-May-05
Battam
Bang
Doun
Penh
Single
Cambodia
S,laff
$
250
.
00
15
11
VEASNA
M
15-Dec-82
I
7-Jul-07
Kampong
Cham
7
Makara
Married
Cambodia
Ttacher
$
650.00
16
12
CHOM
F
29-Jan-90
28-Jun-04
Phnom
Penh
Russey
Keo
Single
Foreigner
teacher
$
650
.
00
17
13
MONO
RETH
F
24-0ct-90
6-Nov-04
Battam
Bang
Doun
Penh
Married
Cambodia
$
500
.
00
18
19
I
=IF
(
J5="director',
1
ODO
,
IF
(
J5=
"manager'
,800,
IF
(
J5=
"
Teacher
'
,
650,
IF
(
J5="Accounting"
,500
,
IF
(
J5="Marketting
"
,250,
IF
(
J5="Staff''
,250,
IF
(
J5="Chef'
,200,
IF
(
J5="Security",
190)
)))))))
24
,Female
25
Sinale
26
27
28
29
30
31
32
33
!Start
from
1-jan-07
34
35
36
37
38
39
40
41
42
43
'1
'1
45

46
47
48
2
BUNLAY
3
KIMHO
4
SOPHON
5
SREY
LOT
6
SININ
7
SARY
8
BORA
9
VANNAK
10
SOKRATNA
11
VEASNA
12
CHOM
M
M
F
M
M
M
F
M
49
13
MONORETH
I
F
50
51

of
Students
52

of
Female
53

of
Male
54

of
Pass
55

of
Fail
56

of
Poor
57

of
Fair
58

of
Medium
59

of
Pretty
Good
60

of
Good
61

of
Excellent
COUNTIF(C5
:
C17,"M")
a:OUNTIF(H5
:
H17
,"Sing
le")
=SUMIF
(
H5:H17
,"
single
",
K5:K17)
=COUNTIF(HS
:
H17,"Married")
=SUMIF
(
H5
:
H17
,"
Married
",
K5
:
K17)
=SUMIF
(
l5
:
117
,
"C
ambodia
",
K5
:
K17)
...
=SUMIF
(F
5
:
F17
,"Phno
m
Penh
",
KS
:
K17)
IN
°
of
Single
Female
IN
°
of
Single
Male
0
of
Married
Female
N
°
of
Married
Male
iN
°
ofCambodi
If
Ł
.
.
:
:
=SUMIF(l5
:
117
,"
Foreigner"
,
KS
:
K17)
-
··
=COUNTIF(E5
:
E17,
"
>=1-Jan-07")
llQ
n
·
'
=SUMIF(ES
:
E17
.">
=1
-J
an
-07",
KS
:K
17
)
/11
_
__
_
_
.
.
_
_
_
_
__
I
1;::
58
56
82
68
86
55
mirnmm
Ł

=RANK(Number,ref
,
order)
=RANK(H37
,
$H$37
:
$H$49)
m;uru
=rank(H37
,
H37
:
H49
tjti
F4)
=IF(H37<50,"Poor"
,
IF(H37<60
,"
Fair"
,
IF(H37<70,"Medium"
,
IF(H37<80
,"
Pretty
od",
IF(H37
<90
,
"Good",
IF(H37>=90
,
"Excellent"))))))
..
..

2
3
4
5
6
A
7
!Sales
Income
8
!Rental
Income
9
!Interest
Income
10
!Total
Income
11
17
INet
Revenuse
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
B
c
D
E
F
G
H
1st
Qtr
2nd
Qtr
3rd
Qtr
4th
Qtr
Maximum
Minimum
Average
$
1,452.00
$
5
,
654
.
00
$
9,857.00
$
5
,
468.00
$
9
,
857.00
$
1,452
.
00
$
5,607.75
$
4
,
526.00
$
5
,
874
.
00
$
2
,
548.00
$
6,582
.
00
$
6,582
.
00
$
2,548.00
$
4,882.50
$
4
,
256
.
00
$
4,558.00
$
6,584.00
$
6,584
.
00
$
6
,
584.00
$
4,256.00
$
5,495
.
50
$
10
,
234
.
00
$
16
,
086
.
00
$
18,989
.
00
$
18,634.00
$
18,989
.
00
$
10,234.00
$
15,985
.
75
$
546.00
$
545.00
$
654
.
00
$
965
.
00
$
965.00
$
545.00
$
677.50
$
452.00
$
698.00
$
452
.
00
$
658.00
$
698.00
$
452.00
$
565.00
$
654.00
$
985
.
00
$
654.00
$
987
.
00
$
987
.
00
$
654.00
$
820.00
$
1
,
652.00
$
2,228.00
$
1,760.00
$
2,610
.
00
$
2
,
610.00
$
1,652
.
00
$
2,062.50
$
8
,
582
.
001$
13
,
858.001$
17,229.001$
16,024.001$
17,229
.
001$
8
,
582.001$
13,923
.
25
1st
Qtr
aSales
Income
ŁRental
Income
a
Interest
Income
aTotal
Income
Ł
a
Sa
l
e
E
x
pense
ŁCommission
E
x
pense
aSupply
Expense
ŁTotal
E
x
pense
Ł
a
Net
Revenuse

A
B
Cl
D
I
E
I
F
I
G
H
Ho
Iida
=Networkdays
(
start
_
date,e
n
d_da
t
e
,
hol
i
day
'
.
'
05/
1
0/05
0
1/
10/061
05/10/07
02/15/08
tlf!MJt:H'ilffi
02
/
25
/
05
12
/
12/06
I
06/05/08
10
/
06/09
=
N
E
TW
OR
K
DA
Y
S
(
D
10
,
E10,$
F
$5
:
$
1
$6}
t113Jm
:
=
Networkdays(Dl0,El0,F5
:
16
!tiljti
F4)
31-Dec
-
10
RONG
M
1
-
Jan-09
31-Dec
-
10
SAMNANG
M
1-Dec-08
31-Dec-10
004
SREY
SROS
F
25-Jan
-
09
3
1-
Dec-
1
0
005
KUM
P
HE
AK
M
25
-
Mav
-
08
31
-
Dec-10
006
S
O
K
RATTNA
M
12-Dec
-
07
31-Dec
-
10
007
HATH
M
8
-
Jun
-
06
31-Dec
-1
0
008
BORA
F
5-Mav-08
31-Dec-10
18
19
I
foi1!Jlslll'i!:illrnnllimztu,
,
20
21
ltlllllll8hl181
m
,
lll8
hl181S'll
g\!)
g
m
ltujutytrullrnftul'i
Cursor
Data=
>
Consolidate=
>
nntu
[Link]
Sum
tti'itufitiMt;jpfJIUl9i
Select(D28
:
!33)
'll
tti'itufJtiMt;jplJi9JU!lfil'illli'l)
tti'itufiti
Add
Select(D37
:
142)
hl131S
l!J
m
tlitufJtiMmllri9JUllli1C]
ttlitu
Add
.
Select(d46
:
151)
m
ttfiUiljtiM'lfltl'i9JUH1'il'ilHJQ)
t
tfi
ru
ljti
Add=
>
OK
24
-
-
28
1
TORO
2
9
2
ABC
30
3
TIGER
3
1
4
ANGKOR
32
5
BAYON
33
6
ANCHOR
37
1
TORO
38
2
ABC
39
3
TIGER
40
4
ANGKOR
41
5
BAYON
42
6
ANCHOR
46
1
TORO
4
7
2
ABC
48
3
TIGER
49
4
ANGKOR
50
5
BAYON
51
6
ANCHOR
1
1TORO
2IABC
5
7
I
3
I
T
IGER
58
I
4IANGKOR
59
I
5IBAYON
60
I
6IANCHOR
6
1
62
c
c
c
c
c
c
c
c
c
c
c
c
c
c
c
c
c
c
10
c
3
1
122
c
60
45
c
45
75
c
66
75
c
85
95
c
7
5
55
c
445
458
c
5
7
6
443
c
345
458
c
654
466
c
466
546
c
645
456
c
46
565
c
753
346
c
846
464
c
4
,
546
4
7
c
678
462
c
65
7
c
31
c
313
c
44
c
c
85
c
48
c
65
c
c
63
c
65
c
85
c
c
46
c
85
c
76
c
c
47
c
68
c
55
c
c
26
c
47
c
85
c
c
4
,
544
c
546
c
466
c
c
566
c
544
c
742
c
c
813
c
754
c
685
c
c
248
c
654
c
648
c
c
485
c
645
c
646
c
c
46
c
31
c
645
c
c
664
c
854
c
66
c
c
565
c
655
c
6,464
c
c
4
,
654
c
646
c
85
c
c
646
c
464
c
813
c
c
645
c
646
c
328
c
c
6.448
c
646
c
46
c
3131
95'
94
41
24
65
645
554
645
544
645
46

--·-
-
-
-----
ii
A
I
B
I
c
I
D
I
E
I
F
I
G

&
1
-
3
1
2
3
4
Pro
ID
Product
Name
Unit
Price
Formular
:
Vlookup(Lookup_
Value
,
table_array
,
Col_lndex_Num
,
rang_lookup
I
5
001
ABC
R
90
,
000.00
6
002
TIGER
R
85
,
000
.
00
=VLOOKUP
(
A1
3
,
$
A
$
5
:
$C$
10
,
2
,
FALSE
)
t19Jffi:
=V
l
ookup
(
A
13
,
A5
:C
J
O
Jti
'fi
ti
F4
t
fiJ
jCUl!ltriJjM
Fa
l
se
7
003
ANGKOR
R
73
,
000
.
00
VLOOKUP
(
AJ3
,
$A$5
:
$C$10
,
2
,
FALSE
)
t19Jffi:
=
V
l
ooku
p
(
A
l
3
,
A5
:
CIO
Jti'fiti
F4
l
f'i
J
jM
ITT
lfi
JjM
Fa
l
se
8
004
ANCHOR
R
62
,
500
.
00
9
005
Black
Panter
R
50
,
00{[Link]
10
006
Bayon
R
l=D13*C13J[
=
F13*G11
F4
l
RIEL/$
EXCHANGE
RATE
11
/
R
4
,
200
-
Cl)
Cl)
Amount
No
Quantity
·
-
(.)
·
-
·-
(.)
::::::>
c:
·-
[Link]
in$
12
::::::>
c:
c:
::::::>
a.
c:
e
13
003
ANGKOR"'
50
Cases
R
73,000
.
00
$
':it
17.38
R
A
3
,
650
,
000
.
00
$
.........
869
.
05
14
001
ABC
80
Cases
R
90,000
.
00
$
21.43
R
7
,
200
,
000
.
00
$
1,714
.
29
15
003
ANGKOR
50
Cases
R
73
,
000
.
00
$
17
.
38
R
3
,
650
,
000
.
00
$
869
.
05
16
002
TIGER
30
Cases
R
85
,
000
.
00
$
20
.
24
R
2
,
550,000
.
00
$
607
.
14
17
004
ANCHOR
60
Cases
R
62
,
500
.
00
$
14
.
88
R
3
,
750
,
000.00
$
892
.
86
18
005
Black
Panter
90
Cases
R
50
,
000
.
00
$
11
.
90
R
4
,
500
,
000.00
$
1
,
071.43
19
006
Bayon
100
Cases
R
48,500
.
00
$
11
.
55
R
4
,
850,000
.
00
$
1,154.76
20
005
Black
Panter
45
Cases
R
50,000
.
00
$
11
.
90
R
2
,
250
,
000
.
00
$
535
.
71
21
003
ANGKOR
74
Cases
R
73,000.00
$
17
.
38
R
5,402
,
000
.
00
$
1
,
286
.
19
22
004
ANCHOR
63
Cases
R
62
,
500
.
00
$
14
.
88
R
3
,
937,500
.
00
$
937
.
50
23
002
TIGER
63
Cases
R
85,000
.
00
$
20
.
24
R
5
,
355,000
.
00
$
1
,
275
.
00
24
002
TIGER
624
Cases
R
85,000
.
00
$
20.24
R
53
,
040,000.00
$
12,628
.
57
25
001
ABC
65
Cases
R
90,000
.
00
$
21.43
R
5
,
850
,
000
.
00
$
1
,
392
.
86
26
005
Black
Panter
54
Cases
R
50,000
.
00
$
11.90
R
2
,
700
,
000.00
$
642.86
27
004
ANCHOR
62
Cases
R
62
,
500
.
00
$
14
.
88
R
3
,
875
,
000
.
00
$
922
.
62
LO
29
C10
D
l=D13*G11
mr;r;
F4
30
31
..
S
ub
total
rnrnril:ltmcmrnrnit31u
fi
32
33
1tititi
D
ata=
>
S
ubt
ota
l
s
1-
N
°
34
u
'
°"'
Can,;:el
I
·
36
'
---
(.)
.
-;"-.....
(.)
Cl)
Amount
No
Product
Name
Quantity
c:
·;:::::
Cl)
c:
.!!!
·;:::::
Cl)
c:
::::::>
in$
37
::::::>
a.
·-
[Link]
a.
·-
e
38
003
ANGKOR
50
Cases
R
73
,
000
.
00
$
17.38
R
3
,
650
,
000
.
00
869
.
05
39
001
ABC
80
Cases
R
90,000
.
00
$
21.43
R
7
,
200
,
000
.
00
$
1,714
.
29
40
003
ANGKOR
50
Cases
R
73
,
000
.
00
$
17.38
R
3,650
,
000
.
00
$
869
.
05
41
002
TIGER
30
Cases
R
85
,
000
.
00
$
.
20
.
24
R
2
,
550
,
000
.
00
$
607
.
14
42
004
ANCHOR
60
Cases
R
62,500
.
00
$
14
.
88
R
3,750,000
.
00
$
892
.
86
43
005
Black
Panter
90
Cases
R
50
,
000
.
00
$
11
.
90
R
4
,
500,000
.
00
$
1
,
07
1
.43
44
006
Bayon
100
Cases
R
48,500.00
$
11
.
55
R
4
,
850,000
.
00
$
1
,
154
.
76
45
005
·
Black
Panter
45
Cases
R
50
,
000
.
00
$
11
.
90
R
2
,
250,000
.
00
$
535
.
71
46
003
ANGKOR
74
Cases
R
73,000
.
00
$
17
.
38
R
5,402
,
000
.
00
$
1
,
286
.
19
47
004
ANCHOR
63
Cases
R
62
,
500.00
$
14
.
88
R
3
,
937
,
500
.
00
$
937
.
50
48
002
TIGER
63
Cases
R
85
,
000
.
00
$
20.24
R
5
,
355,000
.
00
$
1
,
275.00
49
002
TIGER
624
Cases
R
85
,
000
.
00
$
20.24
R
53
,
040
,
000
.
00
$
12
,
628
.
57
50
001
ABC
65
Cases
R
90
,
000
.
00
'
$
21.43
R
5
,
850
,
000.00
$
1
,
392.86
51
005
Black
Panter
54
Cases
R
50
,
000
.
00
$
11.90
R
2
,
700
,
000
.
00
$
642
.
86
52
004
ANCHOR
62
Cases
R
62
,
500
.
00
$
14
.
88
R
3
,
875
,
000.00
$
922
.
62
53

,,;......_;
.....
.-
.
...
A
B
c
DE
F
G
1
2
,_____
3
4
Pro
ID
Product
Name
Unit
Price
5
001
ABC
R
90,000
.
00
6
002
TIGER
R
85
,
000
.
00
7
003
ANGKOR
R
73
,
000
.
00
8
004
ANCHOR
R62
,
500
.
00
9
005
Black
Panter
R
50
,
000
.
00
10
006
Bayon
R
48
,
500.00
EXCHANGE
RA
TE
11
RIEL/$
R
4
,
200
......
a.>
Q)
Amount
Amount
No
Product
Name
Quantity
·
-
u
·
-
c
·-
O:::
·
c
·
-
in
Riel
in$
12
::::>
Cl.
.
5
::::>
Cl.
c
13
001
ABC
50
R
90
,
000
.
00
$
21.43
R
4
,
500
,
000
.
00
$
1,071.43
14
001
ABC
80
R
90
,
000
.
00
$
21.43
R
7,200
,
000
.
00
$1
,
714
.
29
15
002
TIGER
50
R
85
,
000.00
$
20
.
24
R
4
,
250
,
000
.
00
$1
,
011
.
90
16
002
TIGER
30
R
85
,
000
.
00
$
20
.
24
R
2
,
550
,
000
.
00
$
607
.
14
17
002
TIGER
60
R
85,000
.
00
$
20
.
24
R
5
,
100
,
000.00
$
1
,
214
.
29
18
003
ANGKOR
90
R
73
,
000
.
00
$
17
.
38
R
6
,
570,000.00
$
1,564
.
29
1
9
003
ANGKOR
100
R
73,000
.
00
$
17
.
38
R
7,300
,
000.00
$
1
,
738
.
10
20
003
ANGKOR
45
R
73
,
000
.
00
$
17
.
38
R
3,285
,
000.00
$
782
.
14
21
004
ANCHOR
74
R
62
,
500
.
00
$
14
.
88
R
4
,
625,000
.
00
$
1,101.19
22
004
ANCHOR
63
R
62
,
500
.
00
$
14
.
88
R3
,
937,500.00
$
937
.
50
23
004
ANCHOR
63
R
62
,
500
.
00
$
14
.
88
R3
,
937
,
500
.
00
$
937
.
50
24
004
ANCHOR
624
R
62,500
.
00
$
14
.
88
R
39
,
000
,
000
.
00
$9
,
285
.
71
25
005
Black
Panter
65
R
50
,
000
.
00
$
11
.
90
R
3
,
250
,
000
.
00
$
773
.
81
26
005
Black
Panter
65
R
50,000
.
00
$
11
.
90
R
3
,
250
,
000
.
00
$
773
.
81
27
005
Black
Panter
35
R
50
,
000
.
00
$
11
.
90
R
1
,
750
,
000
.
00
$
416
.
67
28
005
Black
Panter
63
R
50
,
000
.
00
$
11
.
90
R3
,
150
,
000
.
00
$
750
.
00
29
006
Bayon
622
R
48
,
500
.
00
$
11
.
55
R
30
,
167
,
000
.
00
$
7
,
182
.
62

A
B
---
1
-
1
6
PT
2
3
4
5
6
7
8
10
I
002
IRONG
11
I
003
I
SAMNANG
12
I
004
I
SREY
SROS
131005
IKUMPHEAK
141006
ISOKRATTNA
151007
IHATH
161008
IBORA
17
I
009
I
VEASNA
181010
ICHOM
191011
IPOUCHAY
20
I
012
ISOVANN
21I013
ISOCHEATTA
221014
ISAREN
23
I
015
IVO
L
EAK
24
25
!Number
of
Students
26
!Number
of
Male
27
!Number
of
Female
28
!Number
of
Pass
29
!Number
of
Fail
30
31
321
Design
=4
PT
c
D
E
F
G
H
J
K
L
M
8
PT
8
PT
8
PT
17
PT
17
PT
,
sex
F
M
I
25
46
54
21
35
M
I
65
58
54
98
45
F
I
95
42
54
82
48
M
I
47
78
93
75
84
M
I
98
58
73
85
67
M
I
45
85
65
87
98
F
I
85
56
54
82
35
M
I
24
56
24
62
42
M
I
42
35
45
65
42
M
I
43
62
45
84
56
F
I
45
65
85
95
54
F
I
98
95
99
78
98
F
I
42
65
25
42
65
F
I
45
68
54
21
35
4
PT
-tinni:-
eiO
=
>
P
ass
"'
""
I
7
PT
(
FlmmthtlriO
)
=>
Fa
il
Gt
ru
Gt
tJ
I
l
7
PT
7
PT
®
7
PT

Al
B
F
G
---'
'
-
2
3
Employee
List
4
NO
Name
Sex
,
Qate
of
Birth
Place
of
Birth
Pos
i
tion
Salary
5
0
1
KEO
NAVY
F
20-Jan
-
91
Siem
Reap
Director
$
800.00
6
02
KEO
RONG
M
01
-
Nov
-
83
Phnom
Penh
Staff
$
200
.
00
7
03
SAMNANG
M
03
-
0ct-88
Takeo
Staff
$
200
.
00
8
04
SREY
SROS
F
02-Jun-93
Siem
Reap
Assisant
$
250
.
00
9
05
KUMPHEAK
M
1
3-Feb-87
Kampong
Cham
Supervisor
$
300
.
00
10
06
SOKRATTNA
M
15
-
0ct
-
82
Kampong
thorn
Manger
$
600
.
00
11
07
CHORKHATH
M
1
5
-
Jun
-
86
Korn
pot
Security
$
120.00
12
08
CHROCHBORA
F
1
O
-
Aug
-
88
Kampong
Cham
Staff
$
200.00
13
09
CHHAN
VEASNA
M
19-Nov
-
84
Takeo
Security
$
1
20
.
00
14
1
0
CHEACHOM
M
11-Nov-91
Prey
Veng
Saller
$
160
.
00
15
11
POUC
H
AY
M
04-Apr
-
91
Phnom
Penh
Cleaner
$
100
.
00
16
12
N
H
EBSO
V
ANN
F
03
-
Jun-90
Kanda
I
Accountant
$
500
.
00
17
13
SOCHEA
TT
A
F
1
O
-
Feb-89
Kanda
I
Advisor
$
400
.
00
18
14
DONSAREN
F
06
-
Mar-86
Svay
Reang
Cleaner
$
1
OD
.
OD
19
15
NEUNG
VOLEAK
F
12-Sep-91
Takeo
Clerk
$
160
.
00
20
1
6
BRON
CHIN
M
1
5-Mar
-
87
Korn
pot
Staff
$
200.00
21
1
7
P
HAN
BUN
NAING
M
05-0ct-88
Kampong
Cham
Staff
$
200
.
00
22
18
PHATBUN
L
AY
M
02
-
Apr
-
88
Phnom
Penh
Saller
$
160
.
00
23
19
CH
H
UN
G
F
12
-
Jul-87
Kanda
I
Sa
ll
er
$
160
.
00
20
PHEN
S
AMON
M
13-09-90
Svay
Reanci
Staff
$
200
.
00
25
R
It
Aft

tT
hi
·;;,,
";
:
......
-",
1¥0
..
...
,
..
.
..
a
.
::
.
,
e
26
j
I
Place
of
Birth
I
Kam
pong
Cham
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Sum
of
Salary
Position
Name
Staff
CHROCH
BORA
KUMPHEAK
PHAN
BUN
NAING
Grand
Total
i-·
-
----------··--·-
-----,
!
+How
to
use
Pivot
table
I
-
Select
whole
table
1
-
Click
on
Insert
Menu
-
Click
on
Pivot
table
-
-
.
·-
·-·-·-

···-
200
200
400
I
.
.
.
·
..
Insert
l
Page
46
I
Supervisor
300
300
:
........
1
Grand
Total
200
300
200
700
{1x
471
Table
481
1
Pi
:
cture
Cltp
Shapes
Sma
.
rtArt
S:creenshot
;
Col1rnu1
li
.
ne
Art
Ł
.
"'
i
49
Tables
[Link]
"1"""T
50
l
Pie
Bar
Are<1
Scat
Cha
·
tts

A
8
c
DE
I
F
G
H
I
J
K
L
M
1
-
2
-
3
-
4
-
5
-
6
-
1=112
·
J12
I
7
-
8
'
-
9
10
Price
votal
DISCOUNT
-
No
FIRST
NAME
LAST
NAME
SEX
COUNTRY
ROOM
NO
DATE
IN
DATE
OUT
TOTAL
DAYS
Before
2%Up
30days
TOTAL
US$
Per
Day
iscount
11
12
1
MAHA
YATO
M
JAPAN
20
01/Jan/05
04/Feb/05
34
fc
Days
$
5
.
00
$
170
.
00
fc
3.40
$
166
.
60
13
2
YIN
BONI
CA
F
THAI
30
01/Feb/05
01/Mar/05
28/
Days
$
5.00
$
140
.
00
I
0
.
00
${
140.00
14
3
DAVID
ROY
M
AMERICA
52
03/Jan/05
05/Feb/05
3i
Days
$
5
.
00
$
165
.
00
I
3
.
30
$
161.70
15
4
GOGE
WOLLIM
F
AUSTRALIA
11
04/Jan/05
04/Feb/05
Days
$
5.00
$
155
.
00
I
3.10
/$
151
.
90
16
5
BONE
PONG
M
SPAIN
14
28/Mar/05
15/Apr/05
18
Days
$
5
.
00
$
90
.
00
If
0
.
00
$
90
.
00
17
6
KHHAN
NYTO
M
JAPAN
13
05/Mar/05
1
O/Mar/0/J
5
Days
$
5
.
00
$
25
.
00/
$
25
.
00
18
7
DANY
HAK
M
THAI
15
05/Feb/05
20/Mar/¢5
43
Days
$
5
.
00
$
215
.

4
.
:10
$
210.70
19
8
BLACK
JHOCH
F
AMERICA
18
08/Mar/05
09/DeQ705
276
Days
$
5
.
00
27
/30
$
1,352.40
20
9
NESTER
ROY
M
AUSTRALIA
42
09/Jan/05
20/M¢r/05
70
Days
$
5
.
00
$
[Link]
7/
.
00
$
343
.
00
21
10
WAP
SAK
M
AUSTRALIA
23
10/Mar/05
15/f/.pr/05
36
Days
$
5
.
00
$
18,0.00
/3
.
60
$
176.40
22
11
SICO
MA
M
SPAIN
26
11/Apr/05
19/f./lay/05
38
Days
$
5
.
00
$
1,l!0.00
/3
.
80
$
186
.
20
23
12
MALAM
OM
F
JAPAN
42
12/May/05
2Q?May/05
8
Days
$
5
.
00
$
/40
.
00
I
o
.
oo
$
40.00
24
13
SOKA
TO
F
THAI
12
13/Feb/05
44/Mar/05
39
Days
$
5.00
$
/195.00
I
3
.
90
$
191
.
10
25
14
CASW
ORA
M
AMERICA
23
12/Mar/05
;23/Mar/05
11
Days
$
5.00
$/
55
.
00
I
0
.
00
$
55
.
00
26
I
I
I
-
27
l=DATEDIF(G12,H12,"D")
I
=IF(l
12>=30,J12*2%
,
0)
I
j=K12-L
12
I
,....___
28

I
A
B
I
c
DEF
G
H
I
J
KL
MN
1
-
.'
IN!
IMrRRT
.,
'
'i
2
Employee
Numof
Monthly
Increase
EmployeelD
Sex
Date
of
Birth
Age
Start
Work
Address
Position
Reiter
Emp
Term
Salary
less
Net
Salary
3
Name
Year
Salary
than
200
4
Emp
001
KEO
NAVY
F
23-Dec-30
84
Years
23-Dec-05
9
Years
Siem
Reap
Manager
$
800
.
00
5
Year
$
-
$
805
.
00
5
Emp
002
KEO
RONG
M
1
O-Jan-88
27
Years
10-Jan-07
8
Years
Kampong
Thom
Supe-viser
Not
Yet
$
400
.
00
3
Year
$
-
$
403
.
00
6
Emp
003
SAMNANG
M
30-Mar-89
26
Years
30-Mar-04
11
Years
Takeo
Teacher
Not
Yet
$
350
.
00
4
Year
$
-
$
354.00
7
Emp
004
SREY
SROS
F
15-Feb-90
25
Years
15-Feb-06
9
Years
Svay
Reang
It
Manager
Not
Yet
$
500
.
00
3
Year
$
-
$
503.00
8
Emp
005
KUMPHEAK
M
7-Nov-87
27
Years
7-Nov-08
6
Years
Kam
pot
Gerneral
Clerk
Not
Yet
$
200
.
00
4
Year
$
-
$
204
.
00
9
Emp
006
SOKRATINA
M
31-Dec-91
23
Years
31-Dec-08
6
Years
Battam
Bang
Accountant
Not
Yet
$
300
.
00
2
Year
$
-
$
302.00
10
Emp
007
CHORKHATH
M
24-May-88
27
Years
24-May-02
13
Years
Koh
Kong
Sale
Not
Yet
$
100.00
2
Year
$
10.00
$
112.00
11
Emp
008
CHROCHBORA
F
10-Jul-93
22
Years
10-Jul-06
9
Years
Kanda
I
Cleaner
Not
Yet
$
80.00
3
Year
$
9.60
$
92
.
60
12
Emp
009
CHHAN
VEASNA
M
20-Apr-87
28
Years
20-Apr--05
10
Years
Siem
Reap
Secu
r
ity
Not
Yet
$
90
.
00
1
Year
$
9.00
$
100
.
00
13
Emp
010
CHEACHOM
M
23-Aug-89
26
Years
23-Aug-09
6
Years
Prey
Veng
Drive·
Not
Yet
$
150
.
00
1
Year
$
15
.
00
$
166
.
00
14
Emp
011
POUCHAY
M
4-Sep-91
24
Years
4-Sep-08
7
Years
Kampong
Cham
Security
Not
Yet
$
90
.
00
1
Year
$
9.00
$
100
.
00
15
Emp
012
NHEBSOVANN
F
15-0ct-90
24
Years
15-0ct--04
10
Years
Banteay
Mean
Chey
Accountant
Not
Yet
$
300
.
00
2
Year
$
-
$
302.00
16
Emp
013
SOCHEATTA
F
25-Jun-88
27
Years
25-Jun--03
12
Years
Kampong
Chnang
Marketing
Manager
Not
Yet
$
500
.
00
1
Year
$
-
$
501
.
00
17
Emp
014
DONSAREN
F
25-0ct-90
24
Years
25-0ct--04
10
Years
Pou
Sat
Sale
Manager
Not
Yet
$
500
.
00
1
Year
$
-
$
501.00

M
A
I
B
I
c
I
D
I
E
I
F
I
G
w
t:$
2
H
J
K
L
t:$
3
4
5
-
6
tJninju
Data
Column
Rank
NAVY
10
I
002
!RONG
11
I
003
I
SAMNANG
12
I
004
I
SREY
SROS
F
54
82
13
I
005
IKUMPHEAK
M
98
75
14
I
006
ISOKRAT1NA
M
79
85
151
007
IHATH
M
65
87
16
I
008
!BORA
F
17
I
009
IVEASNA
M
18
I
010
ICHOM
M
191
011
IPOUCHAY
M
20
I
012
ISOVANN
F
21
I
013
ISOCHEATTA
F
221
014
ISAREN
F
23
I
015
IVOLEAK
F
24
25
!Number
of
Students
Ł
Ł
a
o
a
oJ
-mun:-
rlStithtlnMr
=>
Pass
"'
...
I
26
!Number
of
Male
tlturlt98ITTfl
=>
Fail
&
ru
c:.
u
I
I
27
!Number
of
Female
28
!Number
of
Pass
29
!Number
of
Fail
30

You might also like