Microsoft Excel - Curs de Utilizare

8/14/2019 Microsoft Excel - Curs de Utilizare

1/62


2/62

! " #!$ " %& !"'(!%"!%)!$*+,*+-

# % ' ." ,/"010-" 2 % " !%.

!

0%#

3

45" 4,-6

7"!50,%

)" $ . %7.-6


3/62

8

6 ," - 7 !"6

0&'"!%"%"%

0

/1$%$

"

"

#%"

.

+!5

+!9

+

:

+

+

+

"%$3


4/62

;

3 % $ #"%%' ,!&5)" 5""-6

,-3 ! "

! 2 "6

6 !

" #

!$"&55'


5/62

@

$ %

$ &!

!!3

"% $!!

!3

'6 !%6 $"%

$! % 6 % " $ $! ")"

2!5"%$!3 " % %

!"4%%6

3 " !

6 ,

)%%-3!%4,%-"%!

!(

)$ " % % $ !"#$##&(7%"%!$&%

= " %5 ! !"

!!,4-!,""%$!!-

3 "6 ,4-6 "# " 7 )"

$


6/62

A

$ '

5%!

" " " % " $

# $ % "

! % A BC # BC" 5 %$BCBC

2 !" BC" $BC"$

$" (%

2"%

#"%5!% $) "

2! ! % " & !

% &!! 5 " $%5"&& 2 " &D 5 & %

. ' ! *)(&+""$"

,-

2"%

7!#"#",!-3$9,9-

7"3 39""8"?69EE"9@"9@E"?6 385#5EE8"@5#5EE8"?6@D99DEE"@D9DEE69E3EE"

9E39@"9E38E"?6 3"""?62"F""">6


7/62

G

3 7


8/62

K

% "( (."*(>$%.

.!&.

&/#"!%

0 $ " &5(

!>3

6 $"$

2 !" , -

$.!%3 !$6 !,"0-6

%3&6 %1 3 " "

,


9/62

L

#",-7%5"&"& 1."!%

$

(

#%"$3 ,-%56 !!%,

-6 0. % &

%# ! %

!3 6 !!,-6 .

$$ +%

:$%5"5!

$"&5%0$$!"20"23"4"

# " 54 5 "$

. % %, %! !-

$, %

#$%&3 34$)6 !3 )53!5!,

-""&&!!,-6

) 3 ! !" " &4"1"!6

&34&6 34


10/62

9E

# " %&!3 , & -3 !! &

5&6%!"!'6

,&-3!""%&"6

, %

5 $!" % 5" '

"2%"!$0&"$ " &55 !"&

5!!!$3 ),)-3"$')"!)2, 6'7-" % $ ,) &-" $2'""1""$$'

2%)$"$ ) ,) -3 $ % %

,&-6


11/62


12/62

9

0 (

!! ! !! % " 3

>#"

77N #72:O2

>20+.#

"!!!32"2#%!"$&%

&%0"!3 6 D%6 6"%%"

$,&-",%!-6

,- !%"3

!!3"26

! 6 !'53

H8"H"H96 !'H3"H""!'5"6

!56 !3:3

2 D" #

3

0 (1

2!% "!

%!"!&"!#!,-"$!

0D!3 !! !1.H,1.HM- $!&! 1.H*


13/62

98

2 % 3 " %)'"&%".$$&"%$P7

2%!!5D"!%

3 !" !5',%5

-6

5,-!&

1.,-

= % D & $" !3;"$!!!%

0 1

,-D%&!

0!!3 !6 D6 ! D & D

%6 "6

!6$%)

6

.)5"4"1,-4"1H1.,-%


14/62

9;

0" (1

#"$

% " $ " $ $

0$ ()22%*

%5"!"

# " ! 2 " 5 ! ! . 73

!6 36 !!6

.6 3

.J#%

)3 " 3

" $ 6

13&5

0, (#

0 D


15/62

9@

$! ! ,& -" $ 3

!" 6 "6).J6

6 !&6 .

3 (

.%$!%"5%(


16/62

9A

3 4

.%

3

7#%&,! 3(-&%,!"7-#"",0((-"3

"3%%6 "3%

# $ & %" $

0((

5 67

.&$%

5 7

> $ % $ $

!%0&$!="

5 87

. &

%& && 5 5 " "!/

2%%&%"!/"!$!

"3

%6 %6


17/62

9G

%&6 %

5" '17

. ! % % &.!%3

!5%!626&5!6

2 ,-7!"!&D 0!%$ 5$,"!%"%-6


18/62


19/62

9L

)"$ $ %&""%"$

!%3

2!%,-"$%&!2"$%$&%!

. $!! %"%%!

05$3


20/62

E

!%6 $ !33## (

!"$%5",-6

" (" ! ! % #

5,-3

$%"$1

.%2>#"

"$%2$2""%$?

# & 3' 7%LEEEEEEE2$!"%3


21/62

9

7 $ % @Q"$R

.$2!" !" ! " !%

%

.%%%

7 '$ '

5 " %7$$ '# A 7; ' B+ A 7 $B 7%C ' ( DEDC'$'(('('(@7$&((

2D3

"!$%53'F33GH336 "!$%5!,-3

'F33GH3GH6

( '( ) , -( ) " STS=!%STS" ((,(-.'(%5( $%',-(UV"%)''7(' "

%!


22/62

="$("Q"!9L@EEEE#BTS%"5$5$

="(',-'(3

9


23/62

8

" !!'($ !%$" ! & $ WX !! &

" ,- $ ' % %5 "3

"


24/62

;

$""%F8$TF8D28:%28$""!&%E(TF8D2

(%F%2" 0 " !" " 0 ! " $ ! BYC" '!&

0"3 $6 3"!TFDY2Y"

$&5"&6 3%!"%BY #

'$(("BY#'$()(

)$3%'!&"5(

"(

0"&""!3

! !7%&!%$,%!(;-"5$%$%"%!'"%$ T7,(3(8- # ! "#"$!"&5!

!"$%$#"%$"!


25/62

@

#&"!,$$-7&%"&$%$

. ! #"!3J9E""%%$T7,3J9E-$""7""%#G"$3T7,3J9E"#G-7$"% " B"C" B6C , % $$$!!B"C-

(7 .'$2!"$7

#.J$%


26/62

A

7$%2"%#G"$6G$#G 6G,$

-"! 5 , ! - $ 7#, -

$&%%

",$!D!-$%$356

!%!""'(>'% )("$(((%5'($%)

',(-.

!'#''$"! "'0"('$'(%"! & 0 ' " WX ! % ! # &"$ % ) # &!(' "U!V


27/62

G

=%%!"$!!&!"B3C#"+9E3#9E

,:#%

$ .'$ '( '(" ! # " " '$"%!%$'"!'$" WTX # ! " " $W6X%!3

E6J'$AK@LB2 ! '$ ,%&'- !%'$++(+(+ %7$'"+$A-! ! ! & %!!'$

",- ( =+ (

&+)+AM'$B ( )" , -

3( (+ (=( +

( ), -

( ) (+ (( ((+ + '$$(+'$(+'$+

*- ( + 7 + (++

+, ( !

,-

( 7 ( ) @ + (

!&$"6161-,!- 2()@(AB),- )7&I+(

=+(7++,- )( ( 7 ( ) 10

A)(B *. A'B+ '( )$ 'A$(B

",- ( '$ ./+' + &

,- 7+ '$ &0 %111

+ 23),


28/62

K

-:#+ 2% "$

!.'$"%,-0

!"%&$%!"$.'$"$ . '$ , ! " @$-2!" > '$ ,JJJ -'$,1- # ! "4"@ 0!!!%EEEEEEE")8A"&@Z

2 [5" ! :02$ !6 !+;6 .'$6 !"216

! , % "$$6+9"%96" $ % ;-6 $ &! "%)! 6 " ! $!! % 6


29/62

L

!&N6

0-9 2)B5C,-

% ! % 6" E!(!!7O8 2! " $

!3!"

0%

(!%

".#\"/J#\"\6()2:F"

.+2:" .7" .7[" #F7" *:" M0" (" (>.." 2:" >:" >.F">.F9E" #" 2:*7" >" .#" .##" 02" 0./" 0.#"#2:7":#".:".:#".:##./:".:#0"72F:"72:"72:["7]" 7+.>" 7" 72(" 70.#" 77]" 7M\"7M0\"7M\":":[":6

" .:" .:".:+>:J" .:2(" .*" 2+2:." #*7]" 0.:#27" (#27"(2:*" (27[" (27[2:*" (.7" (]:\" (7" F#27"


30/62

8E

F2:*" F>:" F.:" F./[" [:" [\0F.#27"2:0"J">F">2:7">.F7">.F2:*">.F:.#27"M"M"#2:" 2:" 2:" .#" :F+2:.#27" :.#27" :.2:*":.7#27" :.72:*" 07.:" 0:2>" 0::J"0"0.277.:" 0.+" ]2>" :J" 7]" 7J/" 7>.0" 7>>"

7:##2I" 7#*" 7#*" 7#*0" 7#*0" 7\M" #27" 2:*"#"2:"7"*"*"*0"*0"/2+>>"I76 ( ! :7"

F02*.#" [>..J0" [\0>2:J"2:#M"2:#2">..J0"[".((7"./"./7":70.7"*>..J06

>" M" (2:#" (2M#">(" >:" >./" 2#" 0.0" 0>" 0" 2F[" 7["7+72""M"2"00"*>6

+" ." \0" 2:(." 27+>:J" 27" 27." 27>.F2>"

27:"27:.M"27:+"27("27M":":"\0

3(#%

!!%3

$562 !7$+)2)8!!

*F,+G+H+- (

EA5G5H5B;7,+G+H+- (E5G5H5

0.#,+G+H+- 2EGH2:,+G+H+- +G+H+M,+G+H+- +G+H+.:,)+)G+H+)- 6($.:,)+)G+H+)- 6($+7,- 9(,-2:,- 2&('(

(>..,"- 2&(7],- (((.:#,+- I7$!02,- *(T8"9;9@LA@8@KLGL:#,- 6(%$,E"9-*,+G+H+- 3($+G+H+

#T ,


31/62

89

,-0./,+- 2.#,+- 7

:.,- 6$*(>7"(>7

,- *(>7,- *(>76%2(,++G- 7 $! $ #$

" 2( !

$ " ! $G[..7,"+G+H+- 2'$(7$

5$"!$.#\,- 3((:./,- 37((*>..J0,)++- ( )(7$%

# !%7!!#!% "$

09

[>..J0,)++- ((7$% # ! %7!! #!%"$ 09

.(7,++++- . '$ ( ,T%" T-! ! !

)9).#,- 2

,$'-[,- (2%*>,- 9(>:,- 6(

>(,+- 22F[,+- 0


32/62

8

2#,++G- !G%&!

0,+-

2,- "

$>./,- %00,- %0.0,- % $&

%.::,+G+H+- +G+

H+0>,++G+G- P % % G

%&!G:

(*,+++)+P- 9) ,)-%%5 $" "T&!"T"T%")T$%" PT 9 E %&

:0,++)+')+P- 6 ' 5 : " " ! %

0,++)+')+P- 2P@7%0*,+++')+P- 2)


33/62

88

!$#2:,++- !)(

!$#0.#,++- ! $ !

$

#*,++- !($!$#+G+H+$"$ +G+H+#T ,


34/62

8;

!#%"!$%%0 0 " 5

" " !

5'%

)*

!!!!$73

"A1.+*1*)(+*1B3 1.5$!,$$-6 *1*)(5$!%2(,-"!$6

*15""$!$%2(,-"!=!3

T V &U &VT UT

5,%2(-!"%"

$03

!)!$"2(+>:J,- 52(,- 5,&^:D-2(.,- 52(>.F2>,- 5$

2(:,- 5$^:D2(:+,- 5


35/62

8@

2((,- 52(M,- 5#"%5%9"

!$$)`*%9_`""5

"$)3

"A"181A*BCSSCS9($'&*TSB

5!

" ! " 7 %!9"99LEE

(3

# 5!$#*> 5$%5#\ 5$%5!#\8AE 5!!58AE

!# 5!

%.:[ 5$%5$!:/.J#\7 5!!.#\ 5!

/J#\ 5$%!&/.J#\ 5!%!

\ 5$%5\( 5 ! !

!&. 0 %5 " $! 13*U,-"$

!#$"$%

9=*7%*G!9E

&0"%*G$3 E*5>VM0,"8-"$"

"%*"%*G$3E3*1AU*A*B+614A*B5-+3*UA*BB 80!EE9"$

3 E3*1AG>>C-CB@

9EE9!


36/62

8A

5"3

[. 5$%5

2: 5$%:./ 5!7.:# 5$%2 5!!2*> 5$%5

"%

&!"

#"EE85&"

( "" H 1 ( 7$ 1("%5!1G>>-

7 $ 5 $"B_C%

1($

$;%#

. !

$2!%5"!&$$ # 2$$

+ a (


37/62

8G

2 a ,


38/62

8K

,

3E98;@AGKLH5,-"DYZ

)$""39EE659KLEE69Z69D;6Y;EE2" .!""%,-$,"-%2+%R

#" 5 " 5 " $ ,- &

%

,G

2%%55

""5$,-P&%

,-((7

! $ $ ! !" !# $ " ! % #""$!!!$!"&%F

3 9LEE 9LE;7/19LEE09LE;"4$""4%(W>,

$

" ;" $"9LEE 9 " 9LEE ,$

9-89 " LLLL ,$L@K;A@-

9LE; " 9LE; ,$9-

89 " LLLL ,$L@GEE8-

2


39/62

8L

EEE&EL"EE& L#"KD@D9L"!KE9L

9L8E&9LLL"8E& LL#"KD@DLK"!K9LLK

7!!!""

"(W>,0%

3

" " ";;PPPP

!" PPPP , 5;-6

9D9DKL ! 9 KL"EDE8D9LLE ! 8 9LLE

@@PPPP+@@PPPP ! " PPPP

95)59LKE ! 9 9LKE" )5KE ! 9LKE

0$",-

`3`#"9A3G"9K3G39E2!%;#!%9"$0#3@3;E093@

$%

2$$!!!5,-" $ 0 " $,-&&"

(%&&"&%"5" $" " " $ #"$$3#%#

."%&",-"$3#0"$$

#!$5,-#$%$

$"%

7!6(


40/62

;E

7 $ % & "

# !3

F 5$"

: 5 ! ! % 6( " !

% 0$

0) 5%9EE#"E99EZ

!( 5,D@"

9 8D; - ( 5 .! %" " 9D 0 "%'"E8D;

7 5!39H89EEE

7 5 0 & !$" $ =

5 " !! $!%

# 5 >1P 7 $,H-

5 57 5 % "

""0! 5! $


41/62

;9

$'([

$$'%

0 5 , - $

,*- # " " % !& % )" % $D%"%&!

, " $ $%-%%&%"

0&!"$%"%3

"


42/62

;

0%!393

!3(6

,"(7(-6%$6

3 !3(6 !!bb*!"

6 "!6

2!%

"$%%!&'""%""%%"%

,-0$$3

$%6 ! ! bb* !

"6

0 $" % %

2 " $ & +

#9!"(7(6"! ",-

$,%

( ! !

,-


43/62

;8

$- /

0 '

% (

,'


44/62

;;

$"%!#$ $ , ) 5" -

% " %

" $!! &""5 % " $!! # $"

!2 $ *I

% $ " !"$,%-#)$

-

7&$!!0!(!!!$!!$

!

0

2 " 5"

0 ""

$ # $" % "% $" ! "% %

" $


45/62

;@

2!"!%&!&

34%

3(

0$3

!$!,!$-6

4 3( 6

$3("!&"&&)3("1$" ($

0$!!$! *($ 7 $$ ( ) ( ," $!$&5-0$6

0$3("%!%


46/62

;A

>, $-"

3,-",-"',F-",>-"'

,#>-,#-

>;,%

%5-6


47/62

;G

$1$%

*

E9EEEEEEEEEEEEEE8EEEEEEE;EEEEEEE@EEEEEEEAEEEEEEEGEEEEEEEKEEEEEEELEEEEEEE

9EEEEEEEE

+

++

* +

++

*

.03("

3&

0 ! $ ,5 4 "%&%)'$'-"$! ' $` %

!"$

3"6

!!)5"!!,'-&&5$%!

3$8

7!#

3,&%


48/62

;K

#"!"1("10$1"% . ' % ! "$41

3$

3-'

#"

"%5"$$``%.%!! ." " , -" !. 05"$%#7,-$"

!$&

30&%%

# !! '` `% , "

%-"$%!0"44!"

``!#$!

33#

0!!%3

!&46 5 5 ' , ! -

&'$42$'$((2%

!"$4 '$((6

!2($"%#"'"3( " ) ,!" -" &5

35

04$,$-*(7@53"(""6(*


49/62

;L

# " 5 2 $

5=


50/62

@E

""=

#%5)"!)"

;=& ! 2I'"

!!"!$!%&3 7"%!%

%)#"!'"'"$ & " %& ! ! ! + % )

7$!!!&%) 7$!!!%

) 75""

#$%;=-

& 2I '"!!"!$!%&3

c$'"""c%!%%)#""4""%

" ." )! " $ !!&$6

!!'")6 !!6 "

"%!%%)

9

0!$3

09

!"7" !!1.H0" $!!! % $ , 7 !

& ( 4


51/62

@9

&( -"

$"

0 7$!"

$ % "(" % 6 $!#"%!% " $ # % "&"&'7"%5,-" $ " "6

%X('!3

o 15"$",%-

o

2 ,3.-

%$$%3"&5!"3

o $5!! ! ,!& (" 0 " 7 0-6

o )5$6

o 15%


52/62

@

""!"&5%"6(,9-#"!",$9&" $ " -

*08 7$3

.J" )" $!!

0!%4

" " ! %

#)*

( $ ,- ( %>%("!%"%&$" % %5(

0 % (" $ ""(""((0$ % (5 ,6 (-"( , !-" $%$(,"(5-"$.J

# % % 5!" &5

!0%$ & &$ & ""(


53/62

@8

'

0!""("

0$("%$4

(5"$$$(

>1$%5

$! (57!.J$%("4


54/62

@;

"6

0(39#""!(

(=6(4

!! = ! % ! 5 " !

5!

7 $ % " !

5"!',"-

#"%& ! " $ % ! 2 "$%%!

%,-3!""#$%&!'!"()$%&!'

*+!,$-$%&!*+&!+.!&!/,*+*+!,)$%&!*+&!+.!&!/,*+*+!,$%&!

*+&!+.!&!/,*+*+!,0+$%&!*+&!+.!&!/,*+*+!.1$%&!*+&!+.!&!/

,*+*+!.23


55/62

@@

$%&!*+&!+.!&!/,*+!""#$%&!'!"()$%&!'*+!,$-$%&!*+&!.!&!/,*+*+!,)$%&!*+&!.!&!/,*+*+!,

$%&!*+&!.!&!/,*+*+!,0+$%&!*+&!.!&!/,*+*+!.1$%&!*+&!+

.!&!/,*+*+!.23$%&!*+&!+.!&!/,*+*+..!&45&!,*+,

$(

#!!!

0"4&&

"``&&!5"

$*(


56/62

@A

= 6 ( $ ! ,

% !- $ (G !"$.J#5! " $ ! % ! , - & & ! & 0 $4

,'

0)$4

$"!*(*(#6( ! " % 0 ! .J # ) "$

-8%

74"4&'%)0#

0&%

74"

4 & " %& 74


57/62

@G

3

7!4!

# " $ 0

5 0 % !5*""%"=$.J

5


58/62

@K

"?##

0$"5&&

"

";!%

2 ;: $%)%

>H: =%>H: !7[2(H: $%%

+ $%7[2(H+ $

&%7 +J70 P&

#> P

>H#> P& *%"%)"&

[. *%(;>H\ 7[2(H( >H7[2(H(8 '&>H# %)>H >H(8 #

";%2 ;+J70 $

$

: >H7[2(H: 27 %%>H 0

%5>H7[2(H 2!"

%5>HJ 2'a4


59/62

@L

:,%5'a4-

$'a4

( $!&

(8 >

7[2(H(8 >%5(L '>H>H(L $7[2(H(L $T,- >>HT,- 2=>H6,$- 2>H7[2(H3,- 2>H7[2(H`,'- $$%

%

>Hd,'&- %$>He,- $%

%>H7NFNf.7

$@%

9 +" #" " " +" F" " "' R WY"00"):"9LLA

"'48 "*"("2"EEE; ":2"'G>>>""9LLL@ 7""'WMRWY7R61""9LLGA :"0"'''G>>>""EEE


60/62

AE

(:=6+

>


61/62

A9

>%


62/62

9A PF:2+.:#0.(.2#> @A9G .#2(2:>2+.:>2@A9K (.M>2+.:>2 @G9L 7.>22f.#>727:>.((2 @G

%%

Microsoft Excel - Curs de Utilizare

Documents

Transcript of Microsoft Excel - Curs de Utilizare