Semana Número Once

Practica 1:
=SI(D7="A", "premium", SI(D7="B", "dorada", SI(D7="c", "plateada", " ")))
=(F7*19%)
=SI(F7+G7>=130, "habilitado", "inhabilitado")
=BUSCARV(E19, A7:H16, 2, 0)
Practica 2:
=SUMA(B7:G7)
=SUMA(H7:H15)
=PROMEDIO(B7:G7)
=PROMEDIO(E13:G13, E15:G15)
=SUMA(B7+C7+D7+E7+F7+G7+B9+C9+D9+E9+F9+G9+B11+C11+D11+E11+F11+G11)
Practica 3:
=C8*$F$5
=D8*E8
=SUMA(F8:F15)
=(F17*60%)
=RESIDUO(F19, F20)
Practica 4:
=CONTAR.SI($D$6:$D$15, G11)
=SUMAR.SI($D$6:$D$15, G11, $E$6:$E$15)
=CONTAR(E6:E15)
=CONTAR.BLANCO(E6:E15)
=MAX(E6:E15)
=MIN(E6:E15)
=PROMEDIO(E6:E15)
Practica 5:
=SI(L5+M5>=40, "orientado", "desorientado")
=PROMEDIO(E5:E14)
=DESVIA2(E5:E14)
=CONTAR(E5:E14)
=CONTAR.SI($N$5:$N$14, N6)
Practica 6:
=BUSCARV(B12, E6:H10, 2, 0)
=BUSCARV(A16, A6:C10, 2, 0)
=BUSCARV(A16, A6:C10, 3, 0)
=(C16*10%)
=(F21*19%)
=SUMA(F21:F22)
Practica 7:
=SI(C6="A1", "contabilidad", SI(C6="A2", "ventas", SI(C6="A3", "finanzas", SI(C6="A4", "mercadotcnia", " "))))
=SI(E6="A", 2600, SI(E6="B", 2400, SI(E6="C", 1500, SI(E6="D", 1000))))
=SI(E6="A", F6*2%, SI(E6="B", F6*2.5%, SI(E6="C", F6*3%, SI(E6="D", F6*3.5%))))
=SI(G6<=3, F6*0.75%, SI(G6>=4, F6*1.2%))
=(F6*2%)
Practica 8:
=SI(E5="contador", "A", SI(E5="auxiliar", "B", SI(E5="obrero", "C", " ")))
=SI(F5="A", 1500, SI(F5="B", 1000, SI(F5="C", 800)))
=SI(C5="casado", G5*10%, SI(C5="soltero", G5*5%, SI(C5="viudo", G5*12%)))
=SI(D5<=2, G5*5%, SI(D5>=3, G5*10%))
=SUMA(G5+H5+I5)
=CONTAR.SI($E$5:$E$14, E5)
=CONTAR.SI(C5:C14, C9)
=SUMA(H36:I36)
Practica 9:
=E29*G10
=D15*30
=SUMA(E15:E19)
=E20*19%
=SUMA(E20+E22)