11ava. SEMANA

TRABAJO DE EXEL

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ÁCTICA 2:B16=SUMA(B7:B15)

H7=SUMA(B7:G7)

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ÁCTICA 3:=C8*$F$5=D8*E8

=SUMA(F8:F15)=(F17*60%)

PRÀCTICA 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)

PRÁCTICA 5:=SI(L5+M5>=40, "orientado", "desorientado")

=PROMEDIO(E5:E14)

=DESVIA2(E5:E14)=CONTAR(E5:E14)

=CONTAR.SI($N$5:$N$14, N6)

PRÁCTICA 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)

PRÁCTICA 7:=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%)

=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))))

PRÁCTICA 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)

PRÁCTICA9:=E29*$G$10

=PRODUCTO(D15,A15)

=E20*19%

=SUMA(E20:E22)

PRÁCTICA 10: =SUMA(F6:G6)/2

=PROMEDIO(B3:E3)

__________________________________________________________