Talleres excel ii
•Download as DOCX, PDF•
0 likes•210 views
This document contains examples of formulas used in Excel across multiple workshops or talleres including formulas to calculate totals, averages, discounts, payments, salaries, and conditions. Formulas covered include SUM, AVERAGE, IF, MAX, MIN and more. The document is from a third semester nursing student at the Universidad Técnica de Machala in Ecuador and was created on January 22, 2015.
Talleres excel ii
- 1. UNIVERSIDAD TÉCNICA DE MACHALA UNIDADACADÉMICA DE CIENCIASQUÍMICAS Y DE LA SALUD ESCUELA DE ENFERMERÍA INFORMATICA II PRACTICA EN EXCEL Alumna: Madeleine Castillo Docente: Ing. Karina García
- 2. Semestre: 3° “B” Fecha: 22/01/2015 TALLER I FORMULAS CASILLERO FORMULA TOTAL DE N° DE CAJAS =(E3+F3)-G3 TOTAL =SUMA(H3:H6)
- 3. TALLER II FORMULAS CASILLERO FORMULA DESCUENTO MINIMO =C8*$D$13 DESCUNTO MEDIANO =C8*$E$13 DESCUENTO MAXIMO =C8*$F$13 DESCUENTO DE LUJO =C8*$G$13 TALLER III
- 4. FORMULAS CASILLERO FORMULA PROMEDIO =C5-D5 GASTO SEMANAL =D7*7 GASTO SEMANAL TOTAL =SUMA(E7:E11) TALLER IV
- 5. FORMULAS CASILLERO FORMULA SALDO =C5-D5 TOTAL DEL PRIMER SEMESTRE =SUMA(E5:E10) COMISION =E12*6% TALLER V
- 6. FORMULAS UTILIZADAS CASILLERO FORMULA SUBTOTAL =C4*D4 IVA =E4*12% TOTAL =(E4+F4) TALLER VI
- 7. FORMULAS CASILLERO FORMULA TOTALES =SUMA(C7:C21) TOTALES TARJETA =SUMA(C7;E7;G7) TOTALES CONTADO =SUMA(D7;F7;H7) TOTAL POR DIA =SUMA(I7:J7)
- 8. TALLER VII FORMULAS CASILLERO FORMULA SUELDO =E8*F8 ISSS =G8*3,1% FSV =G8*2,857% RENTA =G8*1,7663% SUMATORIA DESCUENTO =H8+I8+J8 LIQUIDO TOTAL =G8-K8 TOTALES =SUMA(E8:E15) MAXIMO =MAX(E8:E15) MINIMO =MIN(E8:E15) PROMEDIO =PROMEDIO(E8:E15)
- 9. TALLER VII FORMULAS CASILLERO FORMULA PROMEDIO =PROMEDIO(F14:I14) CONDICION =SI(J14>6;"APROBADO";"REPROBADO") REGALO =SI(G14>6;"SE LO GANO";"A LA PROXIMA")
- 10. TALLER IX FORMULAS CASILLERO FORMULA DESCUENTO 1 =SI(B9="VOLVO";E9*5%;E9*3%) DESCUENTO 2 =SI(C9="VERDE";E9*1,5%;E9*1%) DESCUENTO 3 =SI(A9>="85";E9*2,5%;E9*2,8%) PAGO TOTAL =E9-F9-G9-H9 TOTALES =SUMA(E9:E13) MAXIMO =MAX(E9:E13) MINIMO =MIN(E9:E13) PROMEDIO =PROMEDIO(E9:E13)