Excel - Guia Aprendizaje Semana 4

TKGC QJXP[CN Dem{gj`c` Qjxp{cn `k Crxkg`j|clk Jgpxe`{ddjôg Jgpxe`{ddjô g cn mcgkle `k nct felct `k dãnd{ne< Mjdxeteap Kvdkn 8229

   t    e    g    c    j     h    m    e     n    e    D    t    e     n    t    e    `    e    p    c    x    c    r    e    p    g    k    j    m    j    d    e    g    e    D   <    C    G    K    T

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

Tkmcgc `k Aexmcdjeg Ge 0 Dcte Klkmrne< Jmrnkmkgpcx tki{xj`c`. qjgd{ncx njhxet ctí deme nc {pjnj|cdjôg `k rxeixcmct `k Qjt{cn Hctjd Pjkmre ktpjmc`e `k aexmcdjôg<

32 Fexct Tkmcgcnkt

Eh lkpjqe `k nc Tkmcgc 0 Dxkcx pchnct `jgãmjdct. pxchclcx deg mcdxet z dxkcx qígd{net'

@ktdxjrdjeg `kn Mcpkxjcn `k D{xte Ktpk mcpkxjcn `k d{xte d{xte kt {gc xkrxe`{ddjôg xkrxe`{ddjôg RCTE C RCTE RCTE `k net qj`kep{pexjcnkt' qj`kep{pexjcnkt' Nk rkxmjpk qjt{cnj|cx rex rex mk`je `k jmãikgkt jgaexmcpjqct dc`c {ge `k net meqjmjkgpet s{k `khk tki{jx rcxc cndcg|cx nct cdpjqj`c`kt `k Kgtkócg|c — Crxkg`j|clk — Kqcn{cdjôg' C`jdjegcnmkgpk. Mcgkle `k fkxxcmjkgpct Eaajdk 8229< KVDKN. pxck mcpkxjcn `k degt{npc kvpxc kg kn njgo @ED[MKGPET @ED[MKGPET @K CREZE. `kn mkgü rxjgdjrcn'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

RNCGPKCMJKGPE @KN DCTE KLKMRNE - [GJ@C@ 0 Gjdenãt gkdktjpc pkgkx pe`c nc jgaexmcdjôg s{k fc {pjnj|c`e `{xcgpk t{ pjkmre `k crxkg`j|clk. hcle tki{xj`c`. zc s{k nc jgaexmcdjôg s{k fcz degpkgj`c kg t{ njhxe `k Kvdkn kt `k {te kvdn{tjqe' C`kmãt `ktkc s{k t{t depj|cdjegkt ktpêg jg`krkg`jkgpkt `k t{ njhxe `k Acdp{xcdjôg `kpcnnc`c k jgaexmkt' Rcxc kn `ktcxxenne `k nc d{cxpc tkmcgc Gjdenãt gkdktjpc< 3' Pkgkx kg t{ njhxe pe`c nc jgaexmcdjôg {pjnj|c`c `{xcgpk nct pxkt tkmcgct cgpkxjexkt' cgpkxjexkt' 8' Pkgkx kn njhxe CxdfjqeDepj|cdjeg Cx dfjqeDepj|cdjeg''

MKPE@ENEIJC EHLKPJQE @K NC [GJ@C@ 0 Dxkcx pchnct `jgãmjdct. mcdxet z qígd{net kgpxk felct `k dãnd{ne' PKMCT REX @JCT @K AEXMCDJEG PKMC 3 Pchnct `jgãmjdct

PJKMRE KTPJMC@E @K AEXMCDJEG

Dxkcx derjct `k felct. meqkx felct. pchnct `jgãmjdct'

8 Fexct

PKMC 8 Ajnpxet pchnct `jgãmjdct

Jgtkxpcx Jgtkx pcx kgdchk|c`e z rjk `k rãijgc. crnjdcx ajnpxet

8 Fexct

PKMC 4 Tki{xj`c`

Rxepkikx Felct

8 Fexct

PKMC 0 Mcdxet

Mcdxet

8 Fexct

PKMC ; Qígd{net

Qígd{net

8 Fexct

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

32 FEXCT

PKMC 3< PCHNCT @JGCMJDCT 3' Pchnct `jgãmjdct 3'3' Derjcx felct `k njhxe' 3'8' Meqkx felct' 3'4' Jgtkxpcx Pchnc `jgãmjdc' 3'0' C`jdjegcx dcmret c {gc pchnc `jgãmjdc' 3';' Meqkx knkmkgpet `k {gc pchnc `jgãmjdc' 3'1' Dcmhjcx nc degaji{xcdjôg `kn ix{re qcnexkt'

P3 Derjcx Felct `k Njhxe

Tk dxkc {gc derjc `k nc felc acdp{xc`kpcnnk. acdp{xc`kpcnnk. rcxc nc ikgkxcdjôg `k {gc pchnc `jgãmjdc' 3' Fcdkx dnjd `kxkdfe tehxk nc felc Acdp{xc@kpcnnk' 8' @kn mkgü kmkxikgpk. fcdkx dnjd kg nc erdjôg meqkx e derjcx' 4' Kg nc qkgpcgc. tknkddjegcx deg dnjd nc felc Acdp{xc@kpcnnk' 0' Tknkddjegcx deg dnjd kn d{c`xe dxkcx {gc derjc' ;' @cx dnjd kg cdkrpcx'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

Meqkx Felct 3' Tknkddjegcx teg dnjd nc g{kqc felc dxkc`c &Acdp{xc@kpcnnk&8**' &Acdp{xc@kpcnnk&8**' @cx dnjd tehxk kn gemhxk' 8' Tehxk kn gemhxk `k nc felc. fcdkx dnjd tetpkgj`e' Tk qjt{cnj|cxc {gc felc kg mjgjcp{xc' Cxxctpxcxnc z {hjdcxnc `kncgpk `k nc felc JgaexmkPxjmktpxcn'

Jgtkxpcx Pchnc `jgãmjdc 3' Tknkddjegcx nc felc g{kqc. Acdp{xc@kpcnnk&8*' Acdp{xc@kpcnnk&8*' 8' Fcdkx dnjd tehxk nc den{mgc C' 4' Tknkddjegcx fctpc nc den{mgc O'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

0' ;' 1' 9'

Fcdkx dnjd kg nc rktpcóc jgtkxpcx' [hjdcx kn ix{re pchnct' Fcdkx dnjd kg nc ankdfc `k nc erdjôg pchnc `jgãmjdc' @kn mkgü qjt{cnj|c`e qj t{cnj|c`e tknkddjegcx tknkddjegcx deg dnjd nc erdjôg pchnc `jgãmjdc'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

6' Tk qjt{cnj|cxc nc qkgpcgc dxkcx pchnc' :' Fcdkx Dnjd kg cdkrpcx'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

Tk dxkc {gc g{kqc felc. nncmc`c felc8' Meqkx nc felc cn ajgcn `kn njhxe' Dcmhjcx kn gemhxk `k nc felc rex Jgaexmk@jgcmjd J gaexmk@jgcmjde' e'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

FKXXCMJKGPCT PCHNC @JGCMJDC

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

C`jdjegcx dcmret c {gc pchnc `jgãmjdc 3' Fcdkx dnjd tehxk net dcmret c metpxcx' Rcxc kn klkxdjdje tknkddjegcx deg {g dnjd net dcmret gemhxk `kn rxe`{dpe z qcnex'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

Meqkx knkmkgpet `k {gc pchnc `jgãmjdc 3' Tknkddjegk deg {g dnjd. kn dcmre qcnex. {hjdc`e kg kn ix{re xôp{net `k ajnc' 8' @kn mkgü qjt{cnj|c`e. qj t{cnj|c`e. tknkddjegcx tknkddjegcx meqkx c qcnexkt' 4' qkxjajdcx s{k kn dcmre fczc tj`e meqj`e'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

Dcmhjcx nc degaji{xcdjôg `kn ix{re qcnexkt

3' 8' 4' 0'

Fcdkx dnjd tehxk kn dcmre qcnex' @kn mkgü tknkddjegcx degaji{xcdjôg dcmre `k qcnex' @cx dnjd tehxk t{mc' Fcdkx dnjd kg cdkrpcx'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

P8

PKMC 8< AJNPXET PCHNCT @JGCMJDCT 3' Ajnpxet Pchnct `jgãmjdct c' Jgtkxpcx kgdchk|c`e z rjk `k rãijgc' h' Dxkcx ajnpxet'

Jgtkxpcx kgdchk|c`e z rjk `k rãijgc

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

Dxkcx ajnpxet 3' 8' 4' 0' ;'

Tknkddjegcx {gc dkn`c `k nc pchnc' @cx dnjd tehxk C0' Tehxk nc njtpc dcmret `k nc pchnc `jgãmjdc. `cx dnjd tehxk dcgpj`c`' Kg kn ãxkc xôp{net `k den{mgc tk qjt{cnj|c kn dcmre dcgpj`c`' Fcdkx dnjd tehxk kn dcmre dcgpj`c`' dcgpj`c`' @kn mkgü qjt{cnj|c`e. tknkddjegcx deg dnjd meqkx cn ajnpxe `k jgaexmk' j gaexmk'

Kg nc rcxpk t{rkxjex `k nc felc crcxkdk kn dcmre dcgpj`c`. ne d{cn jg`jdc s{k ktpc njtpe rcxc xkcnj|cx ajnpxet tehxk nc pchnc `jgãmjdc'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

1' Fcdkx dnjd tehxk nc ankdfc `kn jg`jdc`ex j g`jdc`ex `k ajnpxe' 9' @cx dnjd tehxk {gc `k nct erdjegkt njtpc`c' Rcxc kn klkxdjdje. `cx dnjd tehxk kn g{mkxe 4' 6' Dnjd kg cdkrpcx'

Gepc< Xkd{kx`k s{k rcxc s{jpcx kn ajnpxe tehxk {gc pchnc `jgãmjdc. fcic dnjd tehxk kn dcmre `k nc njtpc `k dcmret `k nc pchnc'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

PKMC 4< TKI[XJ@C@ 8' Tki{xj`c` c' Rxepkikx Felct `k {g Njhxe' h' @ktrxepkikx felct `k {g njhxe'

P4 Rxepkikx felct `k {g njhxe

Deme nc jgaexmcdjôg degpkgj`c kg nct felct `k dãnd{ne teg `k qjpcn jmrexpcgdjc rcxc Gjdenãt. kt `kpkxmjgcgpk degedkx degedkx nct fkxxcmjkgpct `k tki{xj`c` s{k retkk Kvdkn rcxc xkcnj|cx ktpc pcxkc' 3' Fcdkx dnjd tehxk nc felc rxe`{dpet' 8' fcdkx dnjd kg nc rktpcóc xkqjtcx' 4' Kg kn ix{re dcmhjet. `cx dnjd kg kn hepôg rxepkikx felc'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

0' ;' 1' 9'

Kg nc qkgpcgc `ktrnkic`c. `jijpcx {gc degpxctkóc rcxc `ktrxepkikx nc felc' @cx dnjd kg cdkrpcx' Degajxmcx nc degpxctkóc jgixktc`c' jgixktc`c' Rxktjegcx cdkrpcx'

Tk qjt{cnj|c. kn dcmhje `k erdjôg'

Gepc< Rxepkikx nct felct Qkg`k`exkt. dnjkgpkt z Acdp{xc@kpcnnk' Tki{jx kn mjtme rxedk`jmjkgpe' Xkd{kx`k s{k< D{cg`e {gc felc ktpc rxepkij`c. nc jgaexmcdjôg degpkgj`c kg knnc ge tk r{k`k me`jajdcx' Rcxc me`jajdcxnc. fcz s{k `ktrxepkikx nc felc'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

@ktrxepkikx Felct `k {g nj hxe 3' 8' 4' 0'

Tknkddjegc nc felc c `ktrxepkikx' Fcic dnjd kg nc ajdfc xkqjtcx' xkqj tcx' [hjs{k kn ix{re dcmhjet' dcmhjet' Fcic dnjd kg nc erdjôg `ktrxepkikx felc'

;' Jgixktcx nc degpxctkóc' degpxctkóc' 1' @cx dnjd kg cdkrpcx'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

PKMC 0< MCDXET 4' c' h' d' `'

Mcdxet I{cx`c njhxe fchjnjpc`e rcxc mcdxet' Cdpjqct rktpcóc rxeixcmc`ex' rxeixcmc`ex' [pjnj|cx k`jpex Qjt{cn Hctjd' [pjnj|cdjôg `kn mcdxe rcxc denedcx qcnex depj|cdjôg kg n kpxct'

P0

I{cx`cx njhxe fchjnjpc`e rcxc mcdxet Tk {pjnj|cxc {g rxeixcmc kg qjt{cn Hctjd deme mcdxe. mcdxe. rcxc re`kx qjt{cnj|cx kn qcnex `k nc depj|cdjôg kg nkpxct' 3' Fcdk dnjd tehxk kn hepôg eaajdk `k Mjdxeteap Kvdkn' 8' @kn mkgü kmkxikgpk. {hjdcx kn d{xtex tehxk nc erdjôg ixchcx deme' 4' Fcdk dnjd tehxk nc erdjôg njhxe `k Kvdkn Kv dkn fchjnjpc`e rcxc mcdxet'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

0' Tknkddjegcx nc {gj`c` e dcxrkpc c i{cx`cx kn njhxe' n jhxe' ;' @jijpcx gemhxk' 1' @cx dnjd kg i{cx`cx'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

Cdpjqcx rktpcóc rxeixcmc`ex 3' Fcdkx dnjd kg kn hepôg `k eaajdk `k Mjdxeteap Kvdkn' 8' Tehxk kn hepôg erdjegkt `k Kvdkn `cx dnjd' 4' @k nc qkgpcgc. tknkddjegcx deg {g dnjd nc erdjôg mãt axkd{kgpk' 0' Mcxdcx nc erdjôg ajdfc rxeixcmc`ex kg nc djgpc `k erdjegkt' ;' @cx dnjd kg cdkrpcx'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

[pjnj|cx k`jpe Qjt{cn Hctjd 3' Chxjx kn cxdfjqe `k pkvpe McdxeNkpxct' McdxeNkpxct' 8' Tknkddjegcx pe`c nc jgaexmcdjôg' 4' Derjcx nc jgaexmcdjôg' jgaexmcdjôg'

0' Tknkddjegcx kn njhxe `k pxchcle'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

;' Fcdk dnjd tehxk kn gemhxk `k nc n c felc Depj|cdjôg' 1' @cx dnjd kg nc rktpcóc rxeixcmc`ex' 9' Kg kn ix{re de`jie fcdkx dnjd kg nc erdjeg Qjt{cn Hctjd'

6' Kg kn k`jpex `k qjt{cn Hctjd. Fcdkx dnjd kg nc ankdfc `jtkóe' :' Tknkddjegcx deg {g dnjd nc erdjôg Me`{ne'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

32' Kg nc qkgpcgc kg hncgde. rkicx nc jgaexmcdjôg derjc`c derjc`c `kn cxdfjqe McdxetNkpxct' McdxetNkpxct' 33' Dkxxcx kn k`jpex `k Qjt{cn Hctjd'

38' Fcdkx dnjd kg nc felc depj|cdjôg `kn njhxe' nj hxe' 34' Tknkddjegcx deg {g dnjd. nct ajnc 48 — 44' 30' Jgixktcx nc tji{jkgpk aexm{nc< =mcz{td&Dnkpxct&L4;?2**

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

Tk qjt{cnj|cxc kn qcnex kg nkpxct `k nc dcgpj`c` dcnd{nc`c kg nc dkn`c L4;

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

PKMC ;< QJGD[NET 0' Qígd{net c' Ctjigcx gemhxkt c {g xcgie'

P;

Gepc< Ktpk njhxe. degpjkgk {gc felc nncmc`c depj|cdjôg. depj|cdjôg. nc d{cn tkxã nc hctk rcxc kn klkxdjdje rxer{ktpe' Tk qjt{cnj|cxcg kxxexkt zc s{k ktpk njhxe ge re tk qígd{net deg kn njhxe exjijgcn' Tk dxkcxcg net xcgiet rxe`{dpet z dnjkgpkt rcxc dxkcx kn qígd{ne deg kn njhxe exjikg Rxcdpjdc Mcdxe'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget

Ctjigcx gemhxkt c {g xcgie

9' 6' :' 32' 33' 38'

Chxjx kn njhxe. CxdfjqeDepj|cdjeg' CxdfjqeDepj|cdjeg' Fcdkx dnjd kg nc rktpcóc aexm{nct' Kg kn ix{re gemhxkt `kajgj`et. fcdk dnjd kg nc ankdfc `k nc n c erdjôg ctjigcx gemhxk c {g xcgie' Tknkddjegcx deg {g dnjd. @kajgjx gemhxk' Kg kn d{c`xe gemhxk. ktdxjhjx NjtpcDnjkgpkt' Kg nc erdjôg fcdk xkakxkgdjc c. ktdxjhjx< =_Rxcdpjdc3UMcdxe'vntm]D =_Rxcdpjdc3UMcdxe'vntm]Dnjkgpkt#$C<$I njkgpkt#$C<$I 34' Fcdkx dnjd kg cdkrpcx'

30' Dxkcx nc njtpc rcxc net rxe`{dpet' rxe`{dpet' Gepc< [gc qk| dxkc`e {g qígd{ne kgpxk net njhxet Rxcdpjdc3UMcdxe z CxdfjqeDepj|cdjeg. rxehcx s{k cn dcmhjcx kn gemhxk `kn dnjkgpk kg kn njhxe exjikg. qjt{cnj|cx deme tk me`jajdc kg kn njhxe CxdfjqeDepj|cdjeg'

TKGC Qjxp{cn

Tkxqjdje Gcdjegcn `k Crxkg`j|clk Degedjmjkgpe rcxc pe`et net Denemhjcget