6820990-excelpufleri

8/13/2019 6820990-excelpufleri

1/32

EXCEL PFLER

1-OTOMATK KAYDETME: .................................................................................................... 42-ST VE ALT BLG: ............................................................................................................... 43-SAYILARI BMLEME: ...................................................................................................... 44-PARA BRMN DETRME: ........................................................................................... 45-DE A!LT AYARLARINI DETRMEK: .......................................................................... 5"-E#$%& S'()'*+, A +&*+ . ........................................................................................................... 5/-ONDALIK VE BASAMAK AYRALARI. .......................................................................... 50-SAY ALARA SM VERMEK: .............................................................................................. 5

- EL DMELER EKLEMEK. ........................................................................................... 51 -E 6EL7N DOSYA A KLAS RYLE AILMASI: ....................................................... "11-B!L!NAN DEERLER BAKA 86RELERDE K!LLANMA: .................................. "12-8ATA MESA9LARININ ANLAMI: ..................................................................................... "13-BYK KK 8AR DEM: .................................................................................. "14-OTOMATK DOLD!RMA: ................................................................................................. /15-SEL ST!N! BAKA ST!NA TAIMA: ................................................................. /1"-BRM D NTRME: ...................................................................................................... /1/-86RE ORTASINA G MEK: ................................................................................ 010-86REY METNE !YD!RMAK. ..................................................................................... 01 -OK ! !N SAY ALAR. ................................................................................................... 02 -OTOMATK TOPLAM. ....................................................................................................... 021-ENTER T!!N! KONTROL EDN. ................................................................................. 022-8I LI KOPYALAMA. ......................................................................................................... 23- ORML KOPYALAMA. ...................................................................................................

24-BYK ALANLARI SEMEK. ......................................................................................... 25-E 6EL DEN ;ORD E TABLO AKTARMA: .................................................................... 2"-B',+ C@' %< ?*% = &% *'()'(' *+F@+(>?. N% (' @'&+(+, 2/-8 $?% J% = ?J% )',&' *'&C %J ?H ...................................... 120- )'? &+ *'()'J' %*' &'?+ < @ &C: ......................................................... 123/- >?@ & &% C&&' '?' (' ?@ & >&'?' J%F & ?' '@*'&? @%* *< (>?C@. ............................................................................................................ 12

30-DKNE BALIKLAR K!LLANMAK: ........................................................................... 123 -OTOMATK BM. ........................................................................................................... 134 -ROMEN RAKAMLARI. ..................................................................................................... 1341-86RE DEERN ARTTIRIP A ALTA6AK DMELER: ......................................... 1342-E 6EL NDE 8ESAP MAKNASI ............................................................................... 1343-E 6EL SAY ALARINI BRLETRMEK ...................................................................... 1344-ST!NLARI SATIR OLARAK KOPYALAMAK: ........................................................... 144"-E 6EL VE SERLER ......................................................................................................... 144/-ALIMA SAY ALARINA KOLAY ERM: ................................................................ 1540-E 6EL GRA KLERNE YEN DEERLER EKLEMEK ............................................. 15

Sayfa - 1 Q 32 -


2/32

4 -KOM!TLARI DMELETRMEK .............................................................................. 155 -E 6EL BELGELERNDE V!RG!LAMA ...................................................................... 1"51-;ORD VE E 6EL DOSYALARINA RE ................................................................... 1"52-E 6EL7DE ONT LSTELER ......................................................................................... 1"53-TRKE KARAKTER PROBLEMLERNDEN BIKMADIK ........................................ 1/

54-E 6EL TABLOLARI VE DEERLER ............................................................................. 1/55-ALIMA SAATLER GRA : .................................................................................... 105"-E 6EL DE KILAV! GLER ................................................................................... 15/-TABLOLAR K!LLANMA ................................................................................................ 150-KK O I6E P LER .............................................................................................. 15 -MAKROLARI DMELERE D NTRMEK ............................................................ 2" -SAY ALAR ARASINDA 8I LI GE ............................................................................ 2"1-OTOMATK PARA SM ................................................................................................ 2"2-ON! B!NA EVRMEK ................................................................................................... 21"3-BO 86RELER KONTROL ETMEK .......................................................................... 21"4-NE OLA6AK B! VERLERN 8AL .............................................................................. 22"5-OTOMATK TOPLAMA .................................................................................................... 22""-86RELER OTOMATK OLARAK DOLD!RMA ....................................................... 23"/-KK KK NOTLAR .............................................................................................. 23"0-SATIRLARI STLA EDEN DEERLER ......................................................................... 23" -KLAS RLERN LE ALIIRKEN BE P NOKTASI ............................................ 24/ -ALANLARA SM VERME ............................................................................................... 24/1- ORML GRMENN KOLAY YOL! ............................................................................ 24/2-EER LEVNN K!LLANILMASI: ............................................................................. 25/3-BR ST!NDA KA TANE EERSAY LEV .......................................................... 25/4-! !N SM VERMEYN ................................................................................................... 25/5-ORTALAMAYA YAKIN SAYI ........................................................................................... 25/"-86REYE BR SATIRDAN A LA YA MAK: .............................................................. 2"//-SIRALI DEERLER OTOMATK DOLD!RMA: ......................................................... 2"/0-86RE GLERN G STERMEKQG LEMEK ....................................................... 2"/ -DMELERN TANIMLARINI DETRMEK ........................................................... 2"0 -E 6EL DE SI IR ATMA .................................................................................................... 2/01-E 6EL D ORMLLER LE SEL VERLERN ETLENMES ...................... 2/02-;ORD VE POSTA LSTELER ........................................................................................ 2003-E 6EL DOSYALARINI I 8TML OLARAK KAYDETMEK ........................................ 204-GRA K YARATMAK: ...................................................................................................... 305-GRA K TR SEMEK: ................................................................................................ 3

0"-MAKROLARI TM KTAPLARDA ETKN KILMAK: .................................................. 310/-VERLER SIRALAMAK VE S MEK: .......................................................................... 3100-8ESAPLAMA SON!LARININ RAKAMSAL DEER OLARAKG RNTLENMES: ............................................................................................................. 310 -8ESAPLAMA SON!LARINI BAKA SAY ALARDA K!LLANMAK: .................... 32

-E 6EL7 SAY ASI AMAK: .......................................................................................... 321-OTOMATK DOLD!RMA: ............................................................................................... 322-OTOMATK S ME: ......................................................................................................... 323-ST!NLARI SATIR OLARAK KOPYALAMAK: ........................................................... 335- AMAN GRA NN ELM: ..................................................................................... 33

Sayfa - 2 Q 32 -


3/32

1-OTOMATK KAYDETME:E#$%& J% '&+ +? % =%& %&%? @ , =%& ?& '?'&+ &'?&' >@'< >&*'F&'('= & ? @ ( ,HA?' &'? % E &% T>>&* AJJ-I * >@CO@'< K'(J%< ACS' % *% % %F '?%@C C&'?+@+ 'F+J' J %? % *?*' +, D>*(' S'()' Y' +*+ &% P' % S%@C C&' *% % %F =C&'@',*' +, ,%& * C J'&+ %* ? ='*'@' &+ =',% TL % &% @? (>?. B',% J% (',J+ &'?+@ ?' ' %* ?

*< (>?*' 8 $?%&%? B @&% J ('&> C J'&+ %*? ? & >&'?' *1 A(?'$+ KC&&' !*% 1 S% %?'? *% % %F '?%&'?' ABD J>

C&&' +(>?C,. 8 $?% = @&%? % J @ , =%& ?&%(%@%, @ ( ,HD%)'C&< '?' = ? @ ; J>U* 5 =%& ?&%?. BC C D% %< @ M'*'*+ B & %*%&B ? @ 6> & P' %& R% > '& S%&'?+ J' TL

'?%< C&&' '$' *' +, E#$%& * ,% $?%&%? ,%& >&'?' = @&%@% *% % = @&%@% *@C

Sayfa - 3 Q 32 -


4/32

NC@=%? = &@%* % ? & * &C =+?' + '?%< (',+ . T'@'@ J F@%* % > ' + % (',+< J% '& ?'@+ +,+ =C&C JCFC &LS?*'J>*('(+ BOOK. LT 'J+(&' '(J%J . A? = ? ?*' +, @'*' *< J% = ? E#$%& +*'(>&C ('?'@C& S >? ?'@ (>&C C *> C ' QE '?'@%


5/32

1 -E 6EL7N DOSYA A KLAS RYLE AILMASI:E#$%& &% ',+?&'J+F+ +, =%& %&%? =%& ?& = ? &'* ? '&&* O < > * G% %?'& = &@%* % ? . XV'?*'(+&' J>*(' (%? X D%)'C&< = &@%* % D>*(' A >@C?@ &&%? C&&' '?' %*' &'@' (' ?C,. BC&C ' J%F%?&%? =' =' ' $?%&%? J% J% C&&' @' + ?'< = ? (>&C '? @+HD (%& @ S'()'1 D * ('&'(+ (' + C@C ' ?% J%F ? (' = ? ' &'@J' J%F%?&%? J%F & )>?@ &

Y' +&'$' )>?@ & J%F & $?% 'J?%* > ('&'@' ('&'? % S'()'1Z)>?@ & C&&' @' +, %?% ?. BC C ?'< (>&C *% '( ' '&+ '$' $?%

%?@% < ?. ? %F >? [ '& @'?< '(+ &'@+ + =C&C JCFC $?%( *% EI *%?< N'@% D%) % >@C> +*@+ ' = ? 'J ?

@'? &C =+?' @'@'(' J '< %J . T'@'@J F@%* % $?% = ? *@ >&C?. A? '&+ @' ?. %J ?H

O '&J% * ,% '?@ & , = ? *'(+(+ *+)+?' = &@%(% %(' = &@% &%@

$?%(% J%?@%(% '&+ +(>?. B &J F , = = ? *'(+ *+)+?' = & %@%,.ADH NAMEH >?@ & '&+ @' ?@ &J% $?% =' C?C&'?+ + ='F+@*+, J%F % &%?J% '(+?@'%(' > ?@ & ,J% = ? *'(+ &% & & = ? *>?C &' '? +&' ?@ & J% (' &+ < ?J% = ? ='F+@*+, J%F % %(' %*' &'@' *> C$*'()'*+ J' ? < &% %@%(%$% 'J'? = ( %(' = ? J%F%? >&'= & ?.

RE Z E#$%& % %?* , = ? $?% =' C?C*C &% '? +&' C (> @CH

Sayfa - 5 Q 32 -


6/32

BC C = ? &' (% >@= '*(> C (> '@' ('?' &% =C '&&%J%= & ?* ,.

M%< = ( '?)& (' @' C @' ?>(C C&&' + :

SC= BC(C 8'?)

>? E'$ $ I S%&%$< > .6%&&*$.V'&C% !$'*% $.V'&C% N%#< $E J SC=M%< '?) (' @' *% C @' ?>(C C&&' + :SC= KC$C 8'?)

>? E'$ $ I S%&%$< > .6%&&*$.V'&C% L$'*% $.V'&C% N%#< $E J SC=

BC @' ?>&'?+ C&&' @' J% * ,$ &%? J%F < ?@% * ('?' &C ) > &'?. BC < ? %? &%?J% & $?%(% = ?%? '&JC?@' (' '?1 % 3 (' J' O$' M'?< >@'< J>&JC?@' &%@ J% = ?%? '&* O < > * 6C*@ L *


7/32

E %>&P' '?%J & (*'F&'@'&+*+ +,. BC &%@ ?' EVR 6ONVERT )> * (>

C&&' '?' = ? @&%? J < ?%= & ?* ,. A 'F+J' *+?'*+(&' & =?%( &> ?'@6%&$ C* ' &


8/32

22-8I LI KOPYALAMA.B ? $?% %? F = ? '&?*' +, '&< ]6


9/32

&@%* % (>& ' '$' ?&'@'(+ % &&'?+ + '?'(+ . N% J% >&*' = ? 'F+J+ =>(C%C$J ?H

S C&'?' '*+& (%?&% < ? &BC C %@% (' + J' M%< S'? ;?' T%#< *% % %F ' < ) '&% %< ? ?

%? * J% * C ?' S'()'2 J% %?'&' + *% BC?'J' A1:D" % '@%?' J F@%* % ?' > *'


10/32

31-TABLO YAPITIRMA.E#$%& J% ',+?&'J+F+ +, &'?+ ' =% ,%? =(' +


11/32

35-R& >?C@C+J& @&


12/32

3 -OTOMATK BM.E#$%& J% ',+?&'J+F+ +, ?@'< AC >?@'< >@C @% ?' '@&'?+ &% ? @%* *< (>?*' +, ROMEN )

C&&' '= & ?* ,. B2 $?%* J% 1 " *'(+*+ + >&JCFC C '?*'('&+@. EF%? A2 *'(+(+ R>@% ?' '@+ &% ?@% *< (>?*' +, = < (' '$'F+ +, %( A2 $ROMEN B2 )>?@ & ?@% < ?.

41-86RE DEERN ARTTIRIP A ALTA6AK DMELER:8%*' ?@* >?@&'? '?' C=CFC J' +?+&J' '?'$+ + J ='*+ . '?% , C&&' '?' %*' ?' J' '(E#$%& '&+ @'


13/32

44-ST NLARI SATIR OLARAK KOPYALAMAK:E#$%& J% S'()'1 J% ',+?&'J+F+@ = ? )>?@C =' &+F+ A1 &% A1 $?%&%? =C&C @' ?C@. BC &%@ (' '= &%$%F @ % +*' (>& ' * J ?H 45-KESRL SAALIMAKE#$%& &% '&+ +(>?C@. B%& * ,% '? %&%$% ' $' ,'@' ,'@' %* ?& *'(

%?% (>?. ? %F 15 2Q3 > =% &C =+?' @' $' +@+ *+ +(>?. BC (' @' + % >&'( = & '?%

6820990-excelpufleri

Documents

Transcript of 6820990-excelpufleri