Creacion de Graficos en Excel 2016 - Taller 3

CEDULA N O MB R E 12344444 EV EVER 12234566 FFA AB I A N 5675 567543 4322GIL 22GILM MA 65543211 ISABEL 23456789 J S ST! 34566786 L!RENA 33456333 LIS 23134567 567 MARGARET 45674234 !SCAR 34567433 RAL

APELLIDO MEZA EVILLA PATERN ERNINA INA SANCHEZ JIMENEZ M!NTES FELLIZZ!LA SANT!S R!MER!

TELEFONO DIRECCION 3012214324 CL CLL25C#13-08 3045667325 CLL34E#12-63 2765 276546 467 7 CLL5 CLL56A 6A# #32-1 32-12 2 2822769 CLL12C#23-12 3012437805 CLL13C#56-23 3217643698 CLL12C#24-12 3137657778 CLL12B#12-34 30045687 68796 CLL24C#2 C#23-1 3-12 3176549806 CLL25B#12-09

E-MAIL (("$%.(,*"**&/*. '+$-($""+,*.+$"&/*. $".++(&12,*.+$"&/*. $%+%+/(),.+$"&/*.  %*$.((),*.+$"&/*.  %*$.(() ,*.+$"&/*. "*.*(%,*"**&/*. "$%&'(""$))*"+,.+$"&/*. .++(%'&15,.+$"&/*. *%/+*.(,*.+$"&/*.

MARTINEZ

3158707654 CLL25A#23-12

+".+.1,*"**&/*.

CODIGO

NOMBRE DEL PRODUCTO VALOR UNITARIO 101 ARE:IPE !RIGINAL 500 $ 8,000.00 102 AVENA LPG 250 $ 2,400.00 103 CREMA ;E LECHE 500 ." $ 4,500.00 104 LECHE ;ESLACT!SA;A 1L $ 2,500.00 105 LECHE ENTERA 1L $ 2,500.00 106 :ES! ;!BLE CREMA 900 $ 15,000.00 107 :ES! PARMESAN! 250 $ 2,700.00 108
$

12,000.00

CEDULA NOMBRE 65677894 ANA 2209456 ANGEL 1005678945 BERNAR;! 64577893 CAR!LINA 101458738 FELIPE 64577987 HERNAN 69876548 JLIANA 1007843641 LARA 65789009 NELL< 101345698 !MAR

APELLIDO VENTA! SAN;!VAL 12 = BENITEZ 23 = G!MEZ 30 = RESTREP! 15 = VILLARREAL 14 = MANJARREZ 13 = !TER! 21 = PEREZ 16 = SANT!S 35 =

989>000 4>999>000 5>100>000 1>500>000 1>350>000 1>000>000 3>880>000 2>000>000 5>467>000

PACHEC!

3>500>000

20 =

LACTEO! LPG C+""( 25C # 12E - 161 T("? 2742583 VEN;E;!R?

#N@A

CE;LA?

CE;LA? TELEF!N!? ;IRECCI!N? CLL12C#23-12 FECHA? C!;IG! N!MBRE ;EL PR!;CT! CANTI;A; VAL!R 101 ARE:IPE !RIGINAL 500 2 = 102 AVENA LPG 250 3 = 103 CREMA ;E LECHE 500 ." 1 = 104 LECHE ;ESLACT!SA;A 1L 2 = 105 LECHE ENTERA 1L 3 = 106 :ES! ;!BLE CREMA 900 1 = 107 :ES! PARMESAN! 250 2 = 108
ISABEL SANCHEZ

T!TAL?

8>000 2>400 4>500 2>500 2>500 15>000 2>700 15>500 15>000 12>000

65543211 2822769 S++> M+ 20> 2017 SBT!TAL = 16>000 = 7>200 = 4>500 = 5>000 = 7>500 = 15>000 = 5>400 = 46>500 = 15>000 = 12>000 = 134>100 = 21>456 =

155>556

LACTE!S LPG INFORME R"#%"& '" V"&()# M"# T*()+ V"&()# M)* 200 A/+ 198 M)* 199 T*()+ 597

V(+% T$.(%( * V((*

C"'+) N*%" V"&'"'* 65677894 ANA SAN;!VAL 2209456 ANGEL BENITEZ 1005678945 BERNAR;! G!MEZ 64577893 CAR!LINA RESTREP! 101458738 FELIPE VILLARREAL 64577987 HERNAN MANJARREZ 69876548 JLIANA !TER! 1007843641 LARA PEREZ 65789009 NELL< SANT!S 101345698 !MAR PACHEC! E (" T$.(%( (" V((* ( .+% (+% (+"$)*

V)+* "& V"&()# = 989>000 = 4>999>000 = 5>100>000 = 1>500>000 = 1>350>000 = 1>000>000 = 3>880>000 = 2>000>000 = 5>467>000 = 3>500>000 (%? NELL< SANT!S

L+ "(/( (% "+ '(( ( "+ $+ DT*.+ .+% L(/(

LACTE!S LPG INFORME R"#%"& '" V"&()# M"# T*()+ V"&()# M)* 1300 A/+ 1400 M)* 1326 T*()+ 4026

V(+% T$.(%( * P*/*

C*'/* N*%" P*'(* 101 ARE:IPE !RIGINAL 500 102 AVENA LPG 250 103 CREMA ;E LECHE 500 ." 104 LECHE ;ESLACT!SA;A 1L 105 LECHE ENTERA 1L 106 :ES! ;!BLE CREMA 900 107 :ES! PARMESAN! 250 108
N '" P*'. V"&'. 100 250 180 876 800 500 300 300 120 600 LECHE ;ESLACT!SA;A 1L

L+ "(/( (% "+ '(( ( "+ $+ DT*.+ .+% L(/(

LACTE!S LPG INFORME R"#%"& '" V"&()# M"# T*()+ C*%)# M)* = 1>250>000 A/+ = 1>200>000 M)* = 1>251>856 T*()+ = 3>701>856

C*.+% T$.(%( * C"$((

C"'+) N*%" C+/"&(" 12344444 EVER MEZA 12234566 FABIAN EVILLA 56754322 GILMA PATERNINA 65543211 ISABEL SANCHEZ 23456789 JST! JIMENEZ 34566786 L!RENA M!NTES 33456333 LIS FELLIZZ!LA 23134567 MARGARET SANT!S 45674234 !SCAR R!MER! 34567433 RAL MARTINEZ E (" T$.(%( C"$(( ( .+% /*.* (%?

V. E& C*%)# = 400>000 = 350>000 = 100>000 = 155>556 = 800>000 = 225>000 = 500>000 = 525>000 = 346>500 = 299>800 JST! JIMENEZ

L+ "(/( (% "+ '(( ( "+ $+ DT*.+ .+% L(/(

C("+ V+"* ( V(+%

T*+% T*+%

E(+% ( "+ ANA SAN;!VAL ANGEL BENITEZ BERNAR;! G!MEZ CAR!LINA RESTREP! FELIPE VILLARREAL HERNAN MANJARREZ JLIANA !TER! LARA PEREZ NELL< SANT!S !MAR PACHEC! T*+" ((+"

S.+ ( V+"* ( V(+% S.+ ( V+"* ( V(+%2 989000 989000 4999000 4999000 5100000 5100000 1500000 1500000 1350000 1350000 1000000 1000000 3880000 3880000 2000000 2000000 5467000 5467000 3500000 3500000 29785000 29785000

ANALISIS? A" +"$/+ * * +$*% "*%> %( (( %/+ "+ $'*.+/$* (%(++ +(* ( "*% +"*(% + %*"* ((.*% (%/*( (" .+$.* +"* ( (" "* ( +"* ( (+% ( $.($++.(( *% +

C("+ V& E C*.+%

T*+% T*+%

E(+% ( "+ EVER MEZA FABIAN EVILLA GILMA PATERNINA ISABEL SANCHEZ JST! JIMENEZ L!RENA M!NTES LIS FELLIZZ!LA MARGARET SANT!S !SCAR R!MER! RAL MARTINEZ T*+" ((+"

S.+ ( V& E C*.+% S.+ ( V& E C*.+%2 400000 400000 350000 350000 100000 100000 155556 155556 800000 800000 225000 225000 500000 500000 525000 525000 346500 346500 299800 299800 3701856 3701856

*+*% ( (" */(%*> * ((."*> %$ (%(+.*% /**/( ( ((* * .+% (+% " *.( ( "+ (%*+ ( .+% ($*