Formulasyejercicios 140910211750-phpapp02
-
Upload
bellabell-bsc -
Category
Education
-
view
75 -
download
0
Transcript of Formulasyejercicios 140910211750-phpapp02
![Page 1: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/1.jpg)
UNIVERSIDAD TECNICA DE MACHALAFACULTAD DE CIENCIAS QUIMICAS Y DE LA SALUD
ESCUELA DE ENFERMERIA
INFORMATICA II
FORMULAS Y EJERCICIOS
NOMBRE :JOHANNA TELLO
DOCENTE:ING. KARINA GARCIA
CURSO:
TERCER SEMESTRE DE ENFERMERIA “A”
![Page 2: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/2.jpg)
EJERCICIO 1
SUMA =B8+B9+B10+B11+B12+B13+B14+B15+B16+B17PROMEDIO
=B18/10PROMEDIO ANUAL
=(B8+C8)/2
=SUMA(H8:H17)=PROMEDIO(H18/10)
PROMEDIO ANUAL=PROMEDIO(H8:I8)
![Page 3: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/3.jpg)
EJERCICIO 2
FORMULAS=PROMEDIO(C7;L)
OBSERVACIONES=SI(M7>=7;"APROBAD
O";"REPROBADO")
![Page 4: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/4.jpg)
EJERCICIO 3
FORMULASTOTAL No CAJAS
=E6+F6-G6
TOTAL=SUMA(H6:H9)
![Page 5: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/5.jpg)
EJERCICIO 4
FORMULAS
DTO MINIMO=C6*1%DTO MEDIO=C6*10%DTO MAXIMO=C6*11%IMP. LUJO=C6*18%
![Page 6: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/6.jpg)
EJERCICIO 5
FORMULASSUBTOTAL
=D5*E5IVA
=F5*12%TOTAL
=SUMA(F5;G5)
![Page 7: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/7.jpg)
EJERCICIO 6
FORMULASSALDO
=C6-D6TOTAL
=SUMA(E6:E11)COMISION
=E12*6%
![Page 8: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/8.jpg)
EJERCICIO 7
PROMEDIO=PROMEDIO(B5:D5)
GASTO SEMANAL=SUMA(C10:C13)*7
FORMULAS
![Page 9: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/9.jpg)
EJERCICIO 8
FORMULASCONTADO
=SUMA(C10;E10;G10)TARJETA
=SUMA(D10;F10;H10)TOTAL POR DIA
=SUMA(I10:J10)TOTALES
=SUMA(C10:C24)
![Page 10: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/10.jpg)
EJERCICIO 9
SUELDO=F9*G9
ISSS=H9*3,1%
FSV=H9*2,857%
RENTA=H9*1,7663%
FORMULAS
TOTALES=SUMA(F9:F16)
MAXIMO=MAX(F9:F16)
MINIMO=MIN(F9:F16)
PROMEDIO=PROMEDIO(F9:F16)
![Page 11: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/11.jpg)
EJERCICIO 10
FORMULAS
PROMEDIO=PROMEDIO(F14:I14)
CONDICION=SI(J14>=6;"APROBADO";"REPRO
BADO")REGALO
=SI(G14>6;"SE LO GANO";"A LA PROXIMA")
![Page 12: Formulasyejercicios 140910211750-phpapp02](https://reader031.fdocuments.co/reader031/viewer/2022032502/55b9832dbb61ebbb798b46e9/html5/thumbnails/12.jpg)