ejercicios de excel
TRANSCRIPT
![Page 1: Ejercicios de excel](https://reader031.vdocumento.com/reader031/viewer/2022020307/55af29691a28ab6c198b4634/html5/thumbnails/1.jpg)
EJERCICIOS DE EXEL
SUMA=SUMA(K8:K19)
PROMEDIO=D20/12
=PROMEDIO(D9:M9)
=SI(N9<=7;"REPROBADO";"APROBADO")
![Page 2: Ejercicios de excel](https://reader031.vdocumento.com/reader031/viewer/2022020307/55af29691a28ab6c198b4634/html5/thumbnails/2.jpg)
=SUMA(E7:F7)-(G7)
=SUMA(H7:H10)
DTO. MIN=C6*1% DTO. MED=C6*10% DTO. MAX=C6*$F$11 IMP. LUJO=C6*$G$11
![Page 3: Ejercicios de excel](https://reader031.vdocumento.com/reader031/viewer/2022020307/55af29691a28ab6c198b4634/html5/thumbnails/3.jpg)
Subtotal=(D6*E6) IVA=(F6*12%) TOTAL=(F6+G6)
TOTAL DEL PRIMER SEMESTRE=SUMA(F6:F11) Comisión: =(F12*6%)
![Page 4: Ejercicios de excel](https://reader031.vdocumento.com/reader031/viewer/2022020307/55af29691a28ab6c198b4634/html5/thumbnails/4.jpg)
=SUMA(C7;E7;G7)
TOTALES=SUMA(C7:C21)
![Page 5: Ejercicios de excel](https://reader031.vdocumento.com/reader031/viewer/2022020307/55af29691a28ab6c198b4634/html5/thumbnails/5.jpg)
SUELDO=F10*G10 ISSS=H10*3,1% FSV=H10*2,857% RENTA=H10*1,7663% SUMATORIA DESCUENTO=I10+J10+K10 TOTAL LIQUIDO=H10-L10 TOTALES=SUMA(F10:F17) MAXIMO=MAX(F10:F17) MINIMO=MIN(F10:F17) PROMEDIO=PROMEDIO(F10:F17)
![Page 6: Ejercicios de excel](https://reader031.vdocumento.com/reader031/viewer/2022020307/55af29691a28ab6c198b4634/html5/thumbnails/6.jpg)