modul microsoft excel 2007

7/17/2019 Modul Microsoft Excel 2007

http://slidepdf.com/reader/full/modul-microsoft-excel-2007-568c7b306198e 1/48

[Type the document title] [Year]2014

Modul PraktikumAplikasi Pengolahan

Angka

DEDY ISWANTO, ST, !!

PROGRAM KEAHLIA !EKOLOGII"ORMA#I $I%ER#I!A#



"#$%ti%um Apli%$&i "en'ol$h$n An'%$

M$HAMMA*IYAH MA!ARAM &'()

2




KataPengantar

"u(i &yu%u# %$mi p$n($t%$n %eh$di#$t Tuh$n Y$n' !$h$ E&$ $t$&

%$#uni$ d$n hid$y$hny$, &ehin''$ !odul "#$%ti%um Apli%$&i

"e#%$nto#$n )o%$&i *ni+e#&it$& !uh$mm$diy$h !$l$n' d$p$t

diu(ud%$n

!odul "#$%ti%um ini di#$nc$n' untu% mem-u$t m$h$&i&$

men'e#ti pen''un$$n -e#-$'$i $pli%$&i $t$u &o.t$#e y$n' &e#in'

di'un$%$n di duni$ %e#($ !odul p#$%ti%um ini dih$#$p%$n m$mpu

di($di%$n pend$mpin' d$l$m mend$l$mi -e#-$'$i $pli%$&i y$n' &e#in'

di'un$%$n di duni$ IT p$d$ %hu&u&ny$A%hi#ny$ den'$n ini %$mi men'h$#$p%$n /u%u "edom$n ini

d$p$t di($di%$n petun(u% d$n dipe#'un$%$n den'$n &e-$i%-$i%ny$

"enuli& $%$n den'$n &en$n' h$ti mene#im$ $p$-il$ te#d$p$t %#iti% d$n

&$#$n y$n' -e#&i.$t mem-$n'un p$d$ modul p#$%ti%um !ic#o&o.t Ecel

200 ini

2



+

3$t$ &'(

*a,tarIsi

3$t$ "en'$nt$#

2

D$.t$# I&i

"#$%ti%um

5

1 6udul

"#$%ti%um

5

2 "e#$l$t$n 7 /$h$n 5

Tu(u$n

"#$%ti%um

5

4 8e.e#en&i

5

9 :$&il 7 %ompeten&i y$n' dih$#$p%$n ;

5

5 D$&$# Teo#i 5

51 !en'en$l !ic#o&o.t Ecel

200 5

52 !emind$h%$n "enun(u% Sel <=ell

"ointe#> 5

5 !en''un$%$n ?$&ilit$& Auto=omplete

54 8$n'e

59 Sim-ol&im-ol p$d$ !ic#o&o.t

Ecel

"#o&edu# "el$%&$n$$n

@

1 "en''un$$n ?un'&i "$&te d$n "$&te

Speci$l @

2 "en''un$$n ?un'&i

Te%& @

"en''un$$n Auto.ill

4 "en''un$$n

AutoSum 10

9 "en''un$$n ?un'&i I?




10

5 "en''un$$n ?un'&i =O*NTI?

11

"en''un$$n ?un'&i S*!I?

12

@ "en''un$$n ?un'&i=O*NTA 12

"en''un$$n ?un'&i Boo%up d$n

8e.e#en&i 12

10 "en''un$$n C#$.i% d$n Di$'#$m

14

@ B$tih$n So$l

19

DA?TA8 "*STA3A

4




Tom-ol 3ete#$n'$Alt : *ntu% men'$%ti.%$n !enu :ome

Alt N *ntu% men'$%ti.%$n !enu In&e#t

Alt " *ntu% men'$%ti.%$n !enu "$'e B$yout

Alt ! *ntu% men'$%ti.%$n !enu ?o#mul$&

Alt A *ntu% men'$%ti.%$n !enu D$t$

Alt 8 *ntu% men'$%ti.%$n !enu 8e+ie-

(.(. /udul Praktikum

"#$%ti%um Apli%$&i "en'ol$h An'%$

(.&. Peralatan 0 1ahan1 !ic#o&o.t O..ice Ecel 2002 !ic#o&o.t O..ice Ecel 200

Open O..ice =$lco#'

(.+. !u2uan Praktikum!em-e#i%$n pem$h$m$n %ep$d$ m$h$&i&$ tent$n' -$'$im$n$

pen''un$$n

!ic#o&o.t Ecel &e-$'$i $pli%$&i pen'ol$h $n'%$

(.). Re,erensi

1 3u#ni$$n,Y$hy$200/el$($# Sendi#i ; !ic#o&o.t O..ice Ecel 200 6$%$#t$;"T Ele

!edi$

3omputindo2 C,8$tn$200 /el$($# =ep$t !ic#o&o.t Ecel 200Yo'y$%$#t$;=) Andi O..&et :$di "u#nomo,=$tu#2010 "$ndu$n /el$($# Otodid$% !S Ecel2006$%$#t$;!edi$3it$

(.-. Hasil 0 kompetensi 3ang diharapkan 41 !$h$&i&$ m$mpu memp#$%te%%$n pen''un$$n .un'&i "$&te d$n "$&teSpeci$l2 !$h$&i&$ m$mpu memp#$%te%%$n pen''un$$n .un'&i Te%& !$h$&i&$ m$mpu memp#$%te%%$n pen''un$$n I?, =O*NTI?, S*!I?, =O*NTA4 !$h$&i&$ m$mpu memp#$%te%%$n pen''un$$n BOO3*" d$n 8e.e#en&i9 !$h$&i&$ m$mpu memp#$%te%%$n pen''un$$n .un'&i Auto?ill d$n AutoSum

5 !$h$&i&$ m$mpu memp#$%te%%$n pen''un$$n Di$'#$m 7 C#$.i% <=h$#t>

(.5. *asar !eori!ic#o&o.t Ecel $t$u !ic#o&o.t O..ice Ecel me#up$%$n &$l$h &$tu p$%et

p#o'#$m pen'ol$h $n'%$ <&p#e$d&heed> y$n' p$lin' popule# d$n &$n'$t mud$hdi'un$%$n untu% menyele&$i%$n pe%e#($$n y$n' -e#hu-un'$n den'$n $n'%$$n'%$ Apli%$&i ini di-u$t oleh !ic#o&o.t =o#po#$tion untu% &i&tem ope#$&i!ic#o&o.t Windo& d$n !$c OS ?un'&i ut$m$ d$#i !ic#o&o.t Ecel $d$l$hmen'ol$h d$t$ "en'ol$h$n d$t$ y$n' dim$%&ud di&ini $d$l$h meliputipe#hitun'$n d$&$#, pen''un$$n .un'&i.un'&i, d$n pem-u$t$n '#$.i%

Ecel di'un$%$n umumny$ untu% mem-$ntu untu% menyele&$i%$npe#m$&$l$h$n y$n' -e#hu-un'$n den'$n pe#hitun'$n d$t$, mul$i y$n' p$lin'&ede#n$h$ &$mp$i y$n' le-ih %omple%& =ontoh pe#m$&$l$h$n y$n' d$p$tdi&ele&$i%$n oleh !oc#o&o.t Ecel $d$l$h d$.t$#nil$i &i&$ "e#m$&$l$h$n ini &e-en$#ny$ d$p$t (u'$ di&ele&$i%$n men''un$%$n!ic#o&o.tWo#d %$#en$ h$ny$ &edi%it meme#lu%$n p#o&e& pe#hitun'$n, tet$pi le-ih mud$hdi&ele&$i%$n den'$n !ic#o&o.t Ecel

(.5.(. Memindahkan Penun2uk #el 67ell Pointer8 Tom-ol %ey-o$#d d$p$t di'un$%$n &e-$'$i pen''$nti mou&e Tom-oltom-ol

ini d$p$t mempe#cep$t %ine#($ u&e# d$l$m men''un$%$n !ic#o&o.t Ecel41 Tom-ol 3e-o$#d untu% men'$%ti.%$n

!enu T$-




Alt W *ntu% men'$%ti.%$n !enu )ie

42 Tom-ol %ey-o$#d d$l$m memind$h%$n po&i&i Sel "ointe#

Tom-ol 3ete#$n'$

Ente# "ind$h &$tu &el %e -$$h

:ome "ind$h %e %olom A p$d$ po&i&i -$#i& y$n' $%ti.

=t#l :ome "ind$h %e &el A1 p$d$ lem-$# %e#($ y$n' $%ti.

=t#l End "ind$h %e po&i&i &el te#$%hi# y$n' &ed$n'

"'*p "ind$h &$tu l$ye# %e $t$&

"'Dn "ind$h &$tu l$ye# %e -$$h

Alt "'*p "ind$h &$tu l$ye# %e %i#i

Alt "'Dn "ind$h &$tu l$ye# %e %$n$n

=t#l "'*p "ind$h d$#i &$tu t$- lem-$# %e#($ %e t$- lem-$#%e#($ -e#i%utny$

=t#l "'Dn "ind$h d$#i &$tu t$- lem-$# %e#($ %e t$- lem-$#%e#($ &e-elumny$

(.5.&. Menggunakan "asilitas Auto7omplete!ic#o&o.t Ecel 200 menyedi$%$n &$l$h &$tu .itu# y$n' di-e#i n$m$

Auto=omplete Den'$n .$&ilit$& ini %eti%$ And$ men'eti%%$n -e-e#$p$ %$#$%te#$$l d$#i d$t$, Ecel 200 &ec$#$ otom$ti& $%$n melen'%$pi %$#$%te# y$n' And$%eti%%$n den'$n %$#$%te# &el$n(utny$ 'un$ melen'%$pi d$t$ !i&$l%$n p$d$%olom A And$ &ud$h men'eti%%$n n$m$ -$'i$n, &epe#ti "endidi%$n,"en'$l$m$n, "en'$m$n$n 3emudi$n di -$#i& y$n' -e#-ed$ tet$pi p$d$ %olomy$n' &$m$, $p$-il$ And$ in'in menuli&%$n %$t$ "endidi%$n, And$ h$ny$ tin''$lmenuli&%$n "end, %$#$%te# -e#i%utny$ $%$n otom$ti& dilen'%$pi oleh Ecel 200

Auto=omplete

(.5.+. Range8$n'e $d$l$h &e%umpul$n &el y$n' -e#&e-el$h$n 8$n'e din$m$%$n

menu#ut $l$m$t &el di u(un' %i#i $t$& &$mp$i u(un' %$n$n -$$h !i&$lny$&e%umpul$n &el y$n' te#'$-un' d$#i A1 &$mp$i =10 , diny$t$%$n den'$n <A1;=10>

/e#-$'$i p#o&e& d$p$t dil$%u%$n p$d$ &u$tu #$n'e "$d$ umumny$ untu%memp#o&e& &u$tu #$n'e And$ pe#lu te#le-ih d$hulu meny$t$%$n $t$u menyo#ot#$n'e te#&e-ut

(.5.). #im9ol:sim9ol pada Mi;roso,t E<;el Te#d$p$t -e-e#$p$ &im-ol y$n' &e#in' di'un$%$n $d$ !ic#o&o.t Ecel d$l$m

menuli&%$n &u$tu .un'&i Sim-ol&im-ol te#&e-ut di$nt$#$ny$ ;

5




=

Sim-ol N$m$ Sim-ol "en''un$

T$m-$h *ntu% mel$%u%$n ope#$&i

3u#$n' *ntu% mel$%u%$n ope#$&i

3$li *ntu% mel$%u%$n ope#$&i pe#%$li$n




7 /$'i *ntu% mel$%u%$n ope#$&i

F "$n'%$t *ntu% mel$%u%$n ope#$&i

G S$m$ den'$n *ntu% men'$$li penuli&$n &u$tu

H Titi% %om$ Se-$'$i pem-$t$& $nt$##umu&

(.=. Prosedur Pelaksanaan(.=.(. Penggunaan "ungsi !eks

?un'&i ini di%hu&u&%$n untu% mem$nipul$&i (eni& d$t$ &t#in' Ad$ -e-e#$p$model d$#i (eni& .un'&i te%& ini, $nt$#$ l$in;$ ?un'&i Be.t

?un'&i ini di'un$%$n untu% men'$m-il &e(uml$h %$#$%te# d$#i&e-el$h %i#i Ad$pun c$#$ penuli&$n .un'&i ini $d$l$h;

>LE"!6teks?p8

3ete#$n'$n ;

te%& ; /e#up$ %umpul$n %$#$%te#p ; /$ny$%ny$ (uml$h %$#$%te# y$n' di$m-il d$#i Te%& d$#i&e-el$h %i#i =ontoh ;!i&$l%$n te%& ny$ -e#up$ %$t$ Su#$m$du d$n dimint$ men'$m-il hu#u. d$#i%i#i

- ?un'&i 8i'ht?un'&i #i'ht di'un$%$n men'$m-il &e(uml$h %$#$%te# te#tentu d$#i&e-el$h %$n$n Ad$pun c$#$ penuli&$n .un'&i ini $d$l$h;

>RIGH!6teks?p8

3ete#$n'$n ;te%& ; /e#up$ %umpul$n %$#$%te#p ; /$ny$%ny$ (uml$h %$#$%te# y$n' di$m-il d$#i Te%& d$#i&e-el$h %i#i =ontoh ;!i&$l%$n te%& ny$ -e#up$ %$t$ Su#$m$du d$n dimint$ men'$m-il hu#u. d$#i%$n$n

c ?un'&i !id?un'&i mid di'un$%$n men'$m-il &e(uml$h %$#$%te# te#tentu d$#i&e-el$h %$n$n Ad$pun c$#$ penuli&$n .un'&i ini $d$l$h;

>MI*6teks?p?@8

te%& ; /e#up$ %umpul$n %$#$%te#p ; u#ut$n $$l pen'$m-il$n %$#$%te#

; -$ny$%ny$ (uml$h %$#$%te# y$n' di$m-il d$#i te%& di mul$i %$#$%te#

%ep=ontoh ;!i&$l%$n te%& ny$ -e#up$ %$t$ Su#$m$du d$n dimint$ men'$m-il hu#u.d$#i %$n$n &e(uml$h 2 hu#u.

@




(.=.&. Penggunaan Auto,illDi'un$%$n &epe#ti penomo#$n -$#i& $t$u %olom ?$&ilit$& Auto?ill d$#i Ecel

memun'%in%$n untu% mem$&u%%$n &e#i d$t$ y$n' tel$h dide.eni&i%$n&e-elumny$ den'$n cep$t, &epe#ti t$n''$l, te%& $t$u $n'%$ *ntu%mem$&u%%$n d$t$ -e#up$ $n'%$ $t$u te%&den'$n .$&ilit$& Auto?ill, d$p$t dil$%u%$n den'$n men'i%uti l$n'%$hl$n'%$h-e#i%ut ini ;

1 "ilih &el temp$t po&i&i $$l d$#i #$n'%$i$n d$t$ y$n' in'in di-u$t !i&$lny$pilih &el

A22 3eti% d$t$ $$l y$n' diin'in%$n !i&$lny$ te%& J6$nK <6$nu$#y>

"$d$ &el -e#i%utny$ <&el di-$$h7A> %eti% d$t$ -e#i%utny$ y$n' di in'in%$n!i&$lny$ di A %eti% J?e-K <?e-#u$#y>

!uliskan dua 9ulan aBal

4 So#ot7-lo%l$h A2;A9 D$l$m %e$d$$n m$&ih te#&o#ot, $#$h%$n penun(u%7pointe# mou&e %e

po(o% %$n$n -$$h &el A hin''$ t$nd$ plu& putih -e#u-$h men($diplu& hit$m5 Te%$nl$h tom-ol %i#i mou&e d$n 'e&e#7d#$' po&i&i pointe# mou&e %e

&el y$n' diin'in%$n mi&$lny$ A1 Den'$n ini #$n'%$i$n d$t$ -ul$nd$p$t dit$mpil%$n

Hasil Akhir

menggunaka

n autoCll

Ap$-il$ &e#i $uto.ill y$n' diin'in%$n -elum di&edi$%$n oleh !ic#o&o.t Ecelm$%$ d$p$t dit$m-$h%$n &endi#i den'$n c$#$ ;

1 Te%$n O..ice /utton %emudi$n pilih "oe# "oint Optiont2 3li% p$d$ t$- "opul$# l$lu %li% tom-ol Edit =u&tom Bi&t I&i li&t y$n' -$#u, !i&$l%$n Senin, Sel$&$, 8$-u dll4 3emudi$n 3li% tom-ol Add d$n (i%$ &ud$h &ele&$i %li% tom-ol O3




#eri AutoCll 9aru

9erupa nama

hari dalam satu

minggu

10



"ungsi Kegunaa Penulisa

I?<&$tulo'i%$>

*ntu% men'h$&il%$n nil$i d$#i&$tu lo'i%$ y$n' diu(i%e-en$#$ny$

GI?<lo'ic$lLte&t,+$lueLi.Lt#ue,+$lue Li. L.$l&e>

I?<le-ihd$#i &$tu

*ntu% men'h$&il%$n nil$i d$#ile-ih d$#i &$tu lo'i%$ y$n' diu(i%e-en$#$ny$

GI?<lo'ic$lLte&t1,+$lueLi.Lt#ue,I?<lo'ic$lLte&t1,+$lueLi.Lt#ue+$lueLi.L.$l

I? O8 ?un'&i ini men'h$&il%$n nil$i

-en$#, -il$ -e#$#'umen-en$# :$&il d$#i .un'&i ini (u'$d$p$t men'h$&il%$n nil$i &$l$h, (i%$ & e lu # u h $#'umen &$l$h

GI?<O8<lo'ic$lLte&t1,lo'ic$lLte&t

2,+$l ueLi.Lt#ue,+$lueLi.L.$l&e>

I? AND ?un'&i ini men'h$&il%$n nil$i-en$#, -il$ -e#$#'umen-en$# :$&il d$#i .un'&i ini (u'$ d$p$tmen'h$&il%$n nil$i &$l$h, (i%$

GI?<AND<lo'ic$lLte&t1,lo'ic$lLte&t2,+$ lueLi.Lt#ue,+$lueLi.L.$l&e>


(

(.=.+. Penggunaan Auto#um?itu# AutoSum <pen'hitun'$n otom$ti&> di'un$%$n untu% mel$%u%$n

pen'hitun'$n den'$n cep$t d$n mud$h d$#i d$t$d$t$ y$n' cu%up -$ny$% d$l$m&u$tu #$n'e te#tentu =$#$ny$ den'$n men''un$%$n tom-ol tool-$# AutoSum<M>

Letak tom9ol

Autosum

(.=.). Penggunaan "ungsi I"?un'&i I? d$p$t di'un$%$n &e-$'$i .o#mul$ lo'i%$ untu% men'hitun'

$t$u menentu%$n nil$i &e-u$h pe#ny$t$$n dim$n$ .un'&i I? $%$n mem-e#i%$nnil$i te#tentu (i%$ lo'i%$ -en$# $t$u &$l$h 8umu& .un'&i i. y$n' &e#in' di'un$%$ndi !ic#o&o.t Ecel d$p$t dilih$t p$d$ t$-el di -$$h ini

7ontoh penggunaan i, satu logika 4

Di%et$hui t$-el den'$n ti'$ %olom y$itu n$m$, nil$i d$n %elulu&$n 3olom %elulu&$ndi&i %$t$Jtid$% lulu&K $p$-il$ nil$iny$ %u#$n' d$#i 59 &el$in itu dii&i %$t$ Jlulu&K

"$d$ cell =2 ;

- D$#i menu pilih ?o#mul$& l$lu %li% in&e#t .unction hin''$ muncul %ot$% di$lo'

In&e#t?unction- "ilih .un'&i I? l$lu %li% O3

- I&il$h Windo& ?un'&i I? &e&u$i den'$n '$m-$# di -$$h ini l$lu %li% O3




- Setel$h itu &$lin .o#mul$ %e &el&el y$n' $d$ di-$$hny$

Gam9ar ('.+ 7ontoh Penggunaan i, satu logika :+

=$#$ l$in $d$l$h menuli&%$n #umu& i. &ec$#$ l$n'&un' di?o#mul$ -$#

Rumus I, di

"ormula 1ar

Gam9ar ('.) 7ontoh Penggunaan i, satu logika :)

(.=.-. Penggunaan "ungsi 7O$!I"?un'&i counti. di'un$%$n untu% men'hitun' $t$u menc$c$h &e-u$h

&el7#$n'e -e#d$&$#%$n %ite#i$ te#tentu 8umu& pen''un$$n =ountI. di !ic#o&o.tEcel $d$l$h ;

>7ounti,6range?;riteria8

=ontoh c$#$ pen''un$$n =ountI. ;

:itun' -e#$p$ m$h$&i&$ y$n' mend$p$t nil$i / -e#d$&$#%$n t$-el di -$$h ini

Gam9ar ((.( 7ontoh Penggunaan 7ountI, :(

B$n'%$h pen'e#($$nny$ $d$l$h menuli&%$n .un'&i =ountI. di &el D

12




(

Hasil penggunaan

7ountI,




At$u $p$-il$ in'in men'hitun' (uml$h m$h$&i&$ y$n' mend$p$t nil$i =,h$ny$ tin''$l men'u-$h c#ite#i$ny$ &$($, &ed$n'%$n #$n'e ny$ tet$p

Hasil penggunaan

7ountI,

(.=.5. Penggunaan "ungsi #$MI"!en(uml$h%$n d$t$ y$n' -e#&i.$t nume#i% d$l$m &u$tu #$n'e d$t$ den'$n%#ite#i$ te#tentu 8umu& pen''un$$n SumI. di !ic#o&o.t Ecel ;

>#$MI"6range?;riteria?sumDrange8

=ontoh pen''un$$n S*!I? ;:itun' (uml$h l$-$ pen(u$l$n y$n' -e#$&$l d$#i %$nto# c$-$n' m$diun

Penggunaan

#umI,

Hasil penggunaan

#umI,

(.=.=. Penggunaan "ungsi 7O$!A!en'hitun' (uml$h &el y$n' tid$% %o&on' d$#i &u$tu #$n'e 8umu& =O*NTA

>7O$!A6angka (? angka &?...8

>7O$!A6alamat range8

=ontoh pen''un$$n =O*NTA ;:itun' (uml$h cell y$n' tid$% %o&on' p$d$ %olom A <=ell A2 &$mp$i A5>

Hasil penggunaan

7ountA

(.=.. Penggunaan "ungsi Lookup dan Re,erensi?un'&i Boo%up 8e.e#ence di'un$%$n untu% men'$m-il $t$u mem-$c$

in.o#m$&i d$#i t$-el l$in untu% di($di%$n #e.e#en&i %e d$l$m t$-el y$n' &ed$n'di$n$li&i& =$#$ pen''un$$n .un'&i Boo%up d$n 8e.e#ence di(el$&%$n &e-$'$i

-e#i%ut ;

14




(

(.-..(. Inde<!en$mpil%$n d$t$ <i&i d$#i &u$tu &et> p$d$ t$-el $##$y -e#d$&$#%$n nomo#

-$#i& d$n nomo# %olom 8umu& d$#i .un'&i Inde $d$l$h ;

>I*EF6arra3?roBDnum?;olumnDnum8

3ete#$n'$n ;A##$y ; T$-el y$n'di-$c$ 8oLnum ; /$#i&%e =olumnLnum ; 3olom %e=ontoh pen''un$$n .un'&i inde $d$l$h ;

Di%et$hui $d$ du$ %olom -e#i&i %elompo% -u$h dim$n$ m$&in'm$&in'%elompo% te#di#i $t$& ti'$ (eni& -u$h y$n' -e#-ed$ "e#&o$l$nny$ $d$l$h-$'$im$n$ c$#$ men'$m-il n$m$ -u$h y$n' -e#$d$ di -$#i& %e %olom %e 2

>I*EF6A&41)+&8

(.-..&. %lookup/e#.un'&i untu% menc$#i nil$i d$l$m &u$tu %olom t$-el $t$u untu%

mem-$c$ t$-el &ec$#$ +e#ti%$l den'$n men''un$%$n nil$i %unci pem-$ndin'&e#t$ o..&et %olom y$n' $%$n di-$c$ 8umu& )loo%up $d$l$h

>%LOOK$P6LookupDalue?!a9leDArra3? 7olDinde<Dnum8

3ete#$n'$n ;Boo%upL+$lue ; nil$i y$n' di'un$%$n &e-$'$i d$&$# $$l mel$%u%$n #e.e#en&ip$d$ t$-le y$n' &ed$n' di$n$li&i& T$-leLA##$y ; t$-el y$n' di-$c$ 7 di($di%$n $cu$n=olLinde ; po&i&i nomo# %olom y$n' dip$%$i p$d$ &$$t mem-$c$ t$-el=ontoh pen''un$$n )loo%up $d$l$h ;!en$m-$h%$n %ete#$n'$n di t$-el d$.t$# nil$i -e#d$&$#%$n t$-el Nil$i y$n'di'un$%$n &e-$'$i $cu$n




!a9elA;uan

Hasil

%LOOK$P

(.-..+. Hlookup/e#.un'&i untu% menc$#i nil$i d$l$m t$-el $t$u di'un$%$n untu%

mem-$c$ t$-el &ec$#$ ho#i&ont$l den'$n men''un$%$n nil$i %unci pem-$ndin'&e#t$ o..&et -$#i& y$n' $%$n di-$c$

>HLOOK$P6lookup alue?ta9leDarra3?;olDinde<Dnum8

3ete#$n'$n ;Boo%upL+$lue ; nil$i y$n' di'un$%$n &e-$'$i d$&$# $$l mel$%u%$n #e.e#en&ip$d$ t$-le y$n' &ed$n' di$n$li&i& T$-leLA##$y ; t$-el y$n' di-$c$ 7 di($di%$n $cu$n=olLinde ; po&i&i nomo# -$#i& y$n' dip$%$i p$d$ &$$t mem-$c$ t$-el

=ontoh pen''un$$n :loo%up $d$l$h ;!en$m-$h%$n %ete#$n'$n di t$-el d$.t$# nil$i -e#d$&$#%$n t$-el Nil$i y$n'di'un$%$n &e-$'$i $cu$n

Penulisan "ungsi

HLOOK$P

!a9el

A;uan

Hasil Penggunaan

HLOOK$P

(.=.. Penggunaan GraCk dan *iagramC#$.i% d$n di'#$m d$p$t di-u$t di !ic#o&o.t Ecel den'$n &$n'$t mud$h

y$n' d$p$t di'un$%$n untu% -e#-$'$i %epe#lu$n Te#d$p$t -e-e#$p$ tipe d$#i'#$.i% $t$u di$'#$m y$n' tel$h di&edi$%$n oleh !ic#o&o.t Ecel, di$nt$#$ny$ ;

tipe %olom <=olumn =h$#t> tipe '$#i& <Bine =h$#t>

tipe %ue <"ie =h$#t>

tipe -$t$n' </$# =h$#t>

dll

15




(

B$n'%$hl$n'%$h mem-u$t '#$.i% p$d$ !ic#o&o.tEcel $d$l$h

$ "e#t$m$ &i$p%$n d$t$ -e#-entu% t$-el y$n' $%$n di($di%$n '#$.i%

- /lo% l$h &elu#uh d$t$ d$l$m t$-el te#&e-utc "ilih tu# =h$#t di T$- In&e#t "ilih (eni& '#$.i% y$n' diin'in%$n

d C#$.i% tel$h &ele&$i di-u$t

!ic#o&o.t Ecel tel$h menyedi$%$n -e#-$'$i tu# t$m-$h$n untu% men'editt$mpil$n '#$.i% &ehin''$ le-ih men$#i%

(.. Latihan#oalLatihan #oal( 4Di%et$hui te#d$p$t ti'$ -u$h t$-el, y$itu t$-el 1, t$-el 2 d$n t$-el "$d$ t$-el te#d$p$t du$ -u$h %olom %o&on' 3olom 3ode A&$l dii&i den'$nmen'$m-il hu#u. pe#t$m$ d$#i %olom %ode t$-el %e &ed$n'%$n %olom 3ot$A&$l dii&i den'$n mem-$c$ t$-el 1 3ot$ A&$l 3olom 3ode Tu(u$n dii&i den'$nmen'$m-il hu#u. %edu$ d$#i %olom %ode t$-el &ed$n'%$n %olom 3ot$ Tu(u$ndii&i den'$n mem-$c$ t$-el 2 3ot$ Tu(u$n




"e#t$ny$$n;

1 Tuli&%$n .un'&i untu% men'i&i %olom 3ode A&$l2 Tuli&%$n .un'&i untu% men'i&i %olom 3ode Tu(u$n Tuli&%$n .un'&i untu% men'i&i %olom 3ot$ A&$l4 Tuli&%$n .un'&i untu% men'i&i %olom 3ot$ Tu(u$n

Latihan #oal& 4Di%et$hui te#d$p$t &e-u$h t$-el dim$n$ pen'i&i$nny$ -e#d$&$#%$n du$t$-el di -$$hny$ B$m$ In$p dii&i T$n''$l 3elu$#T$n''$l !$&u% "en'i&i$n-i$y$ in$p d$n l$y$n$n te#'$ntun' p$d$ %olom %el$&ny$ /i$y$ pe#&$lin$n dii&i-e#d$&$%$n $p$%$h dit$n'$ni oleh do%te# $t$u -id$n Tot$l -$y$# dihitun'men''un$%$n .un'&i Sum

"e#t$ny$$n;

1 Tuli&%$n .un'&i untu% men'i&i %olom B$m$ In$p2 Tuli&%$n .un'&i untu% men'i&i %olom%olom /i$y$ men''un$%$n .un'&i i.el&e

Tuli&%$n .un'&i untu% men'i&i %olom Tot$l /$y$#4 Tuli&%$n #umu& untu% menc$#i Tot$l /$y$# y$n' te#-e&$#9 Tuli&%$n #umu& untu% menc$#i Tot$l /$y$# y$n' te#%ecil5 Tuli&%$n untu% menc$#i Tot$l /$y$# &emu$ p$&ien

1@




3umpul$n So$lSo$l B$tih$n!ic#o&o.t Ecel 200

LAPORAN PENGHASILAN SEWA PLAY STATION

No Penyewa Alamat KotaTipePS

Tgl SewaTgl

KembaliLama Sewa Tarip Per Hari Jml iaya !en"a Tot iaya

001 Smile Jl. Otista 12 Jakarta Timur A 3-Jun-04 18-Jun-04

002 Cindy Jl. Jatinegara 1 Jakarta Timur C23-Jun-

0417-Jul-04

003 Pasa Jl. Pra!atan 34 Jakarta Pusat C 1"-Jul-04 1"-Jul-04

004 #ana Jl. $erdeka 2 Jakarta %arat A 2-Jun-04 11-Jun-04

00& 'ery Jl. Sa(ang 12 Jakarta %arat % 7-Jun-04 2"-Jun-04

00" )aikal Jl. *e(+n Siri 3 Jakarta %arat %21-Jun-

041-Jul-04

007 J+,ita Jl. *araang 2 Jakarta %arat C &-Jul-04 11-Jul-04

008 i/ky Jl. %eringin 43 Jakarta %arat % 7-Aug-04 23-Aug-04

00 ini Jl. Sura(aya &4 Jakarta Timur A12-Aug-

0412-Aug-04

19




#ENGHIT$NG ANGS$RAN R$#AH

NO% NA#A KOTA TYPEHARGAR$#AH

$ANG#$KA

&'(

$ANG#$KA&RP(

TOTALPINJA#AN

$NGAPER

TAH$N

JANGKAWAKT$

ANGS$RAN PER

$LAN

TOTAL YANG

!IAYAR

1 ndiart+n+ Jakarta $elati "0 18 20 taun

2 )endraan Ali Sura(aya $elati 2& 18 1& taun

3 andy Suandi %andung $elati 20 18 14 taun

4 Aditya Samudra Jakarta $elati 2& 18 12 taun

& Agung $uly+n+ Jakarta $aar &0 18 1 taun

" Andy Setiaan Sura(aya $aar 30 18 1" taun

7Sara#++rde,iana

Sura(aya $aar 40 18 11 taun

8 Ayu Anandika Jakarta $aar 30 18 10 taun

rnaati %andung $ataari 30 18 22 taun

10 ud+l Sakilangit Sura(aya $ataari 2& 18 21 taun

11 )erry ndart+ Sura(aya $ataari 4& 18 18 taun

12 iant+ Suerman Semarang $ataari 30 18 17 taun

13 e((y Andalusia %andung $ataari 1& 18 13 taun

15




LAPORAN PENJ$ALAN ARANG

NO% NA#A KO!E NA#A ARANG HARGASAT$AN

)OLJ#L

HARGA!IS*O$NT HRG ERSIH

1 Adit $C#-13&0-20 $esin Cu/i #asi+nal 7

2 Adi *#-1200-2& *ulkas #ati+nal 2 !intu 8

3 Ayu $CS-1200-1& $esin Cu/i Sany+ "

4 Ci/i TSA-1400-0 Tele,isi Sar! 145 12

& *emal *#S-1000-10 *ulkas #ati+nal 1 !intu 21

" #imr+d 'PP-1100-20 'C Player Panas+ni/ 1&

7 anti $T-127&-& is/man T+si(a 1&

8 Sara TT%-2700-1& Tele,isi T+si(a 245 18

T+ny $S-12&0-10 is/man S+ny 12

10 6+se! TCA-11&0-1& Tele,isi Cangg+ng 145 22

1




+$NGSI, $NT$K #ENG$JI KEENARAN S$AT$ KON!ISI

NA#ANILAI-. NILAI-/ RATA/

HASILPEN$LISAN

N$#ER N$#ER N$#ER +$NGSI

A# 0 80 8& 9:7;"0<5TA* =>=>S5<5=>=>S5?

A= 70 88 7 9:8;"0<5TA* =>=>S5<5=>=>S5?

#A 80 "7 73.& 9:;"0<5TA* =>=>S5<5=>=>S5?

A &0 "0 && 9:10;"0<5TA* =>=>S5<5=>=>S5?

ENT$K PEN$LISAN +$NGSI ,

0I+&12Y23(

NA#ANILAI-. NILAI-/ RATA/ NILAI

HASILPEN$LISAN

N$#ER N$#ER N$#ER H$R$+ +$NGSI

A# 0 80 8& =>=>S 9:7;"0<55<:7;80<5C5<:7;0<5%5<5A5???

A= 70 88 7 =>=>S 9:8;"0<55<:8;80<5C5<:8;0<5%5<5A5???

#A 80 "7 73.& =>=>S 9:;"0<55<:;80<5C5<:;0<5%5<5A5???

A &0 "0 &&TA*

=>=>S9:10;"0<55<:10;80<5C5<:10;0<5%5<5A5

???

1@




#OT

+$NGSI ,#ENGHASILKAN TR$E JIKA KON!ISI YANG !I$JI SALAH !AN +ALSE JIKA KON!ISI YANG !I$JIENAR

NA#ANILAI-. NILAI-/ RATA/

HASILPEN$LISAN

N$#ER N$#ER N$#ER +$NGSI

$A 0 80 8& 9:#OT:7;"0?<5=>=>S5<5@A@A=5?

A# 70 88 7 9:#OT:8;"0?<5=>=>S5<5@A@A=5?

>6 80 "7 73.& 9:#OT:;"0?<5=>=>S5<5@A@A=5?

#6 &0 "0 && 9:#OT:10;"0?<5=>=>S5<5@A@A=5?

O +$NGSI, #ENGHASILKAN TR$E JIKA EERAPA ARG$#EN ERNILAI ENAR

!AN +ALSE JIKA SE#$A ARG$#ENSALAH

NA#A

NILAI-. NILAI-/

HASIL

PEN$LISAN

N$#ER N$#ER +$NGSI

#$O 0 80 9:O:8;"0<8;"0?<5)5<5=>=>S5?

TO# 6>S#O 70 4& 9:O:;"0<;"0?<5)5<5=>=>S5?

6OSP) )A#O6O 80 "7 9:O:10;"0<10;"0?<5)5<5=>=>S5?

A#T) &0 "0 9:O:11;"0<11;"0?<5)5<5=>=>S5?

1




ENT$K PEN$LISAN +$NGSI ,

0OR&1.21/21425(

A# +$NGSI,

#ENGHASILKAN NILAI TR$E JIKA SE#$A ARG$#EN YANG !I$JI ERNILAI ENAR !AN

+ALSE JIKA A!A SAT$ ATA$ LEIH ARG$#EN YANG ERNILAI SALAH%

ENT$K PEN$LISAN +$NGSI

, 0AN!&1.21/21425(

*onto6 Ka787%

Peserta uBian dinyatakan lulus Bika nilai uBian te+ri dan !raktik masing-masing arus di atas 7<

Bika tidak maka dinyatakan gagal.

NO% NA#A NILAI TEORINILAI

PRAKTIKKETERANGAN PEN$LISAN +$NGSI

1 Ci/i 9:A#:277<277?<5=>=>S5<5@A@A=5?

2 Ayu 8 8 9:A#:287<287?<5=>=>S5<5@A@A=5?

3 Adit 7 9:A#:27<27?<5=>=>S5<5@A@A=5?

4 Sara 8 9:A#:307<307?<5=>=>S5<5@A@A=5?

& #imr+d 7 9:A#:317<317?<5=>=>S5<5@A@A=5?

" T+ny 8 8 9:A#:327<327?<5=>=>S5<5@A@A=5?

7 6+se! 7 9:A#:337<337?<5=>=>S5<5@A@A=5?

8 *emal " & 9:A#:347<347?<5=>=>S5<5@A@A=5? Adi 7 " 9:A#:3&7<3&7?<5=>=>S5<5@A@A=5?

10 anti 8 9:A#:3"7<3"7?<5=>=>S5<5@A@A=5?

20




#ENGHIT$NG ANGS$RAN PINJA#AN SEPE!A #OTOR

No% *87tomer Ko"e #ere9 Tipe !P Ang78ran

1 ndiart+n+ 6J>23

2 )endraan Ali 6#O3&

3 andy Suandi )*2

4 Aditya Samudra )SD3&

& Agung $uly+n+ 6*3&

" Andy Setiaan 6'23

7 Sara #++rde,iana )S2

8 Ayu Anandika )T@3&

rnaati )T@23

10 ud+l Sakilangit 6$2

11 )erry ndart+ )*23

12 iant+ Suerman 6J>3&

13 e((y Andalusia )SD23

KO!E TIPE !P ANGS$RAN

J> Ju!iter 1<7&0<000 "08<000

$ $i+ 1<&00<000 &04<000

#O #+u,+ 1<&00<000 "34<000

* D *ing 2<&00<000 711<000' 'ega 1<2&0<000 481<000

* *arisma 1<200<000 "&2<000

S Su!ra it 1<7&0<000 &""<000

SD Su!ra D 2<000<000 &31<000

T@ Tiger 3<000<000 1&<000

21




LAPORAN PENGHASILAN HOTEL

NO% NA#A *HE*K IN *HE*K O$TTIPE

KA#ARHARGAKA#AR

LA#A#ENGINAP

J#L%IAYA

!IS*O$NT PAJAKTOTALIAYA

1 Ani S+ia 17-Se!-04 1-Se!-04 Standart

2 ei 2-Se!-04 2-O/t-04 eluEe

3 ,elina 1-Se!-04 30-Se!-04 eluEe

4 rene 30-Se!-04 1-O/t-04 Standart

& ati 2&-Se!-04 2-Se!-04 Standart

" isdiant+ 1-Se!-04 1-Se!-04 Su!eri+r

7 Sari 2-Se!-04 1-O/t-04 Standart

8 Tauan 30-Se!-04 &-O/t-04 Su!eri+r

>rsula 30-Se!-04 3-O/t-04 eluEe

TP *A$A)A@A*A$A

eluEe 2&0<000

Standart 200<000

Su!eri+r 22&<000

22




#E#$AT REKAP NILAI #AHASISWA

No% Nama NipN i l a i #i" +inal Paper Total

NilaiNilaiH8r8:

Keterangan#i" +inal Paper 4;' <;' /;'

1 #ia e,ianti 2004001 &0 70 4&

2 endi 2004002 80 0 8

3 $i/ky 2004003 70 4& 78

4 +/ky 2004004 0 78 7&

& aisa 200400& 8 7& 70

" #en/y 200400" 78 70 8

7 +sita 2004007 7& &0 &0

8 +nald 2004008 7

eFa 200400 0 8 8

10 +nney 2004010 "0 && &0

11 uddy 2004011 " 8 7

12 Ari Aryanti 2004012 8& 70 70

2




B$po#$n "en(u$l$n Ti%et "ene#-$n'$n !$&%$p$i!!!

NA!A3ODE

3EBAS T*6*AN TI3ET 3ET DIS3ON /AYA8

A!I8!00

:ONC3ONC

8p1,200,000

E3ONO!I 8p 50,000 8p @40,000

TEDDY!002 1 /ANC3O3

8p@00,000 )I" 8p 150,000 8p 540,000

8ONNY

!00

1 2

SINCA"*8

A

8p

400,000 /ISNIS 8p 40,000 8p 50,000

!E8BIN!001

SINCA"*8A

8p400,000

E3ONO!I 8p 40,000 8p 50,000

BA!I!00

:ONC3ONC

8p1,200,000

E3ONO!I 8p 50,000 8p @40,000

6OS*A!001 2

SINCA"*8A 400000 /ISNIS 40000 50000

3EBAS 1 2 3ODE T*6*AN TI3ET

3ET )I"/ISNIS E3ONO!I !001 SINCA"*8A 400000

!002 /ANC3O3 @00000

!00 :ONC3ONC 1200000

SOAB ;

DIS3ONG

10P DA8I :A8CA, 6I3A :A8CAQ90000020P DA8I :A8CA, 6I3A 900000QG:A8CAQ10000000P DA8I :A8CA, 6I3A :A8CARG1000000

/AYA8 G :A8CA DIS3ON

24




"etun(u% ;

Tu(u$n, Ti%et ; 'un$%$n )BOO3*"3et ; 'un$%$n:BOO3*"Di&%on ; 'un$%$nI?

N8" NA!A *TS *AS"8A3TI3*

!NIBAIA3:I8

3ETE8ANCAN

NIBAI:*8*?

9001 3ABISA 9 @0 @

9002 /ABIS @2 2 9

900 A3IA 5 100 59

9004 AISYA: 5 50 0

9009 BINDA 40 90 50

9005 8ID:O 2 @@ @0

900 8I?I @@ 9

900@ NISA 9 5 90

900 :ANA 0 100 @@

9010 A3WAN 90 20 90

3etentu$n So$l ;Nil$iA%hi#

G </o-otL*TS Nil$iL*TS></o-ot *AS Nil$iL*AS></o-otL3AT "#$%ti%um>

3ete#$n'$n ; (i%$ Nil$i A%hi# R 99, m$%$ m$h$&i&$ diny$t$%$n lulu&Nil$i :u#u. dii&i den'$n %etentu$n &e-$'$i-e#i%ut

(i%$ ; Nil$i A%hi# R @0, m$%$ Nil$i

29




hu#u. G UAU5 Q Nil$i A%hi# QG @0, m$%$ Nil$i hu#u. GU/U99 QNil$i A%hi# QG 5, m$%$ Nil$i hu#u. GU=U40 QNil$i A%hi# QG99, m$%$ Nil$i hu#u. GUDUNil$i A%hi# QG40, m$%$ Nil$ihu#u. GUEU

/O/OT

*TS 40P/O/OT*AS 40P

/O/OT 3AT 20P

25




BA"O8AN "E8SEWAAN !O/IB

"ENYEWA3ODE!O/IB

NA!A!O/IB

:A8CASEWA "E8

:A8I TANCCAB SEWA TANCCAB 3E!/ABI BA!A SEWA /AYA8

ANANDA S001 SEDAN = 500000 1Ap#1 Ap#1 2 1200000

/*DI!AN !002 !INI/*S / 490000 2Ap#1 Ap#1 1 490000

=AND8A S001 SEDAN = 500000 Ap#1 9Ap#1 2 1200000

DEWAYANI !002 !INI/*S / 490000 Ap#1 5Ap#1 190000

ENDANC !002 !INI/*S / 490000 9Ap#1 5Ap#1 1 490000?BOAN S00 SEDAN = 90000 Ap#1 @Ap#1 1 90000

C*NAWAN S00 SEDAN = 90000 @Ap#1 10Ap#1 2 1900000

IND8IATI S002 SEDAN / 00000 10Ap#1 11Ap#1 1 00000

TA/EB!O/IB

3ODE!O/IB NA!A

!O/IB

:A8CASEWA "E8

:A8I 3ETENT*AN SOAB ;

!001!INI/*SA 400000 NA!A !O/IB DIISI DENCAN TA/EB !O/IB /E8DASA83AN 3ODE !O/IB

!002!INI/*S/ 490000

:A8CA SEWA "E8:A8I DIISI DENCAN !ENCC*NA3AN TA/EB !O/IB/E8DASA83AN 3ODE !O/IB

S001 SEDAN = 500000 BA!ALSEWA G TANCCABL3E!/ABI TANCCABLSEWA

S002 SEDAN / 00000 /AYA8 G :A8CA SEWA "E8 :A8I V BA!A SEWAS00 SEDAN = 90000

2




"ENCINA"AN

6ABAN INA" 0 !ATA8A!

NO3ODE

3A!A8

NA!A"ENCINA

"

6ENIS3A!A8

SEWA 3A!A8"E87:A8I

=E3 IN=E3 O*T

BA!AINA"

S*/ TOTAB

/IAYA8OO!

SE8)I=E

TOTAB/AYA8

?ASIBITAS

1 A1 ABI 1Dec 9Dec

2 A /*DI 9Dec Dec

/1 =E8IA Dec

19

Dec

4 / DENI 11Dec

1Dec

9 /2 ?I?Y 12Dec

14Dec

5 / BOBA 15Dec

1Dec

/ NONI 1Dec

1Dec

@ A2 NANO 20Dec

21Dec

A !INA 21Dec

29Dec

10 A1 TIA 22Dec

25Dec

11 /1 EBSA

24

Dec

25

Dec

12 / 3A8IN 2Dec

24Dec

1 /2 6O3O 29Dec

2@Dec

14 A1 IDA 2Dec

2@Dec

19 /1 !IA 2@Dec

1Dec

2@




TOTAB

!AVI!*!

!INI!*!

8ATA8ATA

/ANYA3 "ENCINA" O8ANC

2




TA/EB 3A!A8

3ODE3A!A

8

6ENIS3A!A8

:A8CASEWA7:A8

I

/IAYA8OO!

SE8)I=E7:A8I

?ASIBITAS

A1ABA!ANDA

8p@00,000

8p50,000

!A3AN "ACI,?ITNES, 8ENANC

A2 ANYE8 8p00,000

8p90,000

!A3AN "ACI,?ITNES

A A!/8OSIA 8p500,000 8p40,000 !A3AN "ACI,8ENANC

/1 !AWA8 8p900,000

8p0,000 !A3AN "ACI

/2 !EBATI 8p400,000

8p20,000 ?ITNES

/ 3ENANCA 8p00,000

8p10,000 8ENANC

3ETENT*AN ; 6ENIS 3A!A8, SEWA 3A!A87:A8I, /IAYA 8OO SE8)I=E, ?ASIBITAS DIDA"AT3ANDENCAN ?*NCSI "E!/A=AAN TA/EB DA8I TA/EB 3A!A8 /E8DASA83AN 3ODE3A!A8BA!A INA" G =E3 O*T =E3INS*/ TOTAB G BA!A INA" V SEWA

3A!87:A8I TOTAB /AYA8 G S*/ TOTAB </IAYA 8OO! SE8)I=E V BA!AINA">SEBAN6*TNYA :IT*NC ; TOTAB, !A3SI!*!, !INI!*!, 8ATA8ATA, /ANYA3NYA"ENCINA"

0




BA"O8AN "ENE8I!AAN *ANC 3*BIA: !A:ASISWA

NO N8" NA!A 6*8*SAN 6!BS3S

/IAYA "E8S3S

*ANC"ENCE!/ANC

AN TOTAB /AYA8

1 2209 YENA TE3EBE3T8O

19

2 92100 N*8 TE3 SI"IB 1@

54109 TE!INSAST8AINCC8IS

1

4 92005 :ANA TE3IND*ST8I

21

9 542019 NO)ISAST8A

6E"ANC1

5 @10001 !EBISA 3EDO3TE8AN 1

0100 6O3O "SI3OBOCI 15

@ 59102 *6ANCE3!ANA6E!EN

1

922010 "A8TO TE3EBE3T8O

12

10 @920@2 DOYOE3A3*NTANSI

21

11 921001 :A8Y TE3 SI"IB 14

12 91001 ?E8I 3EDO3TE8AN 20

1 592111 Y*S*?E3

A3*NTANSI15

14 0009 *!A8 "SI3OBOCI 14

19 922029 S:ENDY TE3EBE3T8O

1

15 @20 YAN* TE3IND*ST8I

1

1 942012 TO"I3 SAST8A

6E"ANC1

1@ @21099 SADA8 TE3 SI"IB 1

1




1 5220@ /AS8I TE3EBE3T8O

12

20 @91919 YONOE3!ANA6E!EN

14

TOTAB

8ATA8ATA

!A3SI!*!

!INI!*!

2




3ODE 6*8*SAN*ANC

"ENCE!/ANCAN

103EDO3TE8AN 290000

21 TE3 SI"IB 19000

22 TE3EBE3T8O 200000

2 TE3IND*ST8I 190000

0 "SI3OBOCI 200000

41SAST8AINCC8IS 200000

42SAST8A

6E"ANC 190000

91E3!ANA6E!EN 19000

92E3A3*NTANSI 190000

TA/EB 1 ; 3ODE 6*8*SAN DAN *ANC"ENCE!/ANCAN

ANC3ATAN

3EDO3TE8AN TE3NI3

"SI3OBOCI SAST8A

E3ONO!I

9 0000 29000 0000 29000 200005 9000 0000 0000 29000 29000

9000 0000 9000 0000 29000

@ 40000 9000 9000 0000 0000 TA/EB 2 ; *ANC 3*BIA: "E8 S3S !ASINC!ASINC?A3*BTAS

3ETENT*AN SOAB ;




6u#u&$n dii&i -e#d$&$#%$n T$-el 1, den'$n mem-$c$ 2 di'it di ten'$h <di'it %eti'$ %eemp$t> d$#i 3ode N8"/i$y$pe#

4




*A"!AR GA/I PEGAAI

P!. I*AH PERKA#A

NONA!A

"ECAWAICOB

6*!BA:

ANA3 6A/ATAN

CA6I"O3O3

T*N6ANCAN

CA6I3OTO8

""n 9PCA6I

/E8SI:

1 )IN=ENT A 1 m$n$'e# 2900000 129000 2529000 11290 2490

2 )INO / &upe#+i&o

# 1900000 190000 1590000 @2900 195900

6*NOT = 2 &t$. 1000000 90000 1090000 92900 900

48IANDEBON / 0

&upe#+i&o# 1900000 9000 199000 @90 145290

9 BE!/* = 1 &t$. 1000000 90000 1090000 92900 900

5 ON=E = 2 &t$. 1000000 90000 1090000 92900 900

A*DY A 5 m$n$'e# 2900000 9000 2@9000 1490 21290

@ AST8I / 9&upe#+i&o

# 1900000 229000 129000 @5290 15@90

W*BAN = 1 &t$. 1000000 90000 1090000 92900 900

10 !AIA A 0 m$n$'e# 2900000 129000 2529000 11290 2490

TOTAB 15000000 129000

!AV 2900000 9000

!IN 1000000 90000

8ATA8ATA 1500000 12900

9




P!. /$PI!ER MO!OR

/L. 1A!$ O. + MA!ARAM

NO

NA!A"E!/EBI

3ODE3ENDA8A

AN

NA!A3ENDA8A

AN

:A8CA/A8*

BA!AANCS*8A

N/*NCA

"E!/AYA8ANSISA

38EDIT/AYA8"O3O3

/AYA8/*NCA

"E!/AYA8AN "E8/*BAN*ANC !*3A

20P

1 )IN=ENT :

2 )INO T 6*NOT S

48IANDEBON Y

9 BE!/* S

5 ON=E T

A*DY Y

@ AST8I :

STA)E S

10 W*BAN T TICE8XXXXXXXXX 24 19P

8p,500,000

8p14,400,000

8p500,000

8p0,000

8p50,000

3ODE3ENDA8A

AN

:A8CA/A8*

BA!AANCS*8A

N/*NCA

: 14000000 12 1P3ODE3ENDA8AAN : S T Y

S 12000000 12 14PNA!A3ENDA8AAN :ONDA S**3I TICE8

YA!A:A

T 1@000000 24 19P

Y 1000000 12 12P *ANC !*3A 20P

5




DA?TA8 "ESE8TA 3*8S*S

"*S3O! *!!AT

/IAYA "E8 "A3ET "ENDA?TA8ANDIS=O*N

T

"A3ET DASA8"8OC8A!!INC

WINDOWS

8p20,000 10P

8p 00,0008p

900,0008p

200,000

NO 3ODE SISWANA!ASISWA

3EBAS"A3ET YANC

DIA!/IB/IAYA

3*8S*SDIS=O*N

T TOTAB /AYA8

1 WD0017!D "A8TO!ABA! WINDOWS

8p220,000

8p11,000 8p 20,000

2 "80027"T AD*B "ACI "8OC8A!!INC 8p920,000

8p92,000 8p 45@,000

"D007ST 3O!ENC SIANC "A3ET DASA8 8p20,000

8p2,000 8p 2@@,000

4 "80047!D AI!ABA! "8OC8A!!INC

8p920,000

8p25,000 8p 44,000

9 WD0047"D S*BE "ACI WINDOWS 8p220,000

8p11,000 8p 20,000

5 "80057ST 6O6ON SIANC "8OC8A!!INC 8p920,000

8p92,000 8p 45@,000

"D007"D AS!*NI "ACI "A3ET DASA8

8p

20,000

8p

15,000 8p 04,000

@ WD00@7ST 6*6* SIANC WINDOWS 8p220,000

8p22,000 8p 1@,000

"D007!T !AND8A!ABA! "A3ET DASA8

8p20,000

8p2,000 8p 2@@,000

10 WD0107"D O!AS "ACI WINDOWS 8p220,000

8p11,000 8p 20,000

TOTAB

!AV




!IN

8ATA8ATA

NO

N$m$ !edi$ 3ode :$#'$)olume "en(u$l$n "$d$ T$n''$l

6uml$h Te#(u$l

6uml$h:$#'$1 2 4 9 5

1 3omp$& 3 1400 20 29 40 22 14 12 22 199 21000

2 8epu-li%$ 3 1200 20 25 29 21 19 24 21 192 1@2400

Bom-o% "o&t 3 1000 10 14 24 2 15 99 24 155 155000

4 Am$n$h T 100 21 10 12 20 14 90 24 191 1500

9 6$$ "o&t 3 2000 20 19 10 21 20 20 20 125 292000

5 !e#de%$ T 1900 12 14 40 12 12 10 12 112 15@000

6$%$#t$ "o&t 3 2000 19 15 22 20 14 20 21 12@ 295000

@/i&ni&

Indone&i$ ! 1900 14 1 24 20 21 21 20 1 1900

No+$ T 000 1 10 14 21 22 11 12 10 0000

10W$nit$

Indone&i$ ! 2900 10 1@ 12 40 19 22 190 9000

6uml$h 3o#$n Te#(u$l 2 10400

6uml$h T$-loid Te#(u$l 55 500

6uml$h !$($l$h Te#(u$l 2@ 94900

@




6uml$h Te#tin''i 155 9000

6uml$h Te#end$h 10 155000

8$t$#$t$ 15 22120

6uml$h 3e&elu#uh$n 15 221200




8E3A" A/SEN 3A8YAWAN

O AMAHARI

2umlahhadir

2umlah tidak hadir( & + ) - 5 = (' (( (& (+ () (-

( O%A < < : < < : < < < : < < : : <

& AJA# : : < < < < < < : < < < < < <

+ ROJI < < < < < < < < < < < < < < <

) MAE : < < < < < < < : < < < < : <- ELYJA < < < < < < < < < < < < < < <

5 #I!I < < < < < < < < < < < < < < <

= RI%IA < < < < < : < < < < : < < < <

O%A < < < < < < < < < < < < < < <

AHYAR < < < < : < < < < < < < < < <

(' Y$LI : : < < < < < < < : < < < < <

O AMAHARI 2umla

hhadir

2umlah

alpa

2umlahsakit

2umlah iin( & + ) - 5 = (' (( (& (+ () (-

( O%A < < a < < i < < < i < < a s s

& AJA# < < s s < < < < : < < i < < <

+ ROJI < < < < < < < < < i < < < s <

) MAE a < < < < < < < a < < < < s <

-ELYJA < < < < < i i < < < < < < < s

5 #I!I < < < < < < < < < < a a < < <

= RI%IA < < < < < s < < < < s < < < <

O%A s < < < < < i i < < < < < a <

AHYAR < < < < : < < i < < < < s < <

40




(' Y$LI s s < < < < < < < a s < < < <

P!. 1AK PRIMA*OA

*A"!AR GA/I PEGAAI

Apr:'-No

N$m$"e'$$i

Nip /$'i$nC#$d

eC$(i "o%o%

Tun( 6$-$t$n

C$(i 3oto# ""h 19P C$(i /e#&ih

1 )$#$ No+it$ 4002 =ollection 112,000,000

00 29P19,000,000

00 22900000012,90,000

00

2 Yuli$

8$chm$n 400298i&%

!$n$'ement 2,000,0000

0 19P10,90,000

00 199290000@,,9000

0

Edin

:ut$'$lun' 002 Ope#$tion 44,000,0000

0 0P4,000,0000

0 50000000,400,0000

0

48id$nSi$'i$n 002 Ope#$tion 4

4,000,00000 0P

4,000,00000 50000000

,400,00000

9An$ntoWi-oo @001 Ope#$tion

1,000,00000 0P

1,000,00000 19000000 @90,00000

5 *-$idill$h @00 =ollection 1,000,0000

0 0P1,000,0000

0 19000000 @90,00000

A'u& D($m$l 2009 =ollection 52,000,0000

0 0P2,000,0000

0 00000001,00,0000

0

@ 6oh$n 6$$#$ @008i&%

!$n$'ement 9,000,0000

0 0P,000,0000

0 490000002,990,0000

0

No+elin$ @008i&%

!$n$'ement 9,000,0000

0 0P,000,0000

0 490000002,990,0000

010 El$ 8i$n$ @0041 !$#%etin'

1,000,00000 0P

1,000,00000 19000000 @90,00000

11 Y$&min @004 !$#%etin'

1,000,00000 0P

1,000,00000 19000000 @90,00000

12 :$#t$nto @@0049

8i&%!$n$'ement

1,000,00000 0P

1,000,00000 19000000 @90,00000

1 A#ie. Nu'#oho 1004

8i&%!$n$'ement

1,000,00000 0P

1,000,00000 19000000 @90,00000

41




14

6o%oInd$#yono @4004 !$#%etin' 5

2,000,00000 0P

2,000,00000 0000000

1,00,00000

19 8$.$el @0091 !$#%etin' 4

4,000,00000 0P

4,000,00000 50000000

,400,00000

15 Ami# S$nto&o @009 Ope#$tion 4

4,000,00000 0P

4,000,00000 50000000

,400,00000

1

3em$lAl$m&y$h 0099 IT 2

,000,00000 19P

10,90,00000 199290000

@,,90000

1@ =h$e#it$ @009 Ope#$tion

5,000,00000 10P

5,500,00000 000000

9,510,00000

1

S#i Nu#ul 009 IT 1

12,000,000

00 29P

19,000,000

00 229000000

12,90,000

0020 Toni Yu&eno 40051

8i&%!$n$'ement 5

2,000,00000 0P

2,000,00000 0000000

1,00,00000

TOTAB@2,000,000

00 0P1,00,000

001,59,000

00,509,000

00

TA/EB CA6I DAN T*N6ANCAN

C#$de C$(i "o%o% Tun( 6$-$t$n

112,000,000

00 29P

2,000,0000

0 19P

5,000,0000

0 10P

44,000,0000

0 0P

9,000,0000

0 0P

52,000,0000

0 0P

1,000,0000

0 0P

42



D$.t$# &'(

*A"!ARP$#!AKA

1 !$di$n$nto, *#ip2010"en'en$l$n !ic#o&o.t Ecel

200A+$il$-le[online];Q h t t p ; 77 t i% t p u 'm $ c id7&ite 7in de phpoptionGcomLcontent+ieGc$te'o#yl$y outG-lo'idG4ItemidG5R[5 O%to-e# 2010]

2 !, 8u&t$m2010"$ndu$n "#$%ti& "el$tih$n %ompute#A+$il$-le[online];Q

htt p; 77o%eo#id7tuto#i$l7R[ O%to-e# 2010] 3u#ni$$,Y$hy$200/el$($# Sendi#i !ic#o&o.t O..ice "oe# "oint

2006$%$#t$"T Ele !edi$ 3omputindo4 3u#ni$$n,Y$hy$200/el$($# Sendi#i ; !ic#o&o.t O..ice Ecel 200 6$%$#t$;"T Ele

!edi$ 3omputindo9 C,8$tn$200 /el$($# =ep$t !ic#o&o.t Ecel 200Yo'y$%$#t$;=) AndiO..&et5 :$di "u#nomo,=$tu#2010 "$ndu$n /el$($# Otodid$% !SEcel

2006$%$#t$;!edi$3it$ Winp$c Solution200 !ud$h !en'u$&$i !ic#o&o.t Acce&& 6$%$#t$;"TEle !edi$

3omputindo@ 3u#ni$$n,Y$hy$200 Tip T#i% !& O..ice Acce&& 200 6$%$#t$;"T Ele!edi$

3omputindo We-&ite ; i%ipedi$com t$n''$l $%&e& 1 O%to-e# 2010

10 !c=$#te#,6im ,6$cui S$le#no !$-in200@ !ic#o&o.t O..ice "u-li&he#200 ?o#

Dummie&Indi$n$nWiley "u-li&hin' Inc11 "#iy$tno,Dui2010 =$#$ In&t$n De&$in "#omo Den'$n!ic#o&o.t

"u-li&he#Yo'y$%$#t$!ulticom

http://www.tik.tp.ugm.ac.id/site/index.php




http://oke.or.id/tutorial/


http://www.wikipedia.com/





modul microsoft excel 2007

Documents