T3_Herramientas informáticas.xlsx

TAREA 3-ANEXO 1.

DATOS DA TOS INFORMATIVOS: Nombre del curso: Herramie!a" I#$rm%&'a" Tipo de pr!cipci"#: I(i)i(*a+  Doce#$e e%per$o: are -er.a  Doce#$e re&isor: S/ir+ey Q*i".e Fec': 01203245

(.

INSTR)**IONES INSTR)**I ONES +ARA DESARRO,, DESARRO,,AR AR ,A TAREA: ,e ls i#diccio#es ue se d# e# cd u# de ls 'os me#cio#ds  co#!#uci"#: FORMATO CONDICIONAL FUNCIONES FUNCION ES MATEMÁTICAS, MATEMÁTICAS, EST ESTADÍSTICA ADÍSTICASS y TEXTO FUNCIONES DE BÚSQUEDA FUNCIONES LÓGICAS

FORMATO FORMATO CONDICIONAL CONDI CIONAL C$mi"i (e )e!a A.+i'ar '$+$r a*+ +a +e!ra (e +a" '$mi"i$e" *e "*.ere +$"  700 y (e r$?$ +a" *e $ 6ENDEDOR CARMEN 9AIRO 9OS; MIGUEL
COMISIÓN 778 37: 1:0 338 371 188 =>= 370

A.+i''a F$ A.+i F$rm rma! a!$ $ C$ C$( (i' i'i$ i$a a+, +, "e "$+i'i!a($ 1 +)NTOS

A.+i'a A.+i 'a e+ '$ '$? ?* *!$ !$ (e i' i'$ $$ $, "e "e "i*ie!e" 'ri!eri$"

C$?*!$ (e i'$$ TEM@ TRIMESTRE

6ENTAS S2 :7000 S2 48000 S2 >0000 S2 77000

6a+$re" a+$re" *e "*.ere "*.ere i*a+ a a S2 700 6a+$re" "*.eri$re" .er$ i#eri$r a S2 7 6a+$re" e!re a S2 300 6a+$re" i#eri$re" a ( +)NTOS

 +$

 +$"

 $ "ea S2 300 00 00 y S2 S2 :00

F)N*IONES DE TEXTO DNI A
10857==7 am$a me(ia )ae""a a+e?a(ra CA9AMARCA

JIre"ar +$" a.e++i($" e mi"'*+aK JIre"ar +$" $mre" !$($ e mi"'*+aK JINGRESAR EL DISTRITO DE RESIDENCIA EN

C$"i(era($ C$"i(era($ +$" (a!$" (e arria A.+i'a *a #*'i *e m*e"!re +$" A
A. TE :<

Ire"ar (a!$" (e+ e"!*(ia!e  

AÚSCULAK

i'a #*'i$e" (e TO   UNTOS

F)N*IONES ESTAD
SUCURSALES

6ENDEDORJAK


CANTIDAD

6ENTAS

,ocl 1 ,ocl 4 ,ocl 3 ,ocl 3 ,ocl 4 ,ocl 1 ,ocl 4 ,ocl ( ,ocl 4 ,ocl 4 ,ocl 1 ,ocl 4 ,ocl 1 ,ocl 1

*rlos Mr6 8or9e +ol Ro%# *rlos Ro%# *rme# Ro9er Mr6 8u# Ro%# 8u# *rlos

Micr"o#o Tecldo +rl#$es Tecldo Mouse Mouse Micr"o#o Mouse Micr"o#o Tecldo Mouse Mouse +rl#$es +rl#$es

45 4 (5 41 3( 11 34 ( 30 47 40 (; (3 10

450 75 3(4 71 00 (5 340 500 300 7;0 1000 5( (57 1(0

A
DÍSTICAS, USANDO EL CUADRO DE LA I-QUIERDA
+!aP /1 +TO2 >1 !a" (e+ +$'a+ 3P /1 3P /1 +TO2 >=57 *a 'a&(a( )e(i(a me$re" a :0 *i(a(e"P /1 +TO2 : !a (e .ar+a!e" (e+ +$'a+ 4P /1 +TO2 458 !a rea+ia($ .$r +a )e(e($ra R$aaP /1 +TO2 48=7

A
F)N*IONES DE *OD N004 N00: N003 N00> N007 N00= N001 N008 N005 N040


Nombre -ULL HADEE MEL6A 6ANNESA CONSUELO MARIA ALICIA ROBERTO MILAGROS OSCAR

*)RSO HEINF HEINF QUIMICA QUIMICA COMMA QUIMICA COMMA HEINF FISICA QUIMICA

+ROMEDIO 41 43 4> 4: 43 40 5 45 4> :0

4= CUARTO DE BECA

45 MEDIA BECA

:0 BECA

ESTADO A
 

>S?)EDA BÚSQUEDA DE PRODUCTOS POR CÓDIGO

INGRESA UN CÓDIGO N010

Nombre: (1

PTO)

INGRESA UN CÓDIGO QUE SE ENCUENTRE EN LA COLUMNA COD DEL CUADRO DE LA I-QUIERDA

OSCAR

Curso:

(1 PTO) QUIMICA

Promedio: (1

PTO) 20

Estado:

(1 PTO)  APROBADO

 Tipo de beca: (1 PTO) BECA

A
FUNCIÓN SI JANIDADAK Ua i"&!*'i a'a(Vmi'a, (e"ea a.+i'ar (e"'*e!$ a +$" e"!*(ia!e *e /ai!e e *a (e!ermia(a $a (e Tr*?i++$, "e +$" "i*ie!e" 'ri!eri$"



Si e+ e"!*(ia!e )i)e e La" Q*i!aa" y e"!*(ia E'e+, "e +e a.+i'ar% * (e"'*e!$ (e+ :7W (e+ '$"!$ (e +a ma!r'*+a



Si ra(i'a La Mer'e( y e"!*(ia
De!ermie e+ (e"'*e!$ y e+ e!$ a .aar Di"!ri!$ La N$ria Sa!a Ie" E+ B$"*e La" Q*i!aa" La Mer'e( La N$ria La" Q*i!aa" E+ B$"*e E+ Re're$ La N$ria

E(a( :0 47 4= :0 :5 :7 4> 4: 43 :0

C*r"$
C$"!$ (e Ma!ri'*+a S2 S2 S2 S2 S2 S2 S2 S2 S2 S2 S2 S2

:0000 :0000 :7000 4:000 48000 :0000 :0000 4:000 :7000 4:000 4:000 :7000

De"'*e!$ S2 S2 S2 S2 S2 S2 S2 S2 S2 S2

    =000 =000  =: = : 7 0   

Ne!$ a .aar S2 S2 S2 S2 S2 S2 S2 S2 S2 S2

:000 :0000 0 :7000 4:000 48000 4>00 4>000 0 4:000 48170 4:000 4:000 :7000

A.+i'a #*'i$e" +i'a" SI, , ai(a(a", .ara re".$(er y '$m.+e!ar +$" e".a'i$" e +a'$  +)NTOS

RÚ

Tem

E%cele#$e 100

F$rma!$ '$(i'i$a+ y F*'i$e" (e Te!$ J:7WK

0 JA.+i'a e+ #$rma!$ '$(i'i$a+ .e(i($ e +a /$?a F$rma!$ '$(i'i$a+ y 'rea e+ '(i$ .e(i($ e +a /$?a !e!$K

$ JA.+i'a e+ #$rma!$ A.+i'a e+ #$rma!$ '$(i'i$a+ (e '$(i'i$a+ (e '$+$r (e +e!ra, e+ (e '$$ a '$+$r (e !e!$ y e+ (e Í'$$, a(em%" !$(a" +a" #*'i$e" (e me(ia" e +a /$?a (e #$rma!$ '$(i'i$a+ !e!$ e".e'i'a(a" e".e'i'a(a" e +a" /$?a" y e+ e?er'i'i$ '$m.+e!$ e +a /$?a (e !e!$K $ JA.+i'a "$+$ e+ #$rma!$ (e '$$ e +a F$rma!$ C$(i'i$a+ y Te!$ /$?a F$rma!$ '$(i'i$a+ y e+ e?er'i'i$ '$m.+e!$ (e #*'i !e!$ e +a /$?a !e!$K 

A.+i'a +a" #*'i$e" e"!a("&'a", F*'i$e" Ma!em%&'a" ma!em%&'a" y 3 (e !e!$, !a+ '$m$ y E"!a("&'a" "e i(i'a e 'a(a .re*!a :7W

Mu@ bue#o



4 A.+i'a > #*'i$e" e"!a("&'a", 4 (e ma!em%&'a y : (e !e!$, !a+ '$m$ "e i(i'a e 'a(a .re*!a 4

A.+i'a +a" > #*'i$e" (e "*e(a A.+i'a +a #*'i "i ai(a(a, re".e!a($ !a+ '$m$ "e i(i'a e 'a(a +a" '$(i'i$e" (a(a" y (a re".*e"!a re".*e"!a F*'i$e" (e B"*e(a .re*!a y *&+ia #rm*+a .ara '$rre'!a a 4 $ :YB=E40 m$!$" /a++ar e+ e!$ a .aar .r$.*e"!$" e (e"'*e!$ y e!$ a .aar :7W

SI ANIDADA

:7W



4

A.+i'a +a #*'i "i ai(a(a, re".e!a($ re".e!a($ +a" '$(i'i$e" (a(a" y A.+i'a +a #*'i "i ai(a(a, re".e!a($ +a" '$(i'i$e" (a(a" y (a re".*e"!a re".*e"!a (a re".*e"!a '$rre'!a '$rre'!a a 5 $ 40 '$rre'!a a 1 $ 8 m$!$" .r$.*e"!$" e m$!$" .r$.*e"!$" e (e"'*e!$ y (e"'*e!$ y e!$ a .aar e!$ a .aar 

4

BRICA PARA EVALUAR LA TAREA 3

=ue#o

Re9ulr

70

40

JA.+i'a !$($" +$" #$rma!$" e +a /$?a (e #$rma!$ '$(i'i$a+, .er$ $ rea+ia +$" e?er'i'i$" (e +a /$?a !e!$K $ JA.+i'a e+ e?er'i'i$ (e '$$ e +a /$?a (e #$rma!$ '$(i'i$a+ y e+ e?er'i'i$ (e $mre"2a.e++i($" $mre"2a.e++i($" $ e+ (e '(i$ e +a /$?a !e!$K

3

JA.+i'a e+ e?er'i'i$ (e '$$ e +a /$?a (e #$rma!$ '$(i'i$a+K $ JA.+i'a +a" #*'i$e" (e !e!$ e !$($" +$" e?er'i'i$" (e +a /$?a !e!$K $ JA.+i'a e+ #$rma!$ (e '$+$r (e !e!$ e +a /$?a (e #$rma!$ '$(i'i$a+ y e+ e?er'i'i$ (e $mre"2a.e++i($" $ e+ (e '(i$ e +a /$?a !e!$K

(

A.+i'a > #*'i$e" e"!a("&'a" y 4 (e !e!$, 4 A.+i'a 3 #*'i$e" (e e"!a("&'a" y 4 ma!em%&'a, !a+ '$m$ "e i(i'a e 'a(a (e ma!em%&'a !a+ '$m$ "e i(i'a e .re*!a 'a(a .re*!a 3

(

A.+i'a : #*'i$e" (e "*e(a !a+ '$m$ "e i(i'a e 'a(a .re*!a y *&+ia #rm*+a .ara /a++ar e+ e!$ a .aar

A.+i'a 4 #*'i (e "*e(a !a+ '$m$ "e i(i'a e 'a(a .re*!a y *&+ia #rm*+a .ara /a++ar e+ e!$ a .aar

3

(

A.+i'a +a #*'i "i ai(a(a, A.+i'a +a #*'i "i ai(a(a, re".e!a($ +a" re".e!a($ +a" '$(i'i$e" (a(a" y '$(i'i$e" (a(a" y (a re".*e"!a '$rre'!a a (a re".*e"!a '$rre'!a '$rre'!a a 3 $ > m$!$" 7 $ = m$!$" .r$.*e"!$" e (e"'*e!$ y .r$.*e"!$" e (e"'*e!$ y e!$ a e!$ a .aar .aar .aar 3

(

I#suBcie#$e

Mlo

(0

0

A.+i'a e+ #$rma!$ (e '$+$r (e N$ a.+i'a F$rma!$ !e!$, $ e+ (e '$$ a me(ia", $ C$(i'i$a+ i #*'i$e" (e e+ (e $mrea.e++i($ $ e+ (e !e!$ e +a" /$?a" '(i$ e +a" /$?a" #$rma!$ re".e'&)a" '$(i'i$a+ y !e!$

1

0

A.+i'a : #*'i$e" (e e"!a("&'a" $ !e!$ !a+ '$m$ "e i(i'a e 'a(a .re*!a

N$ a.+i'a i*a #*'i (e e"!a("&'a" y (e !e!$

1

0

A.+i'a 4 #*'i (e "*e(a !a+ N$ a.+i'a i*a #*'i '$m$ "e i(i'a e 'a(a i /a++a e+ e!$ .re*!a $ $ *&+ia #rm*+a (e "*e(a, a .aar .ara /a++ar e+ e!$ a .aar 1

0

A.+i'a +a #*'i "i ai(a(a, re".e!a($ +a" '$(i'i$e" (a(a" y (a re".*e"!a '$rre'!a a 4 $ : m$!$" .r$.*e"!$" e (e"'*e!$ y e!$ a .aar

N$ a.+i'a +a #*'i "$+i'i!a(a, i *&+ia +a" '$(i'i$e" (a(a" y $ (a re".*e"!a a +a .re*!a

1

0