Point informatica
-
Upload
dianagodoszapata -
Category
Documents
-
view
38 -
download
0
Transcript of Point informatica
![Page 1: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/1.jpg)
UNIVERSIDAD TÉCNICA DE MACHALA
Calidad, Pertinencia y Calidez
ESCUELA DE ENFERMERIA
ESTUDIANTE: Godos Diana.
DOCENTE: Ing. Karina García Galarza.
TEMA: EJERCICIOS RESUELTOS EN EXCEL.
MACHALA-EL ORO- ECUADORPERÍODO 2014
FACULTAD DE CIENCIAS QUÍMICAS Y DE LA SALUD
INFORMATICA
![Page 2: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/2.jpg)
Promedio Anual =(C8+D8)/2
Promedio Anual =PROMEDIO(J8:K8)
Suma =C8+C9+C10+C11+C12+C13+C14+C15+C16+C17+C18+C19
Suma =SUMA(J8:J19)
Promedio =C20/12
Promedio =PROMEDIO(J8:J19)
![Page 3: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/3.jpg)
Total N° cajas =E17+F17-G17
Total =H17+H18+H19+H20
Dto. Min =C30*1%
Dto. Med =C30*10%
Dto. Max =C30*$F$35
Imp. Lujo =C30*$G$35
![Page 4: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/4.jpg)
Subtotal =E14*F14
IVA =G14*12%
Total =G14+H14
![Page 5: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/5.jpg)
Saldo =E26-F26
Total primer semestre =SUMA(G26:G31)
Comisión =G32*6%
![Page 6: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/6.jpg)
Promedio =(D45+E45+F45)/3
Gasto semanal =C50+C51+C52+C53*7
![Page 7: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/7.jpg)
Totales contado =B6+D6+F6
Totales tarjeta =C6+E6+G6
Totales total por día =H6+I6
Totales =SUMA(B6:B20)
![Page 8: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/8.jpg)
Sueldo =E14*F14
Isss =G14*3,1%
Fsv =G14*2,857%
Renta =G14*1,7663%
Sumatoria descuento =H14+I14+J14
Total liquido =G14-K14
Totales =SUMA(E14:E21)
Máximo =MAX(E14:E21)
Mínimo =MIN(E14:E21)
Promedio =PROMEDIO(E14:E21)
![Page 9: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/9.jpg)
Promedio =PROMEDIO(E12:H12)
Condición =SI(I12>=6;"aprobado";"reprobado")
Regalo =SI(F12>6;"se lo gano"; "a la próxima")
![Page 10: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/10.jpg)
Descuento 1 =E8*3%
Descuento 2 =E8*1%
Descuento 3 =E8*2,8%
Pago total =E8-F8-G8-H8
Totales =SUMA(E8:E12)
Máximo =MAX(E8:E12)
Mínimo =MIN(E8:E12)
Promedio =PROMEDIO(E8:E12)
![Page 11: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/11.jpg)
10% =B4*$C$3
Total =B4-C4
15% =B4*$E$3
Total =B4-E4
20% =B4*$G$3
Total =B4-G4
Suma final =D4+F4+H4
Sumas =SUMA(B4:B9)
Promedio =PROMEDIO(B4:B9)
![Page 12: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/12.jpg)
Costo total por semana =(B29+C29+E29+G29)*7
Costo total por bus =SUMA(I29;$B$33)
Costo total por avión =I29+$B$34
![Page 13: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/13.jpg)
Promedio =PROMEDIO(A2:D2)
Regalo =SI(D2>6;E2+2;E2)
Observación =SI(E2<4;"INSUFICIENTE";SI(E2<=6;"REGULAR";SI(E2<=7;"BUENO";SI(E2<=8;"MUY BUENO";"SOBRESALIENTE"))))
![Page 14: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/14.jpg)
Comisión =SI(A2<1000;A2*5%;SI(A2<=1999;A2*7%;SI(A2<=2999;A2*10%;SI(A2<=3999;A2*12%;A2*15%))))
![Page 15: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/15.jpg)
Buscar =BUSCAR(F2;A3:A6;B3:B6)
ConsultaV =CONSULTAV(D9;A10:B19;2;FALSO)
![Page 16: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/16.jpg)
ConsultaH =CONSULTAH(A25;$A$22:$K$23;2;FALSO)
![Page 17: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/17.jpg)
Contar =CONTAR(A2:A11)
Contara =CONTARA(B2:B11)
Contara.SI =CONTAR.SI(C2:C11;"mabe")
Moda.UNO =MODA.UNO(D2:D11)
Mediana =MEDIANA(D2:D11)
Max =MAX(D2:D11)
Min =MIN(D2:D11)
![Page 18: Point informatica](https://reader036.fdocuments.co/reader036/viewer/2022062514/55ba4bc8bb61eb93148b46fe/html5/thumbnails/18.jpg)