excel - 2do básico (formulas y funciones)
TRANSCRIPT
-
7/21/2019 Excel - 2do Bsico (Formulas y Funciones)
1/11
PBJTRB\_
B]LBE
-
7/21/2019 Excel - 2do Bsico (Formulas y Funciones)
2/11
Odtas ob ed PbjTubst;
Hafjrb obe Dutar; Kar`b Debkdhora Lruz Mbrhhobz Gogafd; Bspdae
Hgvbe Bouldtgva; Jsglarbd ob Lahalgfgbhta; Ghiarftgld ^ds; @udtbfded
Ghtraoullgh;
Fs. Bxlbe bs uhd dpegldlgh qub pubob rbdegzdr ogvbrsds tdrbds, bsaeulgh ob prajebfds latgogdhas sb rbsaevbrh ob fdhbrd sbhAptgfgzdhoa be tgbfpa bh be trdtdfgbhta, dhegsgs y prbsbghiarfdlgh. Bh bstd dltgvgodo obsdrraeedrbfas tbfds lafIuhlgahbs jsglds, eds ludebs obsdrraeedrdh be pbhsdfgbhta supbrgob ogvbrsds sgtudlgahbs.
-
7/21/2019 Excel - 2do Bsico (Formulas y Funciones)
3/11
_drbd;Be ajkbtgva ob bstd Pbjqubst bs qub eds y eas bstuogdhtbs obsdrraeebh lafpbtbhlgds jsglds bh be usa iuhlgahbs, bhtrb atras, qub pbrfgtdh rbdegzdr lelueas, dhegsgs y prbsbhtdlgh ob ed ghiarfdlgh
Zbsubevd ea sg`ugbhtb;
4.- _djed ob fuetgpegldr, utgegzdhoa hgldfbhtb irfueds. (pdrd ldod uha ob eas odtas objbs utgegzdr lbeods
-
7/21/2019 Excel - 2do Bsico (Formulas y Funciones)
4/11
:.- Ldelueb be prafboga ighde ob ] dsg`hdturd, utgegzdhoa iuhlgahbs ob Fs. Bxlbe
-
7/21/2019 Excel - 2do Bsico (Formulas y Funciones)
5/11
-
7/21/2019 Excel - 2do Bsico (Formulas y Funciones)
6/11
?.- Bedjarb uh ghvbhtdrga ob ed _gbhod ED JBHOGLGH, ldelueb ea sg`ugbhtb;
d. ^rblga sgh GYDj. GYDl. Ghvbrsgh (tatde).
-
7/21/2019 Excel - 2do Bsico (Formulas y Funciones)
7/11
2.- Bedjarb dpegldlgh pdrd ldeluedr be lahsufa ob ldeards bh Fukbrbs y Mafjrbs. Bhobjb saeglgtdr, pgod be pbsa bh egjrds, deturd bh fbtras y ed bodo.
Irfued pdrd mafjrbs; 99.2 + 4
-
7/21/2019 Excel - 2do Bsico (Formulas y Funciones)
8/11
^ralbsa;
4.- Dhatb bh ed makd 4 ob Fs. Bxlbe, ed ghiarfdlgh qub bhlahtr bh Ghtbrhbt ob ea sg`ugbhtb
d. Tu bs uhd iuhlgh1
j. Lude bs ed ogibrbhlgd bhtrb uhd irfued y uhd iuhlgh ob Fs. Bxlbe1
l. Ludebs sah eds pdrtbs / lafpahbhtbs ob uhd irfued bh Fs. Bxlbe1
o. Ludebs sah eds pdrtbs / lafpahbhtbs ob uhd iuhlgh ob Fs. Bxlbe1
b. Tu bs uh rdh`a bh Fs. Bxlbe1
i. Tu bs uhd iuhlgh sgfpeb1
`. Tub bs uhd iuhlgh lafpubstd1
-
7/21/2019 Excel - 2do Bsico (Formulas y Funciones)
9/11
Zblursas;
mttp;//jdkdrobpbsalahibegx.laf/ludhtds-ldeargds-obja-lahsufgr/
mttps;//www.yautujb.laf/wdtlm1v6`x=M[e=LxGa
mttps;//bxlbetatde.laf/iarfueds-y-iuhlgahbs-ob-bxlbe/
mttps;//bxlbetatde.laf/iarfueds-ob-bxlbe/
mttp;//www.bxlbeiuhltgahs.hbt/Bxlbe-Iarfueds.mtfe
mttp;//www.bxlbeghtbrfboga.laf/1s6iarfueds
mttp;//www.bxlbeghtbrfboga.laf/iuhlgahbs-ob-bxlbe/
http://www.excelintermedio.com/funciones-de-excel/https://exceltotal.com/formulas-de-excel/https://exceltotal.com/formulas-y-funciones-de-excel/http://www.excelintermedio.com/funciones-de-excel/http://www.excelintermedio.com/?s=formulashttp://www.excelfunctions.net/Excel-Formulas.htmlhttps://exceltotal.com/formulas-de-excel/https://exceltotal.com/formulas-y-funciones-de-excel/https://www.youtube.com/watch?v=gx8HZl8CxIohttp://bajardepesoconfelix.com/cuantas-calorias-debo-consumir/ -
7/21/2019 Excel - 2do Bsico (Formulas y Funciones)
10/11
Bvdeudlgh;
Lrgtbrgas d Bvdeudr Ydear ^uhtba
Ogsba; Laear, Bstgea,Lrbdtgvgodo, Bspdlga.
: pts.
Irfueds y iuhlgahbs; _aoaiuhlgahd larrbltdfbhtb
2 pts.
^rbsbhtd eds 2 dltgvgodobsighdegzdods bh og`gtde bgfprbsa.
< pts.
_atde 4> pts.
-
7/21/2019 Excel - 2do Bsico (Formulas y Funciones)
11/11
Lahleusgh4. Eds irfueds bh Bxlbe sah bxprbsgahbs qub sb utgegzdh pdrd rbdegzdr lelueas
pralbsdfgbhta ob vdearbs, praoulgbhoa uh hubva vdear qub sbr dsg`hdoa d lude sb ghtraoulb oglmd irfued. Eds irfueds ob Bxlbe sgrvbh pdrd idlgegtdrh
fbogdhtb iuhlgahbs y atras.
:. Eds iuhlgahbs sah pdedjrds rbsbrvdods, eds ludebs tgbhbh dr`ufbhtas qub p
lbeods, rdh`as, vdearbs u atrds iuhlgahbs.
Lrogtas;
Zbdegz; Egl. FD. Kar`b Debkdhora Lruz Mbrhhobz.