EXCEL (actividades)

 

ACT. 1

ACT.2

=C10*2

=C10/15

=E10/8

=C10*5%

=SI(G10=0,250,0)

=C10+F10*H10-E10*G10-I10

=SI(G10>=3,"Atencion")

=SUMA(K10:K14)

=PROMEDIO(K10:K14)

=MAX(K10:K14)

=MIN(K10:K14)

ACT.3

=C8+D8+E8

=F8*3%

=D8*2.5%

=F8*5.6%

=F8+G8+H8+I8

=J8+J8*K8

=J8+J8*M8

ACT.4

=PROMEDIO(C6:D6:E6)

=SI(F6>=6,"aprobo","reprobo")

=SI(F6>8,500,0)

=SI(F6=10,1000+H6,H6)

=PROMEDIO(F6,F7,F8,F9,F10)

=PROMEDIO(C6,C7,C8,C9,C10)

=SUMA(H6:H10)

=CONTAR.SI(H6:H10,"500")

=MAX(F6:F10)

=MIN(F6:F10)

=CONTAR.SI(F6:F10,">8")

=SI(F11>=8,"bueno","malo")

ACT.5

=buscarv(H5,G13:I28,2)

=buscarv(H5,G13:J28,3)

=buscarv(H5,G13:J28,4)

ACT.6

=SUMA(C7:E7)

=F7/$F$10

=SUMA(C7:C9)

=SUMA(C13:C15)

=SUMA(C10+C16)

ACT.7

=Hoja1!C10

=Hoja1!C16

=Hoja1!C18

=Hoja1!F10

ACT.8

=Hoja2!F7

=Hoja2!F9

=Suma(C8+C10)

ACT.9

=SUMA(B7:E7)

=B7*$B$5+C7*$C$5+D7*$D$5+E7*$E$5

=SI(F7>20000,500,0)

=G7+H7

=SUMA(B7:B16)

=PROMEDIO(B7:B16)

ACT.10

=C11*E11

=F11/$F$15

=SUMA(E11:E14)

=F15

=F23

=F32

=SUMA(A45:C45)

=PROMEDIO(A45:C45)

=SI(D45>500,"X","")

=MAX(A45:C45)

=MIN(A45:C45)

ACT. 11

=I7

=SI(E7=1,"deposito",SI(E7=2,"retiro",SI(E7=3,"devolucion","error")))

=SI(E7=1,D7+G7,SI(E7=2,D7-G7,SI(E7=3,D7-H7,"error")))

=SI(E7=3,G7*20%,"")

ACT.12

=SI([@Clave]="s19","pantalones",SI([@Clave]="m12","blusa",SI([@Clave]="f28","vestidos","error")))

=SI([@Clave]="s19",30,SI([@Clave]="m12",15,SI([@Clave]="f28",28,"error")))

=[@[Precio unitario]]*1.5

=[@[Precio de venta]]*10%

=[@[Precio de venta]]+[@IVA]

=[@[Precio Vta en USD]]*$J$4

=[@Cantidad]*[@[Precio Vta en USD]]

=[@Cantidad]*[@[Importe VTA M.N]]

=SUMA(Tabla1[Importe a pagar M.N])

=SUMA(Tabla1[Importe a pagar USD2])

=MAX(Tabla1[Importe a pagar M.N])

=CONTAR(Tabla1[Cantidad])

=SUMA(Tabla1[Cantidad])

=D4-F24