PRACTICA 1 =SI(D7="A";"PREMIUM";SI(D7="B";"DORADA";SI(D7="C";"PLATEADA"))) =SI(D8="A";"PREMIUM";SI(D8="B";"DORADA";SI(D8="C";"PLATEADA"))) =SI(D11="A";"PREMIUM";SI(D11="B";"DORADA";SI(D11="C";"PLATEADA"))) =F7*0,19 =SI(F8+G8>=130;"HABILITADO";"INHABILITADO") =SI(F16+G16>=130;"HABILITADO";"INHABILITADO") =BUSCARV(E19;A7:H16;2;0) =BUSCARV(E19;A7:H16;3;0) PRACTICA 2 =SUMA(B7:G7) =SUMA(D12:E12;D14:E14) =SUMA(B10:B11;E10:E11;H12) =PROMEDIO(B7:G7) =PROMEDIO(C7:C15) PRACTICA 3 =C8*$F$5 =D8*$E$8 =SUMA(C8:C15) =F17*0,6 =SUMA(C19:C20) =RESIDUO(F19;F20) PRACTICA 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) PRACTICA 5 E15=PROMEDIO(E5:E14) E16=DESVIA2(E5:E15) M17=CONTAR.SI(F5:F14,F6) M18=CONTAR.SI(F5:F14,F5) N5=SI(L5+M5>=40,"orientado","desorientado") PRACTICA 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 PRACTICA 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) PRACTICA 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 PRACTICA 10