onceava semana

PRÁCTICA 1:
E7=SI(D7="A","PREMIUM",SI(D7="B","DORADA",SI(D7="C","PLATEADA")))

G7=F7*0.19

H7=SI(F7+G7>=130,"HABILITADO","INHABILITADO")

E20=BUSCARV(E19,A7:H16,2,0)

PRÁCTICA2:
B16=SUMA(B7:B15)
H7=SUMA(B7:G7)
F19=B16
F22=H7
F25=SUMA(D12:E12,D14:E14)
F28=SUMA(B10:B11,E10:E11,H12)
F32=PROMEDIO(B7:G7)
F35=PROMEDIO(E13:G13,E15:G15)
F40=PROMEDIO(C7:C15)
F45=SUMA(B8:D9)
F48=SUMA(E12:G12,B13:D13)
F53=SUMA(H7,H9,H11)

PRÁCTICA3:
D8=C8*$F$5
F8=D8*$E$8
C17=SUMA(C8:C15)
C20=F17*0.6
C22=SUMA(C19:C20)
F19=F17
F20=C22
F22=RESIDUO(F19,F20)

PRÁCTICA 4:
H11=CONTAR.SI($D$6:$D$15,G11)
I11=SUMAR.SI($D$6:$D$15,G11,$E$6:$E$15)
H14=SUMA(H11:H13)
I14=SUMA(I11:I13)
H18=CONTAR(E6:E15)
H19=CONTAR.BLANCO(E6:E15)
H20=SUMA(H18:H19)
K16=MAX(E6:E15)
K17=MIN(E6:E15)
K18=PROMEDIO(E6:E15)ç

PRÁCTICA 5:
E15=PROMEDIO(E5:E14)
E16=DESVIA2(E5:E14)
M17=CONTAR.SI(F5:F14,F6)
M18=CONTAR.SI(F5:F14,F5)
N5=SI(L5+M5>=40,"orientado","desorientado")

PRÁCTICA 6:
B13=BUSCARV(B12,E6:H10,2,0)
B14=BUSCARV(B12,E6:H10,3,0)
B16=BUSCARV(A16,A6:C10,2,0)
C16=BUSCARV(A16,A6:C10,3,0)
E16=BUSCARV(B13,F6:H10,3,0)*C16*D16
F16=C16*D16-E16
F21=SUMA(F16:F20)
F22=F21*19%
F23=F21+F22

PRÁCTICA 7:
D6=SI(C6="A1","CONTABILIDAD",SI(C6="A2","VENTAS",SI(C6="A3","FINANZAS",SI(C6="A4","MERCADOTECNIA"))))

F6=SI(E6="a","2600",SI(E6="b","2400",SI(E6="c","1500",SI(E6="d","1000"))))

H6=SI(E6="a","2.00%",SI(E6="b","2.50%",SI(E6="c","3.00%",SI(E6="d","3.50%"))))*F6

I6=SI(C6="A1","3.00%",SI(C6="A2","2.75%",SI(C6="A3","2.50%",SI(C6="A4","2.10%"))))*F6

J6=SI(G6<=3,"0.75%","1.20%")*F6 K6=F6*J26 L6=F6+H6+I6+J6-K6

PRACTICA 8:

F5=SI(E5="CONTADOR","A",SI(E5="AUXILIAR","B",SI(E5="OBRERO","C")))

G5=SI(F5="A","1500",SI(F5="B","1000",SI(F5="C","800"))) h5=SI(C5="CASADO","10%",SI(C5="SOLTERO","5%",SI(C5="VIUDO","12%")))*G5

I5=SI(D5<=2,"5%",SI(D5>=3,"10%"))*G5

J5=G5+H5+I5

G15=G5+G6+G7+G8+G9+G10+G11+G12+G13+G14

F18=CONTAR.SI(E5:E14,E5)

H18=B23*F18

I18=H5+I5+H7+I7+H11+I11

F24=CONTAR.SI(C5:C14,E24)

H24=G9+G12

I24=H9+I9+H12+I12

J24=SUMA(H24:I24)

H31=G5+G7

I31=H5+I5+H7+I7

J31=SUMA(H31:I31)

PRÁCTICA 9:
C15=BUSCARV(B15,B29:E48,2,0)
D15=BUSCARV(B15,B29:E48,4,0)*G10
E15=A15*D15
E20=SUMA(E15:E19)
E22=E20*0.19
E23=E20+E21+E22