7/24/2019 ADA4SEM2

http://slidepdf.com/reader/full/ada4sem2 1/7

PREPARATORIA ESTATAL No.8´´CARLOS CASTILLO PERAZA´´

INFORM ÁTICA II

BLOQUE 1

 ADA 4

 FUNCIONES DE LA HOJA DE CÁLCULO

1°G

INTEGRANTES:

 

GONZÁLEZ CHUC FÁTIMA MONSERRATH

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

GUTIRREZ CORTEZ JOS FRANCISCO

!!":##/0'23318536.+,o)$"o!.&-#

PREZ SOSA NAOMI JOSELLIN7

!!":##$o$'o&.+,o)$"o!.&-# 

SALAS CARRILLO LILIANA

!!":##,&$*00,,o.+,o)$"o!.&-#

9ILLANUE9A CONTRERAS AT7 ADIREM

!!":##$o%;0(&<,,'=(<.+,o)$"o!.&-#

 

MAESTRA:

 ISC: ROSARIO RA7GOZA

 

FECHA DE ENTREGA:

53 DE FEBRERO DE 531>

7/24/2019 ADA4SEM2

http://slidepdf.com/reader/full/ada4sem2 2/7

DE MANERA INDI9IDUAL? IN9ESTIGA EN FUENTES ELECTR@NICAS C@MO SE UTILIZAN LAS

FUNCIONES DE ECEL O LAS EQUI9ALENTES QUE CONTENGA LA HOJA DE CÁLCULO QUE

ESTN UTILIZANDO. CON LA INFORMACI@N RECABADA ELABORA UNA TABLA EN ORD

COMO LA SIGUIENTE

FUNCI@N QU HACE SINTAIS EJEMPLO

SUMA /='*' &!(&!*=( ;(<=(,<( (,0($=,!;o ;( , ;*';( ,o$ 0)=&('!o$ =("=(;(' $(0 <,o0($?;0(**o'($ ;( *(,;$o 0')o$ ;( *(,;$. $

(, *o'!(';o ;( ,*(,; ($ ,/'=&0*o$( )'o0.

 KSUMAARGUMENTO ARGUMENTO

SUMA1??4 K 8SUMAA1:A KS=& ;( ,o$ <,o0($(' (, 0')o A1:A

MCD D(<=(,<( (, &-&o*o&' ;<$o0 ;( ;o$o &$ '&(0o$('!(0o$. E, &-&o*o&' ;<$o0 ($ (,&%o0 '&(0o ('!(0o"o0 (, *=, '&(0o1 %'&(0o5 $o' ;<$+,($$' ;(0 0($!o.

M.C.D'&(0o1?'&(0o5? ...

KM.C.D54>K15

MCM D(<=(,<( (, &'&o*o&' &,!",o ;( ;o$o &$ '&(0o$.

M.C.M'&(0o1?'&(0o5?

M.C.M? 13 K 13M.C.M51? 58 K 84

PI L /='*' PI ;(<=(,<((, <,o0 ;(, '&(0o  pi  *o' ='*(;(*&,($? ($ ;(*0? (,<,o0?14165>866.

U!,0 ($! /='*' ($

, '* &'(0 ;(o+!('(0 (, <,o0 ;(  pi  

(' (, E-*(,.(

P0 ,,&0 , /0&=,PI =!,&o$ (, $)=('!(*o&';o:

KPI

E$! /='*' $( "=(;(=!,0 ;($;( , *(,;

;($!'o ($*0+(';o $=$'!-$ "0(*(;; ;( ='$)'o ;( )=,;; =PI()o ;($;( (, +o!' ;(/='*o'($ ;(, E-*(,. So"!&o$ "o0 "=,$0 (,+o!'? ;(+(&o$ +=$*0(' (, +=$*;o0 ;(/='*o'($ , /0&=, PI o;($",()0 , *!()o0;( ,$ /='*o'($&!(&!*$ %!0)o'o&!0*$. Lo$

*o&';o$ $o' ,o$

KPI D13

7/24/2019 ADA4SEM2

http://slidepdf.com/reader/full/ada4sem2 3/7

$)=('!($:

POTENCIA D(<=(,<( (, 0($=,!;o;( (,(<0 (, 0)=&('!o'&(0o ='"o!('*.

POTENCIA'&(0o?"o!('*L $'!-$ ;( , /='*'POTENCIA !('( ,o$$)=('!($ 0)=&('!o$:

V N&(0oO+,)!o0o. E$ (,'&(0o +$(.P=(;( $(0*=,=(0 '&(0o0(,.

V Po!('*O+,)!o0o. E$ (,(-"o'('!( , =(;($( (,(<0 (,'&(0o +$(.

P=(;( =$0 (, o"(0;o0WXW (' ,=)0 ;( , /='*'POTENCIA "0 ';*0 = "o!('* $( (,(<(, '&(0o +$(? "o0((&",o X5.

KPOTENCIA5  , *=;0;o K 5

KPOTENCIA68?>?568?> (,(<;o ,"o!('* ;( ?5 K54313?555

KPOTENCIA4#44 (,(<;o ,"o!('* ;( #4.K?>>84546

PRODUCTO L /='*'PRODUCTO &=,!",*!o;o$ ,o$ '&(0o$"0o"o0*o';o$ *o&o

0)=&('!o$ %;(<=(,<( (, "0o;=*!o.Po0 ((&",o? $ ,$*(,;$ A1 % A5*o'!('(' '&(0o$?"=(;( =$0 , /0&=,KPRODUCTOA1? A5"0 &=,!",*0 ,o$ ;o$'&(0o$. T&+'"=(;( 0(,0 ,&$& o"(0*' *o'(, o"(0;o0&!(&!*o ;(&=,!",**' Y "o0((&",o? KA1 Y A5.L /='*'PRODUCTO ($ !,*=';o '(*($!&=,!",*0 <0$*(,;$. Po0 ((&",o? ,/0&=,KPRODUCTOA1:A?C1:C ($ (=<,('!( KA1 Y A5 Y A Y C1 YC5 Y C.

PRODUCTO'&(0o1?'&(0o5? ...L $'!-$ ;( , /='*'PRODUCTO !('( ,o$

$)=('!($ 0)=&('!o$:V N&(0o

1 O+,)!o0o. E$(, "0&(0 '&(0oo '!(0<,o =(;($( &=,!",*0.

V N&(0o5? ... O"*o',.So' ,o$ '&(0o$o 0')o$;*o',($ =(;($( &=,!",*0?$! =' &-&o;( 50)=&('!o$.

NOTA S (, 0)=&('!o($ =' &!0 o ='0(/(0('*? $o,o $(&=,!",*0' ,o$'&(0o$ ;( , &!0 o0(/(0('*. S( (&!0',$ *(,;$ <*$? ,o$<,o0($ ,)*o$ o (, !(-!o;( , &!0 o 0(/(0('*.

KPRODUCTOA5:A4M=,!",* ,o$'&(0o$ ;( ,$

*(,;$ A5 A4.K553

KPRODUCTOA5:A45M=,!",* ,o$'&(0o$ ;( ,$*(,;$ A5 A4 %? *o'!'=*'?&=,!",* ($(0($=,!;o "o0 5.K433

KA5YAYA4M=,!",* ,o$'&(0o$ ;( ,$*(,;$ A5 A4&(;'!(o"(0;o0($&!(&!*o$ ('

,=)0 ;( , /='*'PRODUCTO. K553

7/24/2019 ADA4SEM2

http://slidepdf.com/reader/full/ada4sem2 4/7

RAZ D(<=(,<( , 0*=;0; ;( =''&(0o.

RAIZ'&(0oL $'!-$ ;( , /='*'RAZ !('( ,o$ $)=('!($0)=&('!o$:

V N&(0oO+,)!o0o. E$ (,'&(0o *=% 0*=;0; ;($(o+!('(0 

S '&(0o ($ '()!<o?RAIZ ;(<=(,<( (, <,o0;( (00o0 [\NUM].

KRAIZ1>R *=;0; ;(1> K4

KRAIZA5R *=;0; ;(^1>. D;o =( (,'&(0o ($ '()!<o?$( ;(<=(,<( (,&('$( ;( (00o0[\NUM]  K [NUM]

KRAZABSA5P=(;( (<!0 (,&('$( ;( (00o0[NUM] "0&(0o=$';o , /='*'

 ABS "0 *,*=,0 (,<,o0 +$o,=!o ;(^1>? % *o'!'=*'?*,*=,';o , 0.K 4

RADIANTES Co'<(0!( )0;o$ ('0;'($.

RADIANES')=,o KRADIANES5353 )0;o$ *o&o0;'($ 4?1586o "#5 0;'($ K4?1586

SI Use estafunción paradevolver unvalor si unacondición esverdadera yotro valor sies falsa.

SI(prueba_lógica;[valor_si_verdadero];[valor_si_falso])

=SI(!"#!$%&'&'$SI(*+#*$,-resupuestoecedido, ;,/orrecto,))

CONCATENAR No$ "(0&!( ='0 5 o&$ *;('$ ;( !(-!o(' =' &$& *(,;.

Texto1 obligatorio: E,"0&(0 !(-!o =( $( ='0 , *;(' ;( !(-!o/',.Texto2 opcional : E,$()=';o !(-!o ='0

Po0 ((&",o? !(')o'/o0&*' ;( ,o$'o&+0($ ;( ,o$(&",(;o$ (' *o,=&'$;/(0('!($:

DERECHA No$ ;(<=(,<( , ,!&,(!0 o *0*!(0 ;( ='*;(' ;( !(-!o.T&+' "o;(&o$';*0 , /='*'DERECHA =( 'o$

;(<=(,< =' '&(0o($"(*/*o ;(

Texto obligatorio: L*;(' ;( !(-!o =(*o'!('( ,o$ *0*!(0($=( ;($(&o$ (-!0(0.Núm_de_caracteres opcional : E, '&(0o ;(

*0*!(0($ =(;($(&o$ (-!0(0.

Po0 ((&",o (' ='!(-!o , '/o0&*'($ 00$!0; ,,!(0, ;(0(*o ;( ,o ;(, ,+0o.

7/24/2019 ADA4SEM2

http://slidepdf.com/reader/full/ada4sem2 5/7

*0*!(0($ ;(, /', ;(, *;(' ;( !(-!o.

IZQUIERDA /o0& "0!( ;( ,$/='*o'($ ;( !(-!o ;(, (00&('! % 'o$%=; o+!('(0 =''&(0o ;(!(0&';o;( *0*!(0($=+*;o$ , =(0;;( =' *;(' ;(!(-!o ;( *=(0;o ,*'!;; ;( *0*!(0($($"(*/*;o$.

Texto obligatorio: L*;(' ;( !(-!o ;( ,*=, $( o+!(';0' ,o$*0*!(0($ ;( ,=(0;.Núm_de_caracteres opcional : L *'!;;;( *0*!(0($ =( $(0'(-!0;o$ ;( , *;(';( !(-!o.S $( o&!( (, $()=';o0)=&('!o? , funciónIZQUIERA $=&0=( $o,&('!(;($(&o$ (, "0&(0*0*!(0 ;( , =(0;;( , *;(' ;( !(-!o.

U' ((&",o ;( !, ($=( , '/o0&*';(, !(-!o $( ($00$!0; ,=(0; ;( , o;(, ,+0,+0o

.ENCONTRAR 'o$ ;(<=(,<( ,"o$*' '*, ;( ='*;(' ;( !(-!o? o ;(=' *0*!(0? ;('!0o ;(o!0 *;(' ;( !(-!o.L /='*'ENCONTRAR *(;/(0('* ('!0(&%$*=,$ %

&'$*=,$.

Texto_!uscado obligatorio: E$ ,*;(' ;( !(-!o o*0*!(0 =( $( ;($(('*o'!00.entro_de"_texto obligatorio: L *;(';( !(-!o ;o';(0(,0(&o$ ,

+$=(;.V   Núm_inicia" opcional :I';* , "o$*' ;( ,*;(' D('!0o_;(,_!(-!o;o';( $( *o&('0 ,+$=(;. E, "0&(0*0*!(0 $(&"0( ($ (,'&(0o 1. S $( o&!(($!( 0)=&('!o $($="o'( =( $( 0(,0=' +$=(; ;($;( ,

"0&(0 "o$*'.

E(&",o:E$! /='*' !(%=;0 ('*o'!00 =' ;( ,$ <0;$/='*o'($ ;( (-*(,

 ESPACIOS R(&=(<( ,o$ ($"*o$;( =' !(-!o (-*("*' ;(, ($"*o$('*,,o ('!0( *;",+0. S !('(&o$=' +$( ;( ;!o$ ('E-*(, &=% )0';( %0(&o<(&o$ ,o$($"*o$ (-*(;('!($;( ,o$ !(-!o$"o;0(&o$ *o'!0+=0 &'&0 (, !&`o;(, 0*<o.

L /='*o' ($"*o$!('( =' $o,o "0&(!0o:aT(-!oo+,)!o0o:E,!(-!o , =( ;($(&o$=!0,( ,o$ ($"*o$.

($"*o$b !(-!o$&",( b

7/24/2019 ADA4SEM2

http://slidepdf.com/reader/full/ada4sem2 6/7

ETRAE 'o$ %=; (-!0(0*0*!(0($ =("(0!('(*(' ='*;(' ;( !(-!o. Lo'*o =( ;(+(&o$"0o"o0*o'0 ($ (,'&(0o ;( *0*!(0($=( ;($(&o$ (-!0(0% $= "='!o ;( '*o;('!0o ;( , *;(' ;(

!(-!o.

Texto obligatorio: L*;(' ;( !(-!o o0)',;( ;o';( ;($(&o$(-!0(0 ,o$ *0*!(0($.#osición Inicia" obligatorio: E, '&(0o;( , "o$*' =( o*="(, "0&(0 *0*!(0 =(;($(&o$ (-!0(0. E,"0&(0 *0*!(0 ;(, T(-!o!('( $(&"0( , "o$*''&(0o 1.

V   Núm_de_caracteres obligatorio: E, '&(0o;( *0*!(0($ =( $( <' (-!0(0 ;(, T(-!o "0!0 ;( , "o$*'

'*,.

=#&01'&

'(23&44$

,'endi5ient

o,$ 43*)evuelve elvalor deerror 67U86por9ue 5:sde unregistrocu5ple loscriterio

LARGO "(0!('(*( , )0="o ;(/='*o'($ ;( !(-!o %$o,&('!( !('( ='0)=&('!o =( ($ ='*;(' ;( !(-!o %*o&o 0($=,!;o 'o$;(<=(,<( (, '&(0o ;(*0*!(0($ ;( ;**;('.

T(-!o o+,)!o0o: L*;(' ;( !(-!o *=%,o')!=; ;($(&o$*o'o*(0 

='<(!)

ongitud dela pri5eracadena

 AHORA ;(<=(,<( , /(* %

o0 *!=,($ ;(,$$!(&. E$! /='*''o !('( 0)=&('!o$% =( *o'$=,! ,'/o0&*' ;(,*o&"=!;o0 (' (,&o&('!o (-*!o ('=( "=,$&o$ , !(*,E'!00.

D(+($ ($!0 *o'$('!(

;( =( (, 0($=,!;o ;( ,función A$%RA $(*!=,0 *; <( =(E-*(, <=(,< *,*=,0,$ /0&=,$ ;( , o.Po0 ((&",o? *=';o'!0o;=*$ *=,=(0o!0 /0&=, (' , o;( E-*(, $( <o,<(0 0(,0 (, *,*=,o ;( ,función A$%RA % "o0 ,o!'!(o (, 0($=,!;o $(*!=,0 *o' , '=(</(* % o0 ;(, $$!(&.O!0 &'(0 ;(*!=,0 (, 0($=,!;o ;(, función A$%RA ($"=,$';o , !(*, F6. S;($($ *o'$(0<0 (,<,o0 o0)', ;(<=(,!o"o0 , /='*' AHORA?;(+(0$ *o"0 $= <,o0% 'o , /0&=, ;(&'(0 =( % 'o $(*!=,;o.

P0 "o;(0 =!,0 ,

función A$%RA enExce" ($ $=/*('!(*o' '!0o;=*0 $='o&+0( % ,o$"0'!($$ ;( ,/='*':Ko0L'/o0&*' !(';0=' /o0&!o;;#&&# :&&% ,o "o;(&o$*o&"0o+0 *(';o*,* ;(0(*o $o+0( ,*(,; %$(,(**o'';o ,o"*' Fo0&!o ;(*(,;$.

7/24/2019 ADA4SEM2

http://slidepdf.com/reader/full/ada4sem2 7/7

 AcO ;(<=(,<( (, '&(0o ;(`o ;( =' /(* =($( ($"(*/*; *o&o0)=&('!o ;( ,/='*'. D( ($!&'(0? (, '*o0)=&('!o ;( ,/='*' ($ , /(* ;(, =( ;($(&o$

*o'o*(0 (, `o.

Núm_de_serie obligatorio: L /(* ;(, =( $(0 ;(<=(,!o (,`o.

Po;(&o$($"(*/*0 , /(**o&o =' *;(';( !(-!o (' (,0)=&('!o ;( ,función A&% %o+!(';0(&o$ ;(0()0($o (, '&(0o;( `o.D( )=, &'(0"o;(&o$ ($"(*/*0 =' /(* =( $(('*=('!0( (' ,)='o!0 *(,; % =(!(') =' ;!o ;(/(*.

DIA 'o$ ;(<=(,<( (,'&(0o ;( ; ;( ='/(* % =( ($!0(-"0($;o *o&o =''&(0o ('!(0o ('!0( 1% 1. L /='*' DIA!('( $o,&('!( ='0)=&('!o =( ($ (,'&(0o ;( $(0( ;( ,/(* ',0.

Núm_de_serie obligatorio: L /(* ;(E-*(, =( $(0 ',;"0 (-!0(0 (, '&(0o;( ;.

Kd;14#35#531>d

HO7 'o$ ;(<=(,<( (,

'&(0o ;( $(0( ;( ,/(* *!=,. U''&(0o ;( $(0( ($ (,'&(0o =( E-*(,=!, "0 ;('!/*0*=,=(0 /(* "0!0 ;(, 1 ;( ('(0o ;(1633.

a sintais de

la función >no tieneargu5entos.

Ko%