INFORMATICA FORMULAS EN EXCEL
-
Upload
jhury-pua-castillo -
Category
Science
-
view
85 -
download
6
Transcript of INFORMATICA FORMULAS EN EXCEL
![Page 1: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/1.jpg)
UNIVERSIDAD TÉCNICA DE MACHALA
UNIDAD ACADEMICA DE CIENCIAS QUIMICAS
Y DE LA SALUDCARRERA DE ENFERMERIA
• DOCENTE:INGENIERA KARINA GARCIA• NOMBRE: JHURY PUA
![Page 2: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/2.jpg)
DISEÑO Y FORMULAS
![Page 3: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/3.jpg)
USANDO FUNCIONESSUMA() , PROMEDIO ()
![Page 4: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/4.jpg)
=SI(M8>=7;"APROBADO";"REPROBADO")=PROMEDIO(C7:L7)
![Page 5: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/5.jpg)
=E17+F17-G17
=SUMA(H17:H20)
FORMULAS Y EJERCISIOS
![Page 6: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/6.jpg)
FORMULAS Y EJERCISIOS
![Page 7: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/7.jpg)
FORMULAS Y EJERCISIOS
![Page 8: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/8.jpg)
=(D45+E45+F45)/3
=C50+C51+C52+C53*7
FORMULAS Y EJERCISIOS
![Page 9: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/9.jpg)
=E26-F26
=SUMA(G26:G31)
FORMULAS Y EJERCISIOS
![Page 10: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/10.jpg)
=B6+D6+F6 =C6+E6+G6 =H6+I6
FORMULAS Y EJERCISIOS
![Page 11: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/11.jpg)
=E14*F14 =G14*3,1% =G14*2,857% =G14*1,7663%
=PROMEDIO(L14:L21)
FORMULAS Y EJERCISIOS
![Page 12: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/12.jpg)
=PROMEDIO(E12:H12) =SI(I12>=6;"aprobado";"reprobado")
=SI(F12>6;"se lo gano"; "a la próxima")
FORMULAS Y EJERCISIOS
![Page 13: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/13.jpg)
=SI(B8="VOLVO";E8*5%;E8*3%) =SI(C8="VERDE";E8*1,5%;E8*1%) =SI(A8>=85;E8*2,5%;E8*2,8%)
=E8-F8-G8-H8
=SUMA(I8:I12)
=MAX(I8:I12)
=MIN(I8:I12)
=PROMEDIO(I8:I12)
FORMULAS Y EJERCISIOS
![Page 14: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/14.jpg)
FORMULAS Y EJERCISIOS
=SI(E8<4;"INSUFICIENTE";SI(E8<=6;"REGULAR";SI(E8<=7;"BUENO";SI(E8<=8;"MUY BUENO";"SOBRESALIENTE"))))
![Page 15: INFORMATICA FORMULAS EN EXCEL](https://reader035.fdocument.pub/reader035/viewer/2022062220/55b318f7bb61eb0a488b47ee/html5/thumbnails/15.jpg)
=BUSCARH(A25;$A$22:$K$23;2;FALSO)
FORMULAS Y EJERCISIOS