258170223 Referat Tic Prodan Cristina

7/23/2019 258170223 Referat Tic Prodan Cristina

1/15

REFERAT

T.I.C

PRODAN CRISTINAAMG I_J


2/15

SCOALA POSTLICEALSANITAR FUNDENI PRODAN CRISTINA

AMG IJ

CUPRINS:

Cap. 1 - Programul Miro!o"# O""i$1.1. I%#ro&u$r$1.'. I!#ori

Cap. ' ( Pr$)$%#ar$a Pro$!orului D$ T$*#$ +or&'.1. I%#ro&u$r$'.'. M$%iuril$ pro$!orului &$ #$*#$ +or& ',1,

Cap. ( Pr$)$%#ar$a Pro$!orului E*$l ',1,.1. I%#ro&u$r$.'. El$m$%#$ ara#$ri!#i$

Cap. (R$ali)ar$a Diagram$lor i% +or& !i E*$l - ',1,.1. R$ali)ar$a &iagram$lor i% +or&.'. R$ali)ar$a &iagram$lor i% E*$l .'.1. I%#ro&u$r$ .'.'. Tipuri &$ &iagram$ .'.. E#ap$l$ r$ali)arii u%$i &iagram$

.'.. E*$mpl$ &$ &iagram$.

1. PROGRAMUL MICROSOFT OFFICE

1.1. INTRODUCERE


3/15


AMG IJMiro!o"# O""i$ !au MS O""i$ $!#$ o !ui#/ &$ program$ &$ 0irour$a#$ &$ "irma

Miro!o"# Corpora#io% ar$ !u%# 2%!oi#$ i &$ o apliai$ !p$ial/ !uprapu!/ lor p$%#rua$!ar$a u%i#ar/ !impl/.Aplia iil$ &$ 0irou i%lu!$ 2% MS O""i$ 3

Miro!o"# +or&4pro$!or &$ #$*#5 Miro!o"# E*$l4a%ali)/ &$ 0u!i%$!!i alul #a0$lar5 Miro!o"# Po6$rPoi%#4program p$%#ru pr$)$%#/ri gra"i$5 Miro!o"# A$!!4program p$%#ru0a)$ &$ &a#$5 Miro!o"# Ou#loo74ag$%&/i li$%# &$po#/ $l$#ro%i/5 Miro!o"# Fro%#pag$4$&i#or 8i)ual &$ pagi%i 6$05 Miro!o"# P9o#o E&i#or4$&i#or "o#ogra"i5

:i%$2%$l$! $*i!#/ i o"$r#$ 4pa9$#$5 &$ la Miro!o"# ar$ upri%& %umai o par#$ &i% a$!#$program$.

1.2. ISTORICE*i!#/ mai mul#$ 8aria%#$ al$ MS O""i$ prim$l$ "ii%& 8$r!iu%il$3., . ;


4/15


AMG IJ

2. PREZENTAREA PROCESORULUI DE TEXTE WORD.

2.1. INTRODUCERE

Miro!o"# +or& $!#$ u% pro$!or &$ #$*# mo&$r% ar$ "a$ par#$ &i% pa9$#ul &$program$ Miro!o"# O""i$ 2mpr$u%/ u Miro!o"# E*$l Miro!o"# Po6$rPoi%# >i Miro!o"#A$!!. Programul a?u#a la r$ali)ar$a &$ &oum$%#$ pagi%i &$ i%#$r%$# rapoar#$ &$!$%$ !aumo&$lar$ &$ #$*#$ 4"olo!i%& !u0programul +or&Ar#5.

Miro!o"# +or& $!#$ u%pro$!or &$ #$*#par#$ a !ui#$i 4grupului5 Miro!o"# O""i$.Num$l$ 2%#r$g $!#$ Miro!o"# O""i$ +or& &$i popular !$ %um$#$Microsoft WordMS Word!au &oar Word2% u%$l$ a)uri. Prima lui 8$r!iu%$ &a#$a)/ &i% 1;@"ii%& i%iial &i!po%i0il !u0%um$l$ &$ Mul#i-Tool +or& p$%#ru =$%i* !!#$m! &oar p$%#ru MS-DOS 4ul#ima 8$r!iu%$MS-DOS "ii%& B 2% 1;;5. % 1;@ Miro!o"# +or& a "o!# la%!a# i p$ 4a#u%i %oua5 pla#"orm/Appl$ Mai%#o!9 iar 2% 1;@; p$%#ru +i%&o6! Miro!o"# o%#i%u%& !/ !upor#$ am0$l$

pla#"orm$ p%/ a!#/)i. % 1;;'-1;; Miro!o"# a o"$ri# i o 8$r!iu%$ &$ +or& p$%#ru !i!#$m$

U%i*4mai pr$i! &i!#ri0uia SCO5 o"$r#/ ar$ 2%!/ a "o!# &$ "oar#$ !ur#/ &ura#/. $r!iu%$a$a mai r$$%#/ $!#$ +or& ',1, p$%#ru +i%&o6! r$!p$#i8 +or& ',,@ p$%#ru !i!#$m$Mai%#o!9 4"olo!i%& Ma OS = a## p$ ar9i#$#ur/ I%#$l# i Po6$rPC5.

Forma#ul %a#i8 a "o!# .&o &$ la 8$r!iu%$a 1 p%/ la +or& ',, &$8$%i%& &$ la +or&',,< .&o*4$*#$%!ia .&o* $!#$ "olo!i#/ 2% %oul !#a%&ar& i%#$r%aio%al O""i$ Op$% =ML

p$%#ru &oum$%#$l$ O""i$5. MS +or& $!#$ u%o!u# p$ pia/ 2% &om$%iul pro$!oar$lor &$#$*# a +HSI+HG4What You See Is What You Get5. Co%ur$%#ul pri%ipal al Miro!o"# +or&$!#$ Op$% O""i$+ri#$ al &oil$a $l mai "olo!i# program &$ !ri! &i% $l$ mai mul#$ /ri.

o Miro!o"# +or& %$ p$rmi#$ !/ r$ali)/m urma#oar$l$ op$raii3 r$ar$a >i or$#ar$a &oum$#$lor lurul u mai mul#$ &oum$%#$ #iparir$a &oum$%#$lor op$raii &$ au#ar$ >i 2%louir$ "orma#ar$a &oum$%#ului la %i8$l &$ ara#$r >i paragra" >i a&mi%i!#rar$a u%or !#iluri

&$ "orma#ar$ pr$&$"i%i#$ !au &$"i%i#$ &$ u#ili)a#or "orma#ar$a &oum$%#ului la %i8$l &$ pagi%/ 4margi%i ara%?ar$a 2% pagi%/ %um$ro#ar$a

pagi%ilor r$ar$a &$ a%#$#uri >i !u0!oluri !au %o#$ &$ !u0!ol >i !"r>i#5 a&mi%i!#rar$a u%or >a0loa%$ &$ &oum$%#$ i%!$rar$a #a0$l$lor 2% &oum$%#$ >i a&mi%i!#rar$a lor 4r$ar$ mo&i"iar$ "orma#ar$5 ara%?ar$a #$*#ului 2% oloa%$ a&mi%i!#rar$a or$!po%&$%$i r$ar$a >i "olo!ir$a maroom$%)ilor.

o MENIURILE PROCESORULUI MS.WORD 2010 M$%iuril$ pro$!orului &$ #$*#$ +or& !u%#3 File - o%i%$ op#iu%i p$%#ru lurul u "i>i$r$ &oum$%# 4K.&o !au K.&o*5 !au

>a0loa%$ &$ &oum$%#$4&o#.5 p$ ar$ l$ r$a)/ >i l$ a#uali)$a)/ +or& opiu%i p$%#ruop$raii &$ !al8ar$ pri%#ar$ !$uri#a#$ a &oum$%#ului $#.

View - o%i%$ opiu%i p$%#ru a !#a0ili mo&ul &$ a"i>ar$ a &oum$%#ului >i &$o%"igurar$ a "$r$!#r$i &$ apliai$ orga%i)ar$a "$r$!#r$lor &oum$%# al$ apliai$i.

Inse!- o%i%$ opiu%i p$%#ru i%!$rar$a >i "orma#ar$a 2% &oum$%#ul a#i8 2% po)iiaur!orului a &i"$ri#$lor $%#i#/i 4#a0$l$ pi#ur$ lip ar# !a0loa%$ !mar# ar# &iagram$a%#$# > i !u0!ol !im0oluri $#.5
http://ro.wikipedia.org/wiki/Procesor_de_texthttp://ro.wikipedia.org/wiki/Procesor_de_texthttp://ro.wikipedia.org/wiki/Microsoft_Officehttp://ro.wikipedia.org/wiki/1983http://ro.wikipedia.org/w/index.php?title=Xenix&action=edit&redlink=1http://ro.wikipedia.org/wiki/MS-DOShttp://ro.wikipedia.org/wiki/Applehttp://ro.wikipedia.org/wiki/Macintoshhttp://ro.wikipedia.org/wiki/Windowshttp://ro.wikipedia.org/wiki/Unixhttp://ro.wikipedia.org/w/index.php?title=SCO&action=edit&redlink=1http://ro.wikipedia.org/wiki/Windowshttp://ro.wikipedia.org/wiki/Mac_OS_Xhttp://ro.wikipedia.org/wiki/Intelhttp://ro.wikipedia.org/wiki/PowerPChttp://ro.wikipedia.org/wiki/.dochttp://ro.wikipedia.org/w/index.php?title=.docx&action=edit&redlink=1http://ro.wikipedia.org/wiki/WYSIWYGhttp://ro.wikipedia.org/wiki/Open_Officehttp://ro.wikipedia.org/wiki/Procesor_de_texthttp://ro.wikipedia.org/wiki/Microsoft_Officehttp://ro.wikipedia.org/wiki/1983http://ro.wikipedia.org/w/index.php?title=Xenix&action=edit&redlink=1http://ro.wikipedia.org/wiki/MS-DOShttp://ro.wikipedia.org/wiki/Applehttp://ro.wikipedia.org/wiki/Macintoshhttp://ro.wikipedia.org/wiki/Windowshttp://ro.wikipedia.org/wiki/Unixhttp://ro.wikipedia.org/w/index.php?title=SCO&action=edit&redlink=1http://ro.wikipedia.org/wiki/Windowshttp://ro.wikipedia.org/wiki/Mac_OS_Xhttp://ro.wikipedia.org/wiki/Intelhttp://ro.wikipedia.org/wiki/PowerPChttp://ro.wikipedia.org/wiki/.dochttp://ro.wikipedia.org/w/index.php?title=.docx&action=edit&redlink=1http://ro.wikipedia.org/wiki/WYSIWYGhttp://ro.wikipedia.org/wiki/Open_Office


5/15


AMG IJ Di% m$%iul Inse! pu#$m i%!$ra diagrame 49ar#5. Pro$!orul +or& "a$ ap$l la

apliaia E*$l p$%#ru r$ali)ar$a &iagram$lor &$ a$$a a$a!#/ opiu%$ !$ !#u&ia)/ maip$ larg 2% a&rul apliai$i E*$l.

"#$e - o%i%$ opiu%i p$%#ru "orma#ar$a #$*#$lor 4ara#$r$ paragra"$5 !$l$#ar$

&$upar$ lipir$ opi$r$ g/!ir$ 2%louir$ P%&e L%'#(! - o%i%$ opiu%i p$%#ru !$#ar$a pagi%ii "u%&al ara%?ar$a 2% pagi%/ $#. Re)een*es - o%i%$ opiu%i p$%#ru r$ali)ar$a upri%!ului i%#ro&u$r$a %o#$lor &$

!u0!ol i#a#$ >i 0i0liogra"i$ i%&$* ap#uri $#. M%ilin&s - o%i%$ opiu%i p$%#ru r$ar$a >i 2m0i%ar$a or$!po%&$%$i pliuri

$#i9$#$ $#. Re+iew- o%i%$ opiu%i p$%#ru or$i$ grama#ial/ #ra%!la#or om$%#arii m/!uri &$

pro#$i$

B


6/15


AMG IJ

,. PREZENTAREA APLICA-IEI DE CALCUL TAELAREXCEL.

,.1. INTRODUCERE

Mi*#s#)! E/*el $!#$ u% program &$ alul #a0$lar ar$ "a$ par#$ &i% !ui#a &$program$ MS O))i*e. A!#/)i $!#$ $l mai "olo!i# !o"#6ar$ p$%#ru alul #a0$lar u#ili)a# >ip$%#ru $"$#uar$a u%or pr$)$%#ari gra"i$.

A$!#a %$ o"$r/ urma#oar$l$ op$raii3 orga%i)ar$a >i pr$lurar$a &a#$lor !u0 "orm/ &$ #a0$l$ lurul u mai mul#$ #a0$l$ #ip/rir$a #a0$l$lor op$raii u 0louri &$ #$*#$ op$raii &$ /u#ar$ >i 2%louir$ "orma#ar$a #a0$lului 4&up/ !#iluri &$ "orma#ar$ pr$&$"i%i#$ !au &$"i%i#$ &$ u#ili)a#or5

"orma#ar$a &oum$%#ului la %i8$l &$ pagi%/ r$ar$a "orular$lor &$ i%#ro&u$r$a &a#$lor !or#ar$a &a#$lor &i% #a0$l$ p$ 0a)a u%ui ri#$riu &$"i%i# r$ali)ar$a &$ alul$ !#ra#i!#i$ >i !u0#o#aluri u 8aloril$ &i% #a0$l i%!$rar$a o0i$#$lor 2% #a0$l4imagi%i !u%$#$ $uaii &iagram$5 r$ar$a >i "olo!ir$a maroom$%)ilor $#.

E/!ensi% %s#*i%! )iieel# *( !%ele3 %4$inis!%!e 4e %5li*%6i% E/*el 3 es!e /ls.La%!ar$a 2% $*$ui$ !$ "a$ &i% 0u#o%ul S!%!3 All P#&%$s li p$ MS O))i*e 2010 7E/*el

Toa#$ program$l$ &$ alul #a0$lar op$r$a)/ u o !$ri$ &$ o%$p#$ !p$i"i$ ar$ !$rapor#$a)/ la o%$p#ul "u%&am$%#al &$ "oai$ &$ alul. Foaia &$ alul #a0$lar 2% imagi%$a

u#ili)a#orului $!#$ o ma#ri$ u al$ /r$i $l$m$%#$ !$ po# "a$ ori$ "$l &$ alul$ ari#m$#io-logi$. Compo%$%#$l$ $l$m$%#ar$ al$ u%$i "oi &$ alul !$ %um$! CELULE >i $l$ !u%#&i!pu!$ la i%#$r!$ia &i%#r$ li%ii >i oloa%$. D$ a$$a $!#$ %$$!ar p$%#ru a 2%$l$g$ #$9%ia &$luru u u% pro$!or &$ alul #a0$lar !/ !$ &i!u#$ ara#$ri!#iil$ urm/#oar$lor o%$p#$ &$

0a)/3 r$gi!#ru &$ luru r%& 4RO+5 oloa%/ 4COLUMN5 $lul/4CELL5 a&r$!/ 4ADRESS5)o%/ 4RANGE5 $#i9$#/ 4LA:EL5 "ormul/ 4FORMULA5 "u%i$ 4FUNCTION5.

,.2. MENIURILE PROCESORULUI MS. EXCEL 2010M$%iuril$ pro$!orului &$ alul #a0$lar E*$l !u%#3

File o%i%$ opiu%i p$%#ru lurul u "i>i$r$ 4K.*l! !au K.*l!*5 opiu%i p$%#ru op$raii &$!al8ar$ &$!9i&$r$ pri%#ar$ !$uri#a#$ a &a#$lor $#.

"#$e o%i%$ opiu%i p$%#ru "orma#ar$a ara#$r$lor paragra"$lor a %um$r$lor a$lul$lor i%!$rar$ !or#ar$ !$l$#ar$ &$upar$ lipir$ opi$r$ g/!ir$ 2%louir$

Inse! o%i%$ opiu%i p$%#ru 2%!$rar$a 2% &oum$%#ul a#i8 2% po)iia ur!orului a&i"$ri#$lor $%#i#/i4"oai$ &$ luru #a0$l pi#ur$ lip ar# >a0loa%$ !mar# ar# 4i%&%$ea%#$# >i !u0!ol !im0oluri $#.5

P%&e L%'#(! o%i%$ opiu%i p$%#ru !$#ar$a pagi%ii "u%&al mo&ul &$ pri%#ar$ ara%?ar$a2% pagi%a $#.

F#$(l%s o%i%$ opiu%i p$%#ru i%#ro&u$r$a "u%iilor D%! o%i%$ opiu%i p$%#ru impor#ul &a#$lor !or#ar$ "il#rar$ 8ali&ar$ !u0#o#al $#. Re+iew o%i%$ opiu%i p$%#ru or$i$ grama#ial/ #ra%!la#or om$%#arii m/!uri &$

pro#$i$ a "oilor &$ luruView o%i%$ opiu%i p$%#ru a !#a0ili mo&ul &$ a"i>ar$ a &oum$%#ului >i &$ o%"igurar$ a"$r$!#r$i &$ apliai$ orga%i)ar$a mo&ului &$ 8i)uali)ar$ a "oilor &$ luru


7/15


AMG IJ

,.,. ELEMENTELE CARACTERISTICE

A>a um !-a pr$i)a# mai !u! $l$m$%#$l$ ara#$ri!#i$ al$ apliai$i &$ alul #a0$lar !u%#3 )#ile 4e *%l*(l 4!pr$a&!9$$#5 r$pr$)i%#/ m$#o&a &$ orga%i)ar$ a &a#$lor !u0 "orm/

&$ #a0$l e&is!( 4e l(*( 46or70oo75 o%#i%$ mai mul#$ "oi &$ alul 4%!e o%i%u#ul u%$i $lul$ r$pr$)i%#/ o &a#a. E*i!#a mai mul#$ #ipuri &$ &a#$3 #ipul

%um$ri #ipul #$*# #ipul &a#/ al$%&ari!#i/ >i #imp #ipul logi e)eie% *el(lei 2% a&rul u%$i "ormul$ poa#$ "i "olo!i# o%i%u#ul $lul$i )#$(le "ormula $!#$ pr$$&a#/ &$ !$m%ul8. F(n*!ii 8 "ormul$ &$ alul pr$&$"i%i#$.

N($e9)(n*!ielis!%94e9%&($en!e;. E*i!#/ mai mul#$ #ipuri &$ "u%ii3 "u%ii ma#$ma#i$ !#a#i!#i$ "i%a%iar$ &a#$

al$%&ari!#i$ alul$ 2% 0a)a &$ &a#$ pr$lurar$a >irurilor &$ ara#$r$ $8alu/ri. !%el(l 5i+#! $!#$ u#il a#u%i %& a8$m u% 8olum "oar#$ mar$ &$ &a#$ p$ ar$ $!#$

gr$u !/ l$ !i%#$#i)/m >i !/ l$ a%ali)/m ma%ual. %)i%e% 4%!el#


8/15


AMG IJ

=. REALIZAREA DIA>RAMELOR ?N WORD @I ?N EXCEL.

=.1. REALIZAREA DIA>RAMELOR ?N WORD.

Pro$!orul +or& upri%&$ mul#$ #ipuri &$ &iagram$ >i &$ r$pr$)$%#/ri gra"i$. Da/a8$m E*$l i%!#ala# $*i!#/ po!i0ili#a#$a &$ a r$a &iagram$ E*$l 2% +or& "/%& li2% m$%iul Inse!( Oe*!7 Mi*#s#)! E/*el *B%!4!au Miro!o"# Grap9 C9ar#5.Diagram$l$ p$ ar$ l$ r$/m !$ 8or 2%orpora 2% +or& iar &a#$l$ &i% a$!#a !$ !#o9$a)/2%#r-o "oai$ &$ luru E*$l ar$ $!#$ 2%orpora#/ 2% "i>i$rul &i% +or&

=.2. REALIZAREA DIA>RAMELOR ?N EXCEL

=.2.1. INTRODUCERE

C$ $!#$ o &iagram/ O &iagram/ $!#$ o r$pr$)$%#ar$ gra"i/ a &a#$lor 2%#r-o "oai$ &$

alul. El$ &$mo%!#r$a)/ rapi& >i $"ii$%# %a#ura &a#$lor pr$)$%#a#$. aloril$ &i% $lul$l$ u%$i"oi &$ alul !au &a#$l$ !$l$#a#$ !u%# a"i>a#$ 2% &iagram$ a 0ar$ li%ii oloa%$ !$#oar$ &$$r !au !u0 al#$ "orm$.

Grup$l$ &$ &a#$ !u%# !$rii &$ &a#$ ar$ !$ &i"$r$%ia)/ pri% ulori !au mo&$l$.R$pr$)$%#%& &a#$l$ 2%#r-o &iagram/ $l$ po# "i mai lar$ mai i%#$r$!a%#$ &$ i#i#. Diagram$l$

po# a?u#a &$ a!$m$%$a la $8aluar$a &a#$lor >i la r$ali)ar$a u%or omparaii 2%#r$ &i"$ri#$8alori al$ u%$i "oi &$ alul.

%Excel o &iagram/ $!#$ r$a#/ &i%#r-u% ( >i l$ga#/ la u% ( #a0$l u &a#$ &i%#r-o "oai$ &$ luru.

A!#"$l $*i!#/ &ou/ 8aria%#$ &$ luru3

A. S$ poa#$ r$a o &iagram/ a p$ u% o0i$# gra"i 2%ap!ula# 2%#r-o "oai$ &$ luru

:. S$ poa#$ lura u o &iagram/ 2%#r-o "oai$ !$para#/ a u%ui r$gi!#ru.

A. Pentru a crea o diagram ncapsulat inclus ntr!o foaie de lucru" se procedea#i astfel$

15 S$l$#ai &a#$l$ &i% "oaia &$ luru p$%#ru ar$ !$ &or$>#$ !/ !$ r$$)$ &iagrama. Da/ !$&or$>#$ a Excel !/ opi$)$ $#i9$#$ &i% "oaia &$ luru 2% &iagram/ !$ i%lu&$ 2% !$l$ia"au#/ u% r%& >i!au o oloa%/ u i%#r/ri &$ #ip #$*#.

'5 S$l$#aiInsert !% &hart >i apoi 'n (his Sheet 42% a$a!#/ "oai$5 &i% !u0m$%iul &hart.

5 Po)iio%ai &i% %ou ur!orul mou!$-ului p$ "oaia &$ luru a$!#a 8a lua "orma u%$iruiuli$ 2%!oi#$ &$ o mi/ io%i/ r$pr$)$%#%& o &iagram/. E"$#uai li oriu%&$ 2%"oaia &$ luruExcel 8a !#a0ili &im$%!iu%$a i%iial/ a o0i$#ului &$ #ip &iagram/. 4Da/&orii !/ !#a0ilii 9iar &um%$a8oa!#r/ &im$%!iu%$a a$!#ui o0i$# #rag$i ur!orul mou!$-ului p$!#$ r$giu%$a 2% ar$ 8r$i !/ "i$ a"i>a#/ &iagrama. % mo& opio%al p$%#ru a r$a oa!$#/ p/#ra#/ p$%#ru &iagram/ m$%i%$i ap/!a#/ #a!#a Shift 2% #imp $ #rag$i ur!orulmou!$-ului p$!#$ a$a!#/ r$giu%$ iar p$%#ru a r$a o a!$#/ p$%#ru &iagram/ ar$ !/ "i$ali%ia#/ la r$$aua &$ li%ii a "oii &$ luru m$%i%$i ap/!a#/ #a!#aAlt 2% #impul &$pla!/rii

ur!orului. C%& ai #$rmi%a# &$ #ra!a# !upra"aa p$%#ru a"i>ar$a o0i$#ului &$ #ip &iagram/$li0$rai 0u#o%ul mou!$-ului.5

;


9/15


AMG IJ5 P$ $ra% 8a ap/r$a prima u#i$ &$ &ialog &hartWi#ard.

P$%#ru a r$a o &iagram/ u "orma#ul pr$!#a0ili# $"$#uai li p$ 0u#o%ul )inish.P$%#ru a r$a o &iagram/ u u% al# "orma# r/!pu%&$i "i$/r$ia &i%#r$ $l$ i%i u#ii &$ &ialog&hardWi#ard p$ m/!ur/ $ a$!#$a apar p$ $ra%. Pa*ii corespun#tori sunt descri*i ncontinuare+ n aceast sec,iune$ Forma#ul pr$!#a0ili# p$%#ru &iagram$ $!#$ a$la &$ &iagram/u oloa%$ >i l$g$%&/. Da/ %u !$l$#ai u% a%umi# "orma# &$ &iagram/ Excel 8a aplia a$!#"orma# %oii &iagram$. Pu#$i aplia "orma#ul pr$!#a0ili# ori/r$i &iagram$ &$?a r$a#$a#i8%&-o >i $"$#u%& li p$ 0u#o%ul -efault &hart 4&iagram/ pr$!#a0ili#/5 2% 0ara &$i%!#rum$%#$ &hart. Forma#ul pr$!#a0ili# poa#$ "i !9im0a#.

S$l$#ai o &iagram/ 2%ap!ula#/ $"$#u%& li u mou!$-ul p$ a$a!#a.

Pu#$i mo&i"ia &im$%!iu%il$ u%$i &iagram$ 2%ap!ula#$ #r/g%& u a?u#orul mou!$-uluir$p$r$l$ a$!#$ia !au o pu#$i mu#a la o %ou/ loai$ &i% "oaia &$ luru #r/g%& 2%#r$gul o0i$#&$ #ip &iagram/ u mou!$-ul. D$!$l$#ai o &iagram/ 2%ap!ula#/ $"$#u%& li oriu%&$ 2%"oaia &$ luru 2% a"ara &iagram$i. Pu#$i >#$rg$ o &iagram/ !$l$#%&-o >i ap/!%& #a!#a-el.

A$a!#a $!#$ &iagrama o0i%u#/ &upa $"$#uar$a $lor pa#ru pa>i 42% plu! $!#$ 2%!oi#/&$ 0ara opio%al/ !p$i"i/ $ &/ po!i0ili#a#$a u#ili)a#orului !/ "a/ ul#$rior $8$%#ual$mo&i"i/ri53

1,


10/15


AMG IJ

.Pentru a crea o nou diagram

1. % "oaia !ur!/ !$l$#ai &om$%iul u &a#$l$ p$%#ru ar$ &orii !/ r$ai o %ou/

&iagram/.'. S$l$#aiInsert - &hart. Di% !u0m$%iul &hart !$l$#aiAs /e0 Sheet 4a "oai$ %ou/5.

. P$ $ra% 8a ap/r$a prima u#i$ &$ &ialog &hartWi#ard 1ra2itorul de diagrame". P$%#rua r$a o &iagram/ 2% "orma#ul pr$!#a0ili# $"$#uai li p$ 0u#o%ul )inish a!#"$l

parurg$i #oa#$ $l$ i%i $#ap$ p$ m/!ur/ $ u#iil$ &$ &ialog or$!pu%)/#oar$ aparp$ $ra%. Excel 8a i%!$ra "oaia &iagram/ 2% r$gi!#rul a#i8 im$&ia# 2% !#%ga "oii &$luru a#i8$. S$l$#ai &om$%iul u &a#$ &i% "oaia &$ luru a#i8/ &up/ ar$ po)iio%aiur!orul mou!$-ului p$ #a0-ul "oii la 0a)a r$gi!#rului. E"$#uai li u 0u#o%ul &i%&r$ap#a p$%#ru a a"i>a m$%iul o%i! al "oii. S$l$#ai oma%&a Insert. Di% u#ia &$

&ialogInsert ar$ 8a "i a"i>a#/ !$l$#ai &hart >i $"$#uai li p$ O. P$ $ra% 8aap/r$a prima u#i$ &$ &ialog &hartWi#ard . .

E 3ine de ,inut minte$

15 %umai &a#$l$ %um$ri$ &i% $lul$ po# "i r$pr$)$%#a#$ gra"i u a?u#orul &iagram$lor

'5 &iagram$l$ !u%# 2%l/%ui#$ la &a#$l$ &i% ar$ au "o!# r$a#$ &up/ "i$ar$ a#uali)ar$ a&a#$lor %um$ri$ &i% "oaia &$ alul &iagrama a"$r$%#/ &a#$lor 8a "i a#uali)a#/ au#oma#

5 &a#$l$ %um$ri$ u#ili)a#$ 2% &iagram/ %u #r$0ui$ 2% mo& o0liga#oriu !/ "i$ !i#ua#$ 2% $lul$

8$i%$ a&i/ po# "i u#ili)a#$ >i r$giu%i %$a&ia$%#$ 42%!$am%/ /3 po# "i u#ili)a#$ >iom0i%aii mi*#$ &$ $lul$ >i grupuri &$ $lul$5

11


11/15


AMG IJ

=.2.2. TIPURI DE DIA>RAME

Di%&%$% *( *#l#%ne 4Colum%53 $!#$ u#ili)a#/ p$%#ru omparar$a 8alorilor &i"$ri#$ 2% a$la>ii%#$r8al &$ #imp

Di%&%$% *( %e4:ar53 $!#$ a!$m/%/#oar$ &iagram$i u oloa%$ $$a $ l$ &i"$r$%ia)/ $!#$"ap#ul / $l$ &ou/ a*$ !u%# i%8$r!a#$. Su%# u#ili)a#$ #o# p$%#ru a ompara 8alori &i"$ri#$ 2%#r-o p$rioa&/ &$ #imp.

1'


12/15


AMG IJ

Di%&%$% *( linii4Li%$53 $!#$ u#ili)a#/ p$%#ru a ilu!#ra $8oluia 2% #imp a u%$ia !au a mai

mul#or m/rimi i%&i%& #$%&i%$l$ >i proi$iil$

Diagrama circular (Pie): permite ilustrarea relaiei dintre prile unuintreg;

1


13/15


AMG IJ

Diagrama cu suprafee (Area): este similar celei cu linii i este utilizatpentru ailustra variaia n timp;

Diagrama inelar (Doughnut): este asemntoare diagramei circulare iilustreaz, ct reprezint fecare parte dintrun ntreg;

Diagrama radar (Radar): este utilizat pentru a ilustra relaiile dintredi!erite serii

de date i relaiile dintre fecare serie i toate celelalte;

1


14/15


AMG IJ

=.2.,. ETAPELE REALIZRII UNEI DIA>RAME.R$ali)ar$a &iagram$lor pr$!upu%$ parurg$r$a urm/#orilor pa>i31;Re%li%e% !%el(l(i. S$ i%#ro&u &a#$l$ !$l$#am #ipul &$ margi%i #ipul &$ &a#$ (#$*#

p$%#ru ap #a0$l >i %um$ri p$%#ru r$!#ul #a0$lului$# .

2;Ale&ee% !i5(l(i 4e 4i%&%$2% "u%i$ &$ rolul a$!#$ia.

,;Sele*!%e% #nei 5e *%e 4#i$ s # e5een!$ &%)i*.

=; E4i!%e% le&en4ei i % e!i*Be!el#.P$%#ru o%!#ruir$a &iagram$i !$ 8or "olo!i urm/#oar$l$ o0i$#$3

Z#n% 4i%&%$ei3upri%&$ 2%#r$aga &iagram/ i%lu!i8 l$g$%&a >i #i#lul. Z#n% &%)i*(l(i-!u%# r$pr$)$%#a#$ !$riil$ &$ &a#$ pri% pu%#$ li%ii 0ar$oloa%$ar$

&$ $r.$!#$ m/rgi%i#/ &$ a*$ >i upri%&$ mara?$l$ &a#$lor $#i9$#$l$ &a#$lor$#. A/ele / i '4>i ) &a/ &iagrama $!#$ r$pr$)$%#a#/ -D5 p$ a*a O* !u%# r$pr$)$%#a#$

*%!eiile 4e 4%!e iar p$ a*a O !u%# r$pr$)$%#a#$ +%l#ile 4%!el#.E*$pi$ "agra"i$l$ irular$4 ar$ %u au a*$5 &iagram$l$ &$ #ip 0ar$ 4ar$ i%8$r!$a)/ a*$l$5&iagram$l$ &$ #ip pu%#$4"olo!$! am0$l$ a*$ p$%#ru r$pr$)$%#ar$a 8alorilor5.

E!i*Be!ele %/el#4A*i! #i#l$5 %um$ ar$ !$ a#a>$a)/ a*$lor

1


15/15


AMG IJ M%*%e 4e 5e %/4Ti7 -mar75li%ii !ur#$ ar$ i%#$r!$#$a)/ a*a >i pu% 2% $8i&$%/

i%#$r8al$l$ 2% ar$ $!#$ 2mp/ri#/ a*/. E!i*Be!e 4e $%*%e 4e 5e %/e4#i7-mar7 la0$l!5!u%# %um$ !au 8alori a#a>a#$

mara?$lor &$ p$ a*a

M%*%e 4e 4%!e4 Da#a mar7$r5!u%# r$pr$)$%#/ril$ 2% &iagrama al$ &a#$lor &i% !$ria&$ &a#$ 4 pu%#$ li%ii &r$p#u%g9iuri ar$ &$ $r5. Sei% 4e +%l#i( grup &$ 8alori "olo!i#$ p$%#ru r$pr$)$%#ar$a &up/ o a*/.poa#$ "i lua#/

&i%#r-u% r%& !au &i%#r-o oloa%/ a #a0$lului !au a u%$i "oi &$ alul. E!i*Be!ele 4%!ei4Da#a la0$l!5 !u%# 8alori ar$ !$ a#a>$a)/ $l$m$%#$lor u ar$ $!#$

o%!#rui#/ &iagrama 40ar$ "$lii pu%#$5 p$%#ru a >#ii $*a# $ 8aloar$ r$pr$)i%#/. Le&en4% $!#$ pla!a#/ 2% a"ara )o%$i gra"iului >i !$ u#ili)$a)/ p$%#ru i&$%#i"iar$a

p/rilor &iagram$i.$a pr$i)$a)/ or$!po%&$%#a &i%#r$ uloar$ !au mo&ul &$ umpl$r$ >i%um$l$ &a#$i.

Ti!l(l 4C9ar# Ti#l$5 2% par#$a !up$rioar/ a &iagram$i. C%#i%(l 4Gri&li%$5r$$a &$ li%ii #ra%>a#$ p$ 8$r#ial/ >i!au p$ ori)o%#al/ ar$

2mpar#$ gra"iul 2% mai mul#$ )o%$. Lini% 4e !en4in6e4Tr$%&li%$5 r$pr$)$%#ar$ gra"i aa #$%&i%$i &$ $8olui$ a

&a#$lor.Nu poa#$ "i "olo!i#/ 2% &iagram$ D !au 2% $l$ &$ #ip irular. %ele 4e e#i 4Error 0ar!50ar$ gra"i$ i%lu!$ 2% &iagram$ p$%#ru a $*prima

$roril$ ar$ apar 2% r$pr$)$%#ar$a &a#$lor. Nu $!#$ o0liga#oriu !/ i%lu&$m 2% &iagrama li%ia &$ #$%&i%$ 0ar$l$ &$ $rori #i#lul

&iagram$i l$g$%&a $#i9$#$l$ a*$lor !au $#i9$#$l$ &a#$lor al#"$l &iagrama 8a &$8$%igr$u &$ i#i# >i &$ i%#$rpr$#a#.

;A$5l%s%e% 4i%&%$ei3-2% "oaia &$ alul ar$ o%i%$ &a#$l$ >i 8a "i #ip/ri#/ 2mpr$u%/ u &a#$l$

-2%#r-o "oai$ &$ alul !$para#/ &i% a$la>i r$gi!#ru ar$ 8a "i #ip/ri#/ !$para# &$ &a#$l$ &i%"oaia &$ alul.Dup/ $ am o%!#rui# &iagrama o pu#$m mo&i"ia r$&im$%!io%a mu#a !au r$"orma#/ 4%u

pu#$m r$&im$%!io%a o &iagram/ ar$ !$ a"la !i%gur/ p$ o "oai$ &$ luru5.Diagram$l$ !u%# ap$la#$ 8i)ual >i p$rmi# u#ili)a#orilor !/ o0!$r8$ u u>uri%/ omparaiimo&$l$ $8oluii >i #$%&i%$ 2% &a#$ "ii%& "oar#$ u#il$ 2% >i a8%& o larg/ aplia0ili#a#$ i%lu!i82% &om$%iul !a%i#ar "arma$u#i.

1B

258170223 Referat Tic Prodan Cristina

Documents

Transcript of 258170223 Referat Tic Prodan Cristina