Decimo primera semana

Practica 1:
=(F7*19%)
=BUSCARV(E19, A7:H16, 2, 0)
=SI(F7+G7>=130, "habilitado", "inhabilitado")
Practica 2:

=SUMA(H7:H15)
=PROMEDIO(B7:G7)
=SUMA(B7+C7+D7+E7+F7+G7+B9+C9+D9+E9+F9+G9+B11+C11+D11+E11+F11+G11)
Practica 3:
=C8*$F$5
=SUMA(F8:F15)
=(F17*60%)
Practica 4:
=CONTAR.SI($D$6:$D$15, G11)
=SUMAR.SI($D$6:$D$15, G11, $E$6:$E$15)
=CONTAR.BLANCO(E6:E15)
=MAX(E6:E15)
=MIN(E6:E15)
Practica 5:
=PROMEDIO(E5:E14)
=CONTAR(E5:E14)
=CONTAR.SI($N$5:$N$14, N6)
Practica 6:
=BUSCARV(A16, A6:C10, 3, 0)
=BUSCARV(A16, A6:C10, 2, 0)
=(C16*10%)
=(F21*19%)
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%))))
=(F6*2%)
Practica 8:
=E20*19%
=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%)))
=CONTAR.SI($E$5:$E$14, E5)
=CONTAR.SI(C5:C14, C9)
Practica 9:
=E29*G10
=SUMA(E15:E19)
=SI(E5="contador", "A", SI(E5="auxiliar", "B", SI(E5="obrero", "C", " ")))