FUNCION "SI" Devuelve lve un valor lor Verda rdader dero o Falso lso depen pendien iendo del Crite riterrio o C =Si( =Si(V Valor alor_L _Lo oic ico! o!V Verda erdade dero ro!F !Fal also so. . Se pue puede den n "anid "anidar ar" " co#o co#o #a &'e#plo
Escriba una funcion que entreue la !alabra ")ola" si si e o la !alabra "*dios" si #a$ otro nu%ero distinto Trabaje en la celda D6 &'e#plo
NOMBRE.
EDAD.
Joanie Gloria Romualdo Olinda Oscar
3 52 37 60 25
SEXO
M F
Ejer 01
REGALO1
A UT O MUÑECA
Se desea desea calc calcular ular:: el tota totall de ventas por pro product duct &dem+ &d em+s s el nmer nmero o de venta ventas s en cada cada local local,, el tot tot
PRIMER PRI MER PASO ASO:: Dise Diseñar ñar mi tab tabla, la, ubi ubican cando do l Producto LLantas #aterias $adenas $arrocerias
%umero de &entas "otal &entas 'enta m(nima 'enta M)*ima Promedio de &entas
Ejer 02
"ienda Grau 400 500 250
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Cliente
&stado civil
Ana Car%en Car%enc#a Dionisia E'tre%a (uri &olsticia &usana )ana )anire
&oltera &e!arada &oltera Casada soltera &e!arada Casada soltera Casada *iuda
&olo las solteras asisten el resto no !uede asistir Ejer 0+ &i el *alor del %onto es %enor que , 2"0-000 restarle Monto
&u%ar , ++0.000 , +/0.000 , 10.000 , "0.000 , 1/0.000 , 210.000 , 2"0.000 , 20.000 , 10.000 , "0.000 , 1/0.000 , 1/0.000
Ejer 0 NOMBRE
essica 3aola Carlos 4icardo
MATEMATICAS
/0 "0 /0 0
El resultado de cada alu%no se e*alua de la siuiente f
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Nombre Camila Carmen Carola Ignacio Isabel Jessica Jorge Manuel Paola Pedro Veronica
Sueldo
Depto A B
"65.000-00 1".000-00 2"0.000-00 /".000-00 500.200-00 +"0.000-00 100.000-00 5/.000-00 2"5.000-00 "26.000-00 +6.000-00 !rati"icaci#n
2" 20
Ejer 06 N&+OCIO "DON )I,OLI-O" &S-*DO D& F*C-U*S D&L /&S D& /*0O D&L 12 N4 de C5e6ue
1"75 1"/752 1"57"5 16"7+1 26"576 +2167"1 +2167" +2"67"1 +62"71 "5/7"" 6"572 6"722 65"7/
7anco
&antiao 8#if &antiao &antiao 8#if &antiao &antiao &antiao &antiao 8#if 8#if 8#if 8#if
Usando la funcion &9 :aa que en la colu%na de E&TADO se escriba A!robado o 4ec#a;ado
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Ejer 0/ &U3E4ME4CADO &U3E4ME4CADO E> 8UE( COME4 ,roducto
&$istencia inicial
ab?n >ec#e 3an 3a!el : Aua ane 3erfu%ol Tra!o !iso ab? >iq fideos @alleta
"60 +20 150 260 "0 2+0 "00 2+0 20 125
Cantidad !ara re!oner Cant
1B Calcular el dinero recau 2B Calc alcular ular cunt untos os !rod !roduc uc +B &i quedan %enos de 20 Ejer 05 /odelo vendido
,recio 8ase
Mercedes +21 Ford 202 3eueot 10" Ford 202 Mercedes +21 3eueot 10" Mercedes +21
,recio 8ase
1"-000 1"-000-000 000 si si el %odelo %odelo e
For#a de ,ao
A!arecer A!la;ado si el
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
ondicion especificado. i#o % veces.
n la celda A" #a$ un 1
SEXO
REGALO1
1 1
, pr prom omed edio io de ve vent ntas as po porr pr prod oduc ucto to,, la co cond ndic ició ión n s sii la ve venta nta t al de de venta ventas s por por cada cada loc local, al, la m+m+-ima ima ! m.nim m.nima a venta venta por lo
s camos de los datos a calcular calcular!! "ienda "uac
"ienda 'ic+ 360 430
360 200 250 420
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Invitada al /atri#onio
".000 de lo contrario restarle , 10.000 &u%ar +20000 +60000 00000 0000 16"000 20"000 20000 250000 00000 0000 16"000 16"000
CASTE$$ANO
%ISTORIA
"" 60 5 20 r%a
+0 65 +2 "
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Depto
!rati"ic
A A 8 8 8 A A A 8 8 A
3 /onto C5e6ue
, , , , , , , , ,
.200-00 "5.600-00 ""5.00-00 2".5/-00 "+.+00-00 6.000-00 /+.20-00 2".000-00 5."00-00
Saldo en C-*. C-&.
, , , , , , , , ,
"0.000-00 "0.000-00 1.000.000-00 +0.000-00 /0.000-00 6".000-00 /+.000-00 +00.000-00 0.000-00
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Vendidos
,recio Unitario
+0 +10 1/5 2+0 "+6 22 0 2+0 2/5 0
15 1 2" +5 0 +5 25 0 2 60
ado tos quedan en ?ndola !ara la *enta !roductos debe a!arecer &9. de lo contrario debe a!arecer (O-
For#a de ,ao
Descuento
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
otal de cada producto es ma!or a "000, #ue muestre el mensa$e %&'astecer% en cas cal ! el promedio de ventas en cada local/
"otal
Promedio
$ondici-n
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Invitada al /atri#onio
Asiste (o Asiste Asiste (o Asiste Asiste (o Asiste (o Asiste Asiste (o Asiste (o Asiste
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
&stado
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Dinero recaudado
9uedan en :ndola
eponer
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.
Trusted by over 1 million members
Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial Cancel Anytime.