EJECICIOS DE EXCEL

=C4*$D$3 =SUMA(C4:C9) =PROMEDIO(C4:C9)

=SUMA(C29:I29)*7 =J29+$C$33 =J29+$C$34

Amarillo =BUSCAR(G3;B4:B7;C4:C7) Para =BUSCAR(G3;B4:B7;D4:D7) 7 =CONSULTAV(E10;B11:C20;2;FALSO)

Manzanas =CONSULTAH(B27;C24:L25;2;FALSO)