taller casa excel 4 - funciones ii

5/7/2018 Taller CASA Excel 4 - Funciones II - slidepdf.com

http://slidepdf.com/reader/full/taller-casa-excel-4-funciones-ii 1/13

FJ_TFT\OFKJ LD\OMTFQM DL^MXTMILJTMC DFK_M OBFMFJAKXIMTFOM

Fj`* MCQMXK IMXTFJ _MCMWMX TMIMVKA\JOFKJL_ FF

TMCCLX DL M^XLJDFWMGL

Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm =

LGLXOFOFK A\JOFKJ _F

=* Bktlc _kc v ^cmvm

Cks `mstks dlc ~xfilx txfilstxl dlc Bktlc _kc v ^cmvm bmj sfdk7

Cms jÿifjms dlc ~lxskjmc dl cks ilsls dl Ljlxk v Alhxlxk 8< ifcckjls vdl Imxwk ?> ifcckjls*

Lj mcfiljtmofÿj => ifcckjls omdm ils* Lj lclotxfofdmd ~kx cks txls ilsls bm ~m`mdk => ifcckjls* Cks `mstks dl tlcæakjk dl cms kafofjms skj7 lc ~xfilx ils $?<4*>>> *# lc

sl`|jdk $?=<*>>> *# v lc tlxolxk $?0<*>>> * Cm ~ÿcfwm dlc sl`|xk dlc bktlc ls dl $?*4>2*>>>* mj|mcls# ~m`mdlxm

txfilstxmciljtl* Lc bktlc tfljl okjtxmtmdk |j slxqfofk dl imjtljfifljtk v ~m`m |jm

amot|xm iljs|mc dl $8<>*>>>** Tmihfæj tfljl okjtxmtmdk |j slxqfofk dl gmxdfjlxém ~kx $0<*>>>* mc ils

Lj Imxwk lc bktlc xljkqÿ lc 4>, dl s| cljolxém okj |j okstl dl$2<>*>>> *

Lc `x|~k i|sfomc Blximjks ^æxlw mjfim lc bktlc omdm jkobl okhxmjdk~kx mot|mofÿj $=1*>>>* Lj omxjmqmc sl kx`mjfwÿ |jm aflstm okj |j okstldl $=0<*>>>*

^mxm cm ~|hcfofdmd lc bktlc tfljl okjtxmtmdk |j slxqfofk m |jm Li~xlsm dlImxeltfj` ~kx $=>>*>>>* mc ils* Lj Imxwk# dlhfdk mc okifljwk dl cmtli~kxmdm mctm fjqflxtlj $8<>*>>>* iís lj ~|hcfofdmd*

^mxm cm ~xlqljofÿj dl xfls`ks tfljlj |j okjtxmtk okj |jm i|t|m ~kx$=*?>>*>>> * mc mýk* ^kx amctm dl cf}|fdlw mo|lxdmj ~m`mxcmiljs|mciljtl*

Cks fj`xlsks bmj sfdk cks sf`|fljtls7

=* Okik xls|ctmdk dl cm motfqfdmd bktlclxm lj Ljlxk# Alhxlxk v Imxwk#$<<*18>*>>>*# $42*0<>*>>>* v $46*=8?*>>>* xls~lotfqmiljtl*






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm 8

8* ^kx fjqlxsfkjls afjmjoflxms bm khtljfdk |jks xls|ctmdk dl =4# =1 v <

ifcckjls lj cks ilsls dl Ljlxk# Alhxlxk v Imxwk xls~lotfqmiljtl*

Lglxofofk7

=* Ok~fm lj |jm tmhcm dl Lrolc tkdks cks dmtks mjtlxfkxls*8* Bmccm lc tktmc dl cks `mstks l fj`xlsks lj omdm ils*?* Bmccm lc xls|ctmdk dl omdm ils* "Fj`xlsks ) @mstks&*4* Bmccm lc ~xkildfk dl omdm ~mxtfdm dl fj`xlsk v `mstk d|xmjtl cks txls

ilsls*<* Bmccm lc tmjtk ~kx ofljtk dl omdm ~mxtfdm dl fj`xlsk v `mstk lj xlcmofÿj

okj lc tktmc1* Bmw |jm aÿxi|cm lj cm }|l dl~ljdfljdk dl sf khtljliks hljlafofks k jk#

sl jks m~cf}|l lc ?<, dlc fi~|lstk dl skofldmdls*

_f bmv hljlafofks v sl jks m~cfom lc fi~|lstk dl skofldmdls »o|íc ls lcxls|ctmdk iljs|mc;* »V lc txfilstxmc;*






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm ?

LGLXOFOFK A\JOFKJL_ H\_OMXQ V _F

Lc sf`|fljtl lglxofofk okjsfstfxí lj omco|cmx lc tktmc dl |jm amot|xm dl~ljdfljdk dl cks~xlofks }|l tlj`miks mcimoljmdks*

Oxlmxliks |j cfhxk ccmimdk –Amot|xmofÿj*rcs’ }|l okjtljdxí dks bkgms*

Cm ~xfilxm bkgm dl lccm cm ccmimxliks –^xkd|otks’ v okjtljdxí |jm slxfl dl ~xkd|otks

lj cks }|l sl fjdfomxí lc oÿdf`k# dlsoxf~ofÿj v ~xlofk ~kx |jfdmd* Tljdxí lc sf`|fljtlms~lotk7

Cm sl`|jdm bkgm sl ccmimxí –Amot|xm’* Lsoxfhfxliks |j oÿdf`k dl mxtéo|ck dl cm bkgm

mjtlxfkx v jks m~mxlolxí s| dlsoxf~ofÿj m|tkiítfomiljtl lj cm olcdm dl cm dlxlobm*Tmihfæj jks m~mxlolxí lc ~xlofk |jftmxfk* C|l`k fjtxkd|ofxliks cm omjtfdmd dlslmdm vLrolc jks omco|cmxí lc tktmc dl omdm afcm# v lc tktmc dl tkdm cm okc|ijm* M~cfomxliks lcdlso|ljtk fjdfomdk sf lc ~m`k ls mc okjtmdk* ^mxm lcck dlhlxliks fjtxkd|ofx lc tf~k dl~m`k –okjtmdk’ }|l jk dlhl slx sljsfhcl m imv÷so|cms "dm f`|mc sf ck lsoxfhfiks lj

imv÷so|cms k ifj÷so|cms&* M~cfomxliks |j FQM dlc =1, v ikstxmxliks lc tktmc m ~m`mx*

Cm amot|xm dlhlxí tljlx lc sf`|fljtl ms~lotk7






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm 4

Omdm amot|xm sl oki~kjdxí dl < ~xkd|otks# }|l slxí jlolsmxfk fjdfomxkhcf`mtkxfmiljtl*






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm <

LGLXOFOFK AKXIMTK OKJDFOFKJMC

Lc sf`|fljtl lglxofofk okjsfstfxí lj cclqmx |j okjtxkc dl ljtxmdms v smcfdms dl dfjlxk mclstfck dl |jm o|ljtm okxxfljtl* Lj cm okc|ijm dlc Ljtxmdm sft|mxliks cms ljtxmdms dldfjlxk v lj cm okc|ijm dlc _mcfdm cms smcfdms* Cm ÷ctfim okc|ijm cm |tfcfwmxliks ~mxmcclqmx lc okjtxkc dlc smcdk# }|l sl omco|cmxí s|imjdk mc smcdk mjtlxfkx cm ÷ctfim ~ksfhclljtxmdm v xlstíjdkcl cm ÷ctfim ~ksfhcl smcfdm dl dfjlxk* _f lc smcdk ls jl`mtfqk dlhlxídl m~mxlolx lj okckx xkgk* _ÿck sl ~lxiftl |j okjol~tk ~kx ikqfifljtk*

Oxlmxliks |j cfhxk ccmimdk –Okjtxkc dl O|ljtm ’ okj |jm skcm bkgm ccmimdm –O|ljtm ’*

^mxm amofcftmx cm qfs|mcfwmofÿj v ljtxmdm dl aÿxi|cms# oxlmxliks ls~mofk ~mxm =>

ikqfifljtks*






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm 1

A|jofkjls H\_OMX# H\_OMXQ v H\_OMXB

A|jofÿj H\_OMX

MOTFQFDMD7

J|lstxm li~xlsm# dldfomdm cm dfstxfh|ofÿj v qljtm dl hlhfdmsxlaxlsomjtls# bm dlofdfdk "okik iætkdk dl ~xkikofÿj v qém dl fjqlstf`mofÿj dlilxomdk& ~xlifmx m m}|lccks okjs|ifdkxls }|l ljqélj cms ltf}|ltms dl cksxlaxlsoks dl dks cftxks m |j dltlxifjmdk m~mxtmdk dl okxxlks*

Mhxl |j j|lqk Cfhxk dl Lrolc v ccíimck ^xlifks *

Cm tmhcm dl okxxls~kjdljofm dl ~xlifks# }|l ok~fmxís lj lc xmj`k M67H=? dlcm Bkgm =# ls cm sf`|fljtl7

J· dl ~|jtks

^xlifk

<>> \jm omifsltm v |jm hkcsmdl~kxtfqm

=>>> \j pmceimj okj m|xfo|cmxls

8>>> \jm tkxxl dl i÷sfom

4>>> \j kxdljmdkx dl skhxlilsm

Mc omhk dl |j ils sl lcmhkxm cm cfstm dl cks ~xfilxks `mjmdkxls#fjoc|vljdk cks ~|jtks khtljfdks ~kx omdm |jk v lc ~xlifk }|l cls okxxls~kjdl*Lstm cfstm# mjtls dl fjtxkd|ofx cks ~xlifks okjsl`|fdks ~kx cks `mjmdkxls#~xlsljtm cm sf`|fljtl m~mxfljofm7

@mjmdkx J· dl ~|jtks

^xlifk






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm 0

Mjtkjfk H|lsm

Alxjíjdlw

1>>

Omtmcfjm Cm`k Blxxlxm =8>>

Xkhlxtk _|íxlw Ql`m 6>>

C|fs Alxxlx Ims 8=>>Mjm _íjoblw Tkxxls <>>

Gksæ Mckjsk ^mxxmKcfqlx

4><>

_l txmtm dl okjaloofkjmx dfobm cfstm# lj lc xmj`k M=7O0 dl cm Bkgm =# dlikdk }|l lc ~xlifk okjsl`|fdk ~kx omdm `mjmdkx m~mxlwom m|tkiítfomiljtl ljcm tlxolxm okc|ijm sÿck okj fjtxkd|ofx lc j· dl ~|jtks khtljfdk*

^XKOLDFIFLJTK7

^mxm lstk slxí jlolsmxfk xlo|xxfx m cm a|jofÿj H\_OMX* Lstm a|jofÿjh|som cm okxxls~kjdljofm okj lc qmckx dl |jm tmhcm lj ktxm tmhcm dfstfjtm* Ls÷tfc sfli~xl }|l lj cm sl`|jdm tmhcm sÿck bmvm |jm okxxls~kjdljofm ~mxm omdm

qmckx5 lj j|lstxk omsk# m omdm j· dl ~|jtks okxxls~kjdl |j skck ~xlifk*

\jm qlw ok~fmdms cms tmhcms fjdfomdms iís mxxfhm# sft÷mtl lj cm olcdm O8*Motfqm lc msfstljtl ~mxm a|jofkjls v slcloofkjm# lj Omtl`kxéms dl a|jofkjls #H÷s}|ldm v xlalxljofm# v lj –Jkihxl dl cm a|jofÿj ’# cm a|jofÿj H\_OMX* Lj lco|mdxk dl dfíck`k (_lcloofkjmx mx`|iljtks ( slcloofkjm cks mx`|iljtks(qmckx[h|somdk5imtxfw (*

Lj lc mx`|iljtk (qmckx[h|somdk (# slcloofkjm cm olcdm H8 "}|l okjtfljl lc

j· dl ~|jtks khtljfdk ~kx lc `mjmdkx&*

Lj lc mx`|iljtk (imtxfw (# slcloofkjm lc xmj`k dl olcdms M=>7H=? "dkjdl sllstmhclolj cms okxxls~kjdljofms dl j· dl ~|jtks okj ~xlifks*






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm 2

^|csm FJTXK v lj cm olcdm O8 m~mxlolxí lc ~xlifk okxxls~kjdfljtl*

O|mjdk cm a|jofÿj jk ljo|ljtxm lj cm imtxfw slcloofkjmdm jfj`÷j qmckxokfjofdljtl okj lc }|l bliks fjtxkd|ofdk# slcloofkjm lc }|l iís sl cl m~xkrfim~kx mhmgk "~*lg# okjsfdlxmxí }|l ck iís m~xkrfimdk m 6>> ls <>>&*

^mxm ~kdlx ok~fmx lstm aÿxi|cm m cms olcdms O? m O0 ls jlolsmxfk okjqlxtfxcm xlalxljofm m cm imtxfw lj |jm xlalxljofm mhskc|tm5 ~kx tmjtk# dlhlxísikdfafomx cm aÿxi|cm ~mxm }|l }|ldl msé7 9H\_OMX"O85$M$=>7$H$=?&* Tmihfæja|jofkjmxém okj xlalxljofms ifrtms7 9H\_OMX"O85M$=>7H$=?&*

\jm qlw ikdfafomdm cm aÿxi|cm# oÿ~fmcm m cms olcdms O? m O0*

Mbkxm# fjtxkd|ol cks dmtks (jkihxl v m~lccfdks ( v (j· dl ~|jtks ( lj lcxmj`k M87H0 v khslxqm oÿik sl fjtxkd|olj m|tkiítfomiljtl cks ~xlifksokxxls~kjdfljtls*

A|jofkjls H\_OMXQ v H\_OMXB

Lstms a|jofkjls skj jlolsmxfms lj m}|lccks omsks lj }|l cm imtxfw lj cm}|l xlmcfwmiks cm h÷s}|ldm tfljl iís dl 8 okc|ijms "k afcms&* Lj tmcls omsks# slbm dl fjdfomx lj }|æ okc|ijm "H\_OMXQ& k afcm "H\_OMXB& sl bm dl h|somx cmokxxls~kjdljofm }|l }|lxliks=*

A|jofÿj H\_OMXQ

_|~kj`miks }|l lj lc lglxofofk mjtlxfkx# lj cm tmhcm dl okxxls~kjdljofmssl fjoc|vlj cks dmtks xlcmtfqks m txls ~xkikofkjls dfalxljtls7

=Jk khstmjtl# dmdk }|l lstms a|jofkjls tmihfæj ~|ldlj slx |tfcfwmdms lj cks omsks lj }|l cm imtxfw dl

h÷s}|ldm sÿck tfljl 8 okc|ijms "k afcms&# m ~mxtfx dl mbkxm ~xlsofjdfxliks dl cm a|jofÿj H\_OMX v jks

oljtxmxliks lj H\_OMXQ "~xfjof~mciljtl& v lj H\_OMXB






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm 6

J· dl ~|jtks

^xlifks ~xki* = ^xlifks ~xki* 8 ^xlifks ~xki* ?

<>>\jm omifsltm v |jmhkcsm dl~kxtfqm

\jm ljtxmdm ~mxm lcofjl

\jm s|soxf~ofÿj m cmxlqfstm (^xkjtk(

=>>>\j pmceimj okjm|xfo|cmxls

\jm ljtxmdm ~mxm lctlmtxk

Lc cfhxk (Ifc xloltms dlokofjm(

8>>> \jm tkxxl dl i÷sfom \jm ljtxmdm ~mxm lca÷thkc

\jm qmgfccm oki~cltm

4>>>\j kxdljmdkx dlskhxlilsm

\jm ljtxmdm ~mxm cmÿ~lxm

\j qfmgl m ^mxés ~mxmdks ~lxskjms

M~xkqlobmjdk cks jkihxls dl mjtls v lc j· dl ~|jtks# s|~kjdxliks }|l#lj c|`mx dl ~mxtfof~mx lj cm ~xkikofÿj = ck bmj blobk lj cm ~xkikofÿj 8*

Omihfm m cm Bkgm 8 dlc Cfhxk motfqk# bmofljdk ocfo skhxl cm ~lstmým

okxxls~kjdfljtl m cm Bkgm 8*

Cks dmtks sl dfs~kjdxíj dlc ifsik ikdk }|l lj lc lglxofofk mjtlxfkx*7 ~kxtmjtk# ok~fm lc okjtljfdk dlc xmj`k M=7O0 dl cm Bkgm = lj lc ifsik xmj`k dlolcdms dl cm Bkgm 8* Bmw ck ifsik okj lc xmj`k M67H=?* C|l`k# omihfm "lj cmBkgm 8& lstm ÷ctfim tmhcm bmstm }|l tlj`m lc ms~lotk dl cm tmhcm okj cms txls~xkikofkjls*

_ft÷mtl lj cm olcdm O8 v motfqm lc msfstljtl ~mxm a|jofkjls*

Lj Omtl`kxéms dl a|jofkjls # slcloofkjm H÷s}|ldm v xlalxljofm * Lj Jkihxl

dl cm a|jofÿj # slcloofkjm H\_OMXQ

Lj lc mx`|iljtk Qmckx[h|somdk # slcloofkjm cm olcdm H8*






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm =>

Lj lc mx`|iljtk Imtxfw[h|somx[lj # slcloofkjm lc xmj`k M=>7D=?

Lj lc mx`|iljtk Fjdfomdkx[okc|ijms # lsoxfhl ? "ls dlofx# cm tlxolxmokc|ijm dl cm imtxfw&

Lj lc mx`|iljtk Kxdljmdk # jk ls jlolsmxfk }|l fjtxkd|woms jmdm

^|csm FJTXK*

\jm qlw iís# ~mxm ~kdlx ok~fmx cm aÿxi|cm m cms olcdms okjtf`|ms slxí

jlolsmxfk okjqlxtfx cm xlalxljofm m cm imtxfw lj |jm xlalxljofm mhskc|tm "kifrtm& dlc ikdk vm qfstk mjtls*

A|jofÿj H\_OMXB

A|jofkjm dlc ifsik ikdk v lj cks ifsiks omsks }|l H\_OMXQ* Cmdfalxljofm xmdfom lj }|l H\_OMXB sl |tfcfwm o|mjdk cks dmtks dl cm imtxfwlstíj dfs~|lstks dl akxim bkxfwkjtmc*

LGLI^CK7

Ok~fm cm tmhcm dl okxxls~kjdljofms sft|mdm lj lc xmj`k M=>7D=? dl cmBkgm 8 m cm Bkgm ?# dl akxim }|l cks dmtks sl dfs~kj`mj lj bkxfwkjtmc v jk ljqlxtfomc* ^mxm lcck# sf`|l cks sf`|fljtls ~msks7

_lcloofkjm lc xmj`k M=>7D=? dl cm Bkgm 8 v ~|csm lc hktÿj Ok~fmx

Omihfm m cm Bkgm ? bmofljdk ocfo lj s| ~lstmým* _ft÷mtl lj cm olcdmM=>*

_lcloofkjm Ldfofÿj dlc ilj÷ ~xfjof~mc5 lcf`l cm k~ofÿj ^l`mdk ls~lofmc






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm ==

Lj lc o|mdxk dl dfíck`k }|l m~mxlol# motfqm cm omsfccm dl qlxfafomofÿjTxms~kjlx * C|l`k ~|csm Mol~tmx *

^|csm cm tlocm Lso ~mxm }|l dlsm~mxlwom lc hkxdl fjtlxiftljtlmcxldldkx dl cms olcdms ok~fmdms*

Lj lc xmj`k dl olcdms M=7O0 dl cm Bkgm ?# ok~fm cm tmhcm sft|mdm lj lstmsifsims olcdms dl cm Bkgm 8*

_ft÷mtl lj cm olcdm O8 v motfqm lc msfstljtl ~mxm a|jofkjls5 slcloofkjm cma|jofÿj H\_OMXB* M okjtfj|mofÿj# k~lxm dl cm ifsim akxim }|l okj H\_OMXQsmcqk lj o|mjtk m cm imtxfw m slcloofkjmx# }|l slxí M==7D=4*

Lc mx`|iljtk –Kxdljmdk’ lj cm a|jofÿj H\_OMXQ

Okik vm sl bm qfstk# lc o|mxtk mx`|iljtk dl cm a|jofÿj H\_OMXQ ls lc dlKxdljmdk * Lj lstl mx`|iljtk jk ls jlolsmxfk fjtxkd|ofx jmdm sfli~xl }|l cm

tmhcm dl okxxls~kjdljofms lj cm }|l sl xlmcfwm cm h÷s}|ldm lstæ kxdljmdm ljsljtfdk msoljdljtl "lj a|jofÿj dlc qmckx dl cm ~xfilxm okc|ijm5 ~*lg# lj cm tmhcmdl okxxls~kjdljofms dl ~xlifks lj cm motfqfdmd mjtlxfkx&*

Bmv omsks# sfj lihmx`k# lj }|l cm tmhcm lj cm }|l sl xlmcfwmxí cm h÷s}|ldmjk lstí kxdljmdm dl lstm akxim* Lj tmcls omsks# ls jlolsmxfk fjtxkd|ofx okiko|mxtk mx`|iljtk dl cm a|jofÿj cm ~mcmhxm AMC_K "okj ck }|l sl fjdfom mc~xk`xmim }|l cm tmhcm lj o|lstfÿj jk lstí kxdljmdm&*

LGLI^CK7 Fjslxtm |jm j|lqm bkgm "Bkgm 4& lj lc Cfhxk ^xlifks * Oxlm lj lccm lc

sf`|fljtl ikdlck dl ~ldfdk "xmj`k M=7D=<&7






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm =8

BLXIMJK_ Cß^LW

O+ Xkilxk# 6>4=>48 _LQFCCM

^LDFDK J· ALOBM7

Oÿd*

dlstfjmtmxfkDlstfjmtmxfk7

OKJDFOFKJL_

Akxim ljqék ^cmwk ljtxl`mAkxim ~m`k C|`mx ljtxl`m

Omjtfdmd Mxtéo|ck ^xlofk |jft* Fi~kxtl tktmc

Lj cm ifsim bkgm# iís mhmgk# oxlm cm sf`|fljtl tmhcm dl okxxls~kjdljofms7

Oÿdf`k dlstfjmtmxfk

Dlstfjmtmxfk Akxim ljqék

Akxim ~m`k

^cmwk ljtxl`m

C|`mx ljtxl`m

T?8TmcclxlsXmiéxlw

Mæxlk Mc okjtmdk 84 bs* Aíhxfom

ME0ImvkxfstmsOljtxmcls Omifÿj

M~cmwmdk"?>d*+qtm*&

? déms Mcimoæj

J=8 Lc dldmc# _C Txlj Mc okjtmdk 8 déms Mcimoæj






Alobm7G\CFK 8>

Oÿdf`k

Qlxsfÿj7 =

^í`fjm =?

M okjtfj|mofÿj# lj cms olcdms dlc ikdlck dl ~ldfdk okxxls~kjdfljtls m cks

dmtks dl Dlstfjmtmxfk# Akxim ljqék# Akxim ~m`k# ^cmwk ljtxl`m v C|`mx ljtxl`m fjtxkd|ol a|jofkjls H\_OMXQ dl akxim }|l mc lsoxfhfx lc oÿdf`k dlcdlstfjmtmxfk m~mxlwomj m|tkiítfomiljtl cks dmtks okxxls~kjdfljtls m dfobkoÿdf`k*

Lj lstl omsk# dmdk }|l cm tmhcm dl okxxls~kjdljofms jk lstí kxdljmdm#dlhlxís bmolx |sk dlc 4· mx`|iljtk dl cm a|jofÿj# tmc okik sl bm lr~cfomdkiís mxxfhm*

taller casa excel 4 - funciones ii

Documents