EXAMEN DEL ISUR EXEL

8/18/2019 EXAMEN DEL ISUR EXEL

1/39


2/39


3/39

a"la#$

Años de Serv. Gratificación esc!ento Neto A%os &erv

16 S/. 500.00 S/. !2.53 S/. 1,6"2.50 0

28 S/. 500.00 S/. !2.53 S/. 1,6"2.50 2

9 S/. !50.00 S/. 89.38 S/. 1,985.60 !

11 S/. 500.00 S/. !2.53 S/. 1,6"2.50 6

21 S/. 500.00 S/. 89.38 S/. 2,035.60 8

12 S/. 500.00 S/. 29."5 S/. 1,320.30 1031 S/. 500.00 S/. 89.38 S/. 2,035.60

2! S/. 500.00 S/. !2.53 S/. 1,6"2.50

8 S/. !50.00 S/. 1!1.08 S/. 2,8"3.90 a"la#'

26 S/. 500.00 S/. 89.38 S/. 2,035.60 Cod(Agencia

1" S/. 500.00 S/. 1".50 S/. 982.50 AG001

1! S/. 500.00 S/. 13".50 S/. 2,862.50 AG002

11 S/. 500.00 S/. "1.50 S/. 1,"28.50 AG003

20 S/. 500.00 S/. 19.60 S/. 1,0!0.!0 AG00!

2! S/. 500.00 S/. 29."5 S/. 1,320.30

10 S/. 500.00 S/. 31.50 S/. 1,368.50

26 S/. 500.00 S/. 9.00 S/. 1,091.00

13 S/. 500.00 S/. 9.00 S/. 1,091.00 50015 S/. 500.00 S/. 9.00 S/. 1,091.00 500

!50

500

500

500

500

500

(0.5 Pts)

inreso hasta la Fecha Límite

or - cu-as condiciones están

el sueldo básico. 1i laC o 5 el descuento es de

s todo redondeado a un

or/atos:1. 5ar los siuientes or/atos :(color de fuente azul) a los códios de los

traba!adores cu-o a*o de inreso sea osterior ala*o '777 - cu-o Básico sea suerior a 18. '777.(color de fuente ro!o) a los códios de lostraba!adores cu-o a*o de inreso sea anterior al a*o'777 - cu-o Básico sea inferior a 18.0777. (1.0 Pts)


4/39

!50

500

500

500

500

500

500500

500

500

500


5/39

)rati*icación 20009CAG001 16

S/. 150 198811CAG002 28

S/. 250 200"10BAG002 9

S/. 350 20055CAG003 11

S/. !00 1995"BAG00! 21

S/. !50 200!11'AG001 12

S/. 500 198512BAG001 3119923CAG002 2!

20088AAG003 8

199012BAG002 26

Agencia 19991'AG003 1"

Ca4a 20021AAG002 1!

Cercado 20053BAG001 11

*iraflores 19965'AG003 20

Cerro Colorado 19923CAG002 2!

20068CAG002 10

199012AG001 26

200311AG003 13

!2.53 16"2.50 200111AG002 15!2.53 16"2.50

89.38 1985.60

!2.53 16"2.50

89.38 2035.60

29."5 1320.30

89.38 2035.60

!2.53 16"2.50


6/39

1!1.08 28"3.90

89.38 2035.60

1".50 982.50

13".50 2862.50

"1.50 1"28.50

19.60 10!0.!0

29."5 1320.3031.50 1368.50

VA7

VA7

VA7


7/39

$++ $+++ '--- '--$ '--' otal

Limón 9,800.00 16,500.00 22,600.00 2!,!50.00 26,800.00 100,150.00

.elón 3,500.00 3,650.00 3,580.00 2,910.00 !,300.00 1",9!0.00

/aran0a 5,980.00 3,500.00 6,0!0.00 8,200.00 ",500.00 31,220.00

Papaya ",800.00 10,200.00 11,!00.00 10,890.00 9,600.00 !9,890.00

Pl1tano 5,900.00 ",900.00 13,200.00 15,800.00 16,800.00 59,600.00

otal 32,980.00 !1,"50.00 56,820.00 62,250.00 65,000.00 258,800.00

Gráfico "

Gráfico #

S&erercados ABC

099:0999 '777 '770

'77'

; <

; 2777.77

; 07777.77

; 02777.77

; '7777.77

; '2777.77

; 67777.77

4677.77

=277.77

9>77.77

0>:77.77

'>:77.77

Cart $tl

/onto &3. (n /$ls)

Limón? 693@elón? =3

$aran!a? 0'3

aa-a? 093

látano? '63

1994 1999 2000 2001 2002


8/39


9/39

Crar los s$gu$nts grcos usan"o los "atos " la ta6la 7s$gu$n"o los /o"los "l la"o "rco:1. ráco0" (1.5Pts)2. ráco'" (1.5Pts)


10/39


11/39


12/39


13/39

Gráfico $

Grco%: Comletar los datos de la tabla se%n la fórmula -crear el ráco corresondiente. (1.5Pts)

.7


14/39

x 25.0 0.09!893!1 0.09!893!1

5.0 9".1"08!"1 9".1"08!"1

!.5 0.12613608 0.12613608

!.5 6!.5816"!2 6!.5816"!2

!.0 0.166""51 0.166""51

!.0 !2.69!!26! !2.69!!26!

3.5 0.219188"" 0.219188""

3.5 28.056162! 28.056162!

3.0 0.2861"856 0.2861"856

3.0 18.315!2"9 18.315!2"9

2.5 0.3"108!02 0.3"108!02

2.5 11.8"!688" 11.8"!688"2.0 0.!"82328 0.!"82328

2.0 ".651"2!"3 ".651"2!"3

1.5 0.61!!805 0.61!!805

1.5 !.9158!!02 !.9158!!02

1.0 0."93"0053 0."93"0053

1.0 3.1"!8021 3.1"!8021

0.5 1.0!"!0053 1.0!"!0053

0.5 2.09!80106 2.09!80106

0.0 1.!!22!95" 1.!!22!95"

.7


15/39

4.7 >.7

&


16/39


17/39

!/20/2002 verd&ras coliflor 1.5 1".20 25.80

3/23/2002 e%esras frioles !.5 1".20 "".!0

2/2!/2002 verd&ras aio 2.8 1".80 !9.8!

1/23/2002 verd&ras al-eras 2 18.90 3".80

!/23/2002 car%e (alli%a 8 19.56 156.!8

!/23/2002 verd&ras lec&(a 1.2 19.80 23."6

1/25/2002 e%esras frioles !.5 23.00 103.50

1/25/2002 verd&ras aio 2.8 23.50 65.80

!/26/2002 verd&ras a-as 2.1 2!."0 51.8"

2/26/2002 verd&ras al-eras 2 25.30 50.60

!/2"/2002 e%esras frioles !.5 25.60 115.20

!/2"/2002 fr&as el:% 2 25.60 51.20

!/2"/2002 e%esras (ar-a%zos 3.8 26.80 101.8!

!/2"/2002 e%esras le%eas 2.2 29.50 6!.90

3/16/2002 verd&ras za%aorias 0." 29.80 20.86

3/16/2002 verd&ras a-as 1.9 36.50 69.35

2/1"/2002 verd&ras za%aorias 0." 36.80 25."6

1/23/2002 e%esras allares !.6 !5.60 209."61/23/2002 verd&ras za%aorias 0." !5.80 32.06

1/23/2002 e%esras (ar-a%zos 3.8 !".00 1"8.60

1/23/2002 verd&ras a-as 1.8 !".30 85.1!

!/20/2002 verd&ras %a-o 2.3 !".50 109.25

!/20/2002 fr&as aa4a 1.3 !8."0 63.31

1/25/2002 verd&ras lec&(a 1.2 50.00 60.00

1/25/2002 fr&as a%(os 3 55.20 165.60

2/26/2002 verd&ras a-as 1.9 56.00 106.!0

5/1/2002 verd&ras a-as 1.8 56.80 102.2!

5/1/2002 verd&ras lec&(a 1.2 !5."0 5!.8!

5/1/2002 verd&ras za%aorias 0." 120.50 8!.35

5/1/2002 verd&ras %a-o 2.3 "0.00 161.005/1/2002 verd&ras ce-ollas 0.6 189."0 113.82

1/12/2002 e%esras le%eas 2.2 56.90 125.18

2/16/2002 verd&ras coliflor 1.5 5".60 86.!0

1/12/2002 car%e cordero ".5 59.00 !!2.50

2/16/2002 fr&as el:% 2 59.60 119.20

!/28/2002 verd&ras za%aorias 0." 59.60 !1."2

1/2!/2002 car%e (alli%a 8 "5.00 600.00

1/2!/2003 fr&as a%za%a 1.8 120.00 216.00

1/2!/2003 car%e avo 12.5 120.00 1,500.00

2/18/2002 car%e cordero ".5 120.30 902.25

1/25/2002 fr&as lio%es 3.2 120.30 38!.96

!/25/2002 fr&as %ara%a 1.2 120.80 1!!.96

!/25/2002 fr&as lio%es 3.2 123.50 395.20

3/16/2002 fr&as lio%es 3.2 123.50 395.20

2/16/2002 fr&as eras 3 1!5.60 !36.80

2/16/2002 fr&as a%(os 3 1!".12 !!1.36

2/16/2002 fr&as la%o 2 1!".36 29!."2

2/16/2002 fr&as lio%es 3.2 1!".58 !"2.26

1/25/2002 car%e ollo 5.5 150.00 825.00

1/25/2002 fr&as %ara%a 1.2 150.60 180."2

1/25/2002 car%e res 10 158.00 1,580.00

1/25/2002 fr&as aa4a 1.3 158.20 205.66

1/25/2002 fr&as eras 3 158.30 !"!.90!/16/2002 fr&as la%o 2 158.30 316.60


18/39

3/28/2002 fr&as a%(os 3 158.60 !"5.80

2/25/2002 car%e res 10 159.50 1,595.00

3/2/2002 fr&as a%za%a 1.8 159.56 28".21

3/2/2002 fr&as la%o 2 169.!0 338.80

!/5/2002 car%e cordero ".5 1"8.!0 1,338.00

1/6/2002 fr&as la%o 2 1"8.!0 356.80

3/18/2002 car%e ollo 5.5 188.50 1,036."5

3/18/2002 car%e res 10 189.20 1,892.00

5/10/2002 fr&as %ara%a 1.2 156.50 18".80

5/10/2002 fr&as a%za%a 1.8 235.00 !23.00

5/10/2002 fr&as &vas 3.5 125.00 !3".50

5/10/2002 fr&as a%(os 3 230.00 690.00

5/10/2002 fr&as la%o 2 !20.00 8!0.00

3/"/2002 fr&as %ara%a 1.2 189.50 22".!0

!/15/2002 car%e res 10 189.60 1,896.00

2/16/2002 car%e ollo 5.5 193.60 1,06!.80

3/1"/2002 car%e cordero ".5 203.60 1,52".00

!/25/2002 car%e ollo 5.5 230."0 1,268.855/26/2002 car%e res 10 350.00 3,500.00

5/26/2002 car%e ollo 5.5 5"8.50 3,181."5

5/26/2002 car%e cordero ".5 152.00 1,1!0.00


19/39

Im&!esto

2.53!6

5.0692

1.3!52

2.5"83

2.39!

9.1""

9.1""

25.1"5

25.1"5

!.9381

2.1!"!.52295

51.528

8.8806

33.25

8.8806

29.68"5

21.96!

19.665

6.555

8."!

11.286

"5.58216.91

20.1552

!8.5336

10.!2"2

!0.!985

9.6!25

"9.6138

1".8"52

5.5062

6."56!

3.0"8

2.698

3.306

2."55

22.192

5.5!8

3.5568

6.5208

2.96!

".505

6.60!!

6.2852

!."595!."595

9.150!

t$l$;an"o los "atos " la l$staCalcular:

1. La Cantidad de D. ,endidos enEerduras - Frutas. (1.5 Pts)

2. Cuál fue el romedio de losmontos de las ,entas durante los

meses de enero - febrero del a*o'77'. (1.5 Pts)

%. #l n%mero de ,entas de Carneefectuados en los días mártes -mircoles. (1.5 Pts)


20/39

!.902

1!."06

9.!696

".182

29."312

!.51!!

19.665

12.502

9.8553

9.61!

21.888

9."28

19.3!96

12.331

3.963!

13.1"65

!.89!!

39.85!!6.091!

33.93!

16.1"66

20."5"5

12.0289

11.!

31.!6!

20.216

19.!256

10.!196

16.0265

30.5921.6258

23."8!2

16.!16

8!.0"5

22.6!8

".9268

11!

!1.0!

285

1"1.!2"5

"3.1!2!

2".5!2!

"5.088

"5.088

82.992

83.858!

55.9968

89."286!

156."5

3!.3368

300.2

39.0"5!

90.23160.15!


21/39

90.!02

303.05

5!.56952

6!.3"2

25!.22

6"."92

196.9825

359.!8

35.682

80.3"

83.125

131.1

159.6

!3.206

360.2!

202.312

290.13

2!1.0815665

60!.5325

216.6


22/39

%i&o

verd&ras

fr&as

;A*<

"6 %i&o %i&o

12" verd&ras fr&as

%i&o

"6 verd&ras

fr&as

S/. 2"8."9 0 1

1

%i&o

3 car%e 0

car%e 0


23/39


24/39


25/39

Código_'rod Fecha_Ing Fecha_Sa, 'recio Cantidad_()g*

200202=001>01" 2/15/2002 3/16/2002 2.3 5.80

200202=002>019 2/15/2002 2/22/2002 !.6 5.80

200201=001>00! 1/10/2002 1/25/2002 1.2 5.90

200203=001>01" 3/10/2002 3/13/2002 2.3 5.90

200203=001>00! 3/10/2002 3/22/2002 1.2 10.50

20020!=002>019 !/12/2002 !/28/2002 !.6 10.50200203=002>019 3/10/2002 3/25/2002 !.6 10.50

20020!=003>021 !/13/2002 !/30/2002 12.5 10.60

200203=003>021 3/13/2002 3/28/2002 12.5 10.60

200203=001>001 3/1!/2002 !/3/2002 2.3 11.30

20020!=001>02" !/15/2002 5/9/2002 1 11.30

200312=001>01" 12/16/2003 1/6/200! 1.5 15.8"

200312=003>021 12/18/2003 1/6/200! 13.56 20.00

200302=002>009 2/16/2003 3/3/2003 3.8 12.30

200301=003>021 1/12/2003 2/9/2003 12.5 1!.00

200303=002>009 3/1"/2003 !/1!/2003 3.8 12.30

200302=003>021 2/1"/2003 2/2"/2003 12.5 12.50

200!01=003>008 1/5/200! 1/22/200! 6.8 1".00200!01=003>006 1/10/200! 1/31/200! !.5 23.00

200!01=00!>016 1/21/200! 2/5/200! 2.3 15.00

200!01=002>001 1/30/200! 2/6/200! 2.3 20.00

200!02=001>02" 2/1/200! 3/1/200! 3.6 16.50

200!02=003>025 2/15/200! 2/2"/200! 15.6 25.50

200!02=00!>020 2/20/200! 2/28/200! 2.5 35.60

200!02=002>009 2/25/200! 3/1/200! 6.8 15.60

200!03=003>025 3/2/200! 3/1"/200! 12.! 20.60

200!03=00!>01! 3/10/200! 3/12/200! 5.6 9.80

200!03=002>00" 3/12/200! 3/30/200! 1!.5 1!."0

200!03=001>002 3/19/200! !/!/200! 3.5 1!.50

200!03=003>006 3/25/200! 3/25/200! 1!.6 28."0200!03=00!>018 3/30/200! !/3/200! 5.6 16.80

200201=001>01" 1/18/2002 1/25/2002 2.3 12.60

200203=001>002 3/18/2002 !/12/2002 2.8 12."0

200202=001>00! 2/19/2002 2/22/2002 1.2 13.50

200202=001>02" 2/19/2002 3/1"/2002 1 1!.20

200201=001>00! 1/10/2002 2/2/2002 1.2 1!.50

200203=001>02" 3/10/2002 3/22/2002 1 1!.50

200203=003>008 3/16/2002 !/8/2002 8 1!.60

200201=00!>016 1/1!/2002 1/23/2002 2 1!.60

200203=001>011 3/21/2002 3/30/2002 1.2 15.60

200203=002>012 3/22/2002 !/!/2002 2.2 15.60

200201=001>02" 1/!/2002 1/31/2002 1 15.60

20020!=001>001 !/!/2002 !/2!/2002 2.5 15.80

S&erercados ABC

$ltrar (A'an;a"os) odos los reistros de los ios Carnes - Eerduras cu-os @ontos másma-or a 277. (Coiar los resultados a artir de a celda @00).G #l io de roducto se encuentra en el códio de roducto (CódioH

770,erduras 77'menestras 776Carne 774frutas.(1.5 Pts)


26/39

200202=002>012 2/1"/2002 3/8/2002 2.2 15.80

200203=00!>016 3/16/2002 3/30/2002 2 16.5!

200201=001>005 1/1!/2002 1/1"/2002 1.5 16."0

200203=001>005 3/19/2002 3/25/2002 1.5 16."0

20020!=001>002 !/20/2002 !/29/2002 2.8 1".20

20020!=001>005 !/20/2002 5/19/2002 1.5 1".20

200203=002>00" 3/23/2002 3/2!/2002 !.5 1".20

200202=001>002 2/2!/2002 3/9/2002 2.8 1".80

200201=001>001 1/23/2002 1/25/2002 2 18.90

20020!=003>008 !/23/2002 5/21/2002 8 19.56

20020!=001>011 !/23/2002 5/13/2002 1.2 19.80

200201=002>00" 1/25/2002 1/30/2002 !.5 23.00

200201=001>002 1/25/2002 1/2"/2002 2.8 23.50

20020!=001>010 !/26/2002 !/29/2002 2.1 2!."0

200202=001>001 2/26/2002 2/2"/2002 2 25.30

20020!=002>00" !/2"/2002 5/2/2002 !.5 25.60

20020!=00!>016 !/2"/2002 5/!/2002 2 25.60

20020!=002>009 !/2"/2002 5/1"/2002 3.8 26.8020020!=002>012 !/2"/2002 5/23/2002 2.2 29.50

200203=001>028 3/16/2002 !/6/2002 0." 29.80

200203=001>010 3/16/2002 3/21/2002 1.9 36.50

200202=001>028 2/1"/2002 2/21/2002 0." 36.80

200201=002>019 1/23/2002 1/23/2002 !.6 !5.60

200201=001>028 1/23/2002 2/6/2002 0." !5.80

200201=002>009 1/23/2002 2/1/2002 3.8 !".00

200201=001>010 1/23/2002 2/8/2002 1.8 !".30

20020!=001>01" !/20/2002 !/25/2002 2.3 !".50

20020!=00!>020 !/20/2002 5/18/2002 1.3 !8."0

200201=001>011 1/25/2002 1/30/2002 1.2 50.00

200201=00!>01! 1/25/2002 2/8/2002 3 55.20200202=001>010 2/26/2002 3/18/2002 1.9 56.00

200205=001>010 5/1/2002 5/!/2002 1.8 56.80

200205=001>011 5/1/2002 5/29/2002 1.2 !5."0

200205=001>028 5/1/2002 5/16/2002 0." 120.50

200205=001>01" 5/1/2002 5/23/2002 2.3 "0.00

200205=001>003 5/1/2002 5/10/2002 0.6 189."0

200201=002>012 1/12/2002 1/25/2002 2.2 56.90

200202=001>005 2/16/2002 2/21/2002 1.5 5".60

200201=003>006 1/12/2002 1/2!/2002 ".5 59.00

200202=00!>016 2/16/2002 3/13/2002 2 59.60

20020!=001>028 !/28/2002 5/1/2002 0." 59.60

200201=003>008 1/2!/2002 2/11/2002 8 "5.00

200301=00!>015 1/2!/2003 2/1!/2003 1.8 120.00

200301=003>021 1/2!/2003 2/10/2003 12.5 120.00

200202=003>006 2/18/2002 3/12/2002 ".5 120.30

200201=00!>013 1/25/2002 1/28/2002 3.2 120.30

20020!=00!>018 !/25/2002 5/8/2002 1.2 120.80

20020!=00!>013 !/25/2002 5/23/2002 3.2 123.50

200203=00!>013 3/16/2002 3/21/2002 3.2 123.50

200202=00!>022 2/16/2002 3/!/2002 3 1!5.60

200202=00!>01! 2/16/2002 3/!/2002 3 1!".12

200202=00!>023 2/16/2002 2/26/2002 2 1!".36

200202=00!>013 2/16/2002 2/18/2002 3.2 1!".58200201=003>02! 1/25/2002 2/9/2002 5.5 150.00


27/39


28/39

+onto Im&!esto

13.3! 2.53!6

26.68 5.0692

".08 1.3!52

13.5" 2.5"83

12.60 2.39!

!8.30 9.1"" !8.30 9.1""

132.50 25.1"5

132.50 25.1"5

25.99 !.9381

11.30 2.1!"

23.81 !.52295

2"1.20 51.528

!6."! 8.8806

1"5.00 33.25

!6."! 8.8806

156.25 29.68"5

115.60 21.96! 103.50 19.665

3!.50 6.555

!6.00 8."!

59.!0 11.286

39".80 "5.582

89.00 16.91

106.08 20.1552

255.!! !8.5336

5!.88 10.!2"2

213.15 !0.!985

50."5 9.6!25

!19.02 "9.6138 9!.08 1".8"52

28.98 5.5062

35.56 6."56!

16.20 3.0"8

1!.20 2.698

1".!0 3.306

1!.50 2."55

116.80 22.192

29.20 5.5!8

18."2 3.5568

3!.32 6.5208

15.60 2.96!

39.50 ".505

los Imuestos sea

rod) - es como siue"


29/39

3!."6 6.60!!

33.08 6.2852

25.05 !."595

25.05 !."595

!8.16 9.150!

25.80 !.902

"".!0 1!."06

!9.8! 9.!696

3".80 ".182

156.!8 29."312

23."6 !.51!!

103.50 19.665

65.80 12.502

51.8" 9.8553

50.60 9.61!

115.20 21.888

51.20 9."28

101.8! 19.3!96 6!.90 12.331

20.86 3.963!

69.35 13.1"65

25."6 !.89!!

209."6 39.85!!

32.06 6.091!

1"8.60 33.93!

85.1! 16.1"66

109.25 20."5"5

63.31 12.0289

60.00 11.!

165.60 31.!6! 106.!0 20.216

102.2! 19.!256

5!.8! 10.!196

8!.35 16.0265

161.00 30.59

113.82 21.6258

125.18 23."8!2

86.!0 16.!16

!!2.50 8!.0"5

119.20 22.6!8

!1."2 ".9268

600.00 11!

216.00 !1.0!

1,500.00 285

902.25 1"1.!2"5

38!.96 "3.1!2!

1!!.96 2".5!2!

395.20 "5.088

395.20 "5.088

!36.80 82.992

!!1.36 83.858!

29!."2 55.9968

!"2.26 89."286! 825.00 156."5


30/39

180."2 3!.3368

1,580.00 300.2

205.66 39.0"5!

!"!.90 90.231

316.60 60.15!

!"5.80 90.!02

1,595.00 303.05

28".21 5!.56952

338.80 6!.3"2

1,338.00 25!.22

356.80 6"."92

1,036."5 196.9825

1,892.00 359.!8

18".80 35.682

!23.00 80.3"

!3".50 83.125

690.00 131.1

8!0.00 159.6 22".!0 !3.206

1,896.00 360.2!

1,06!.80 202.312

1,52".00 290.13

1,268.85 2!1.0815

3,500.00 665

3,181."5 60!.5325

1,1!0.00 216.6


31/39

Fecha %i&o 'rod!cto 'recio Cantidad_()g* +onto

2/15/2002 verd&ras %a-o 2.3 5.80 13.3!

2/15/2002 e%esras allares !.6 5.80 26.68

1/10/2002 verd&ras col 1.2 5.90 ".08

3/10/2002 verd&ras %a-o 2.3 5.90 13.5"

3/10/2002 verd&ras col 1.2 10.50 12.60

!/12/2002 e%esras allares !.6 10.50 !8.303/10/2002 e%esras allares !.6 10.50 !8.30

!/13/2002 car%e avo 12.5 10.60 132.50

3/13/2002 car%e avo 12.5 10.60 132.50

3/1!/2002 verd&ras al-eras 2.3 11.30 25.99

!/15/2002 verd&ras vai%ias 1 11.30 11.30

12/16/2003 verd&ras %a-o 1.5 15.8" 23.81

12/18/2003 car%e avo 13.56 20.00 2"1.20

2/16/2003 e%esras (ar-a%zos 3.8 12.30 !6."!

1/12/2003 car%e avo 12.5 1!.00 1"5.00

3/1"/2003 e%esras (ar-a%zos 3.8 12.30 !6."!

2/1"/2003 car%e avo 12.5 12.50 156.25

1/5/200! car%e (alli%a 6.8 1".00 115.601/10/200! car%e cordero !.5 23.00 103.50

1/21/200! fr&as el:% 2.3 15.00 3!.50

1/30/200! e%esras al-eras 2.3 20.00 !6.00

2/1/200! verd&ras vai%ias 3.6 16.50 59.!0

2/15/200! car%e res 15.6 25.50 39".80

2/20/200! fr&as aa4a 2.5 35.60 89.00

2/25/200! e%esras (ar-a%zos 6.8 15.60 106.08

3/2/200! car%e res 12.! 20.60 255.!!

3/10/200! fr&as a%(os 5.6 9.80 5!.88

3/12/200! e%esras frioles 1!.5 1!."0 213.15

3/19/200! verd&ras aio 3.5 1!.50 50."5

3/25/200! car%e cordero 1!.6 28."0 !19.02

3/30/200! fr&as %ara%a 5.6 16.80 9!.08

1/18/2002 verd&ras %a-o 2.3 12.60 28.98

3/18/2002 verd&ras aio 2.8 12."0 35.56

2/19/2002 verd&ras col 1.2 13.50 16.20

2/19/2002 verd&ras vai%ias 1 1!.20 1!.20

1/10/2002 verd&ras col 1.2 1!.50 1".!0

3/10/2002 verd&ras vai%ias 1 1!.50 1!.50

3/16/2002 car%e (alli%a 8 1!.60 116.80

1/1!/2002 fr&as el:% 2 1!.60 29.20

3/21/2002 verd&ras lec&(a 1.2 15.60 18."2

3/22/2002 e%esras le%eas 2.2 15.60 3!.321/!/2002 verd&ras vai%ias 1 15.60 15.60

S&erercados ABC

$ltrar (A'an;a"os) odos las ,entas +ue se ha-an hecho en el rimer trimestre de cual+uitodos los roductos e&ceto manos - melones en donde los Imuest

sido sueriores al romedio. (Coiar los resultados a artir de a celda(1.5 Pts)


32/39


33/39

1/25/2002 car%e ollo 5.5 150.00 825.00

1/25/2002 fr&as %ara%a 1.2 150.60 180."2

1/25/2002 car%e res 10 158.00 1,580.00

1/25/2002 fr&as aa4a 1.3 158.20 205.66

1/25/2002 fr&as eras 3 158.30 !"!.90

!/16/2002 fr&as la%o 2 158.30 316.60

3/28/2002 fr&as a%(os 3 158.60 !"5.80

2/25/2002 car%e res 10 159.50 1,595.00

3/2/2002 fr&as a%za%a 1.8 159.56 28".21

3/2/2002 fr&as la%o 2 169.!0 338.80

!/5/2002 car%e cordero ".5 1"8.!0 1,338.00

1/6/2002 fr&as la%o 2 1"8.!0 356.80

3/18/2002 car%e ollo 5.5 188.50 1,036."5

3/18/2002 car%e res 10 189.20 1,892.00

5/10/2002 fr&as %ara%a 1.2 156.50 18".80

5/10/2002 fr&as a%za%a 1.8 235.00 !23.00

5/10/2002 fr&as &vas 3.5 125.00 !3".50

5/10/2002 fr&as a%(os 3 230.00 690.005/10/2002 fr&as la%o 2 !20.00 8!0.00

3/"/2002 fr&as %ara%a 1.2 189.50 22".!0

!/15/2002 car%e res 10 189.60 1,896.00

2/16/2002 car%e ollo 5.5 193.60 1,06!.80

3/1"/2002 car%e cordero ".5 203.60 1,52".00

!/25/2002 car%e ollo 5.5 230."0 1,268.85

5/26/2002 car%e res 10 350.00 3,500.00

5/26/2002 car%e ollo 5.5 5"8.50 3,181."5

5/26/2002 car%e cordero ".5 152.00 1,1!0.00

Fecha %i&o 'rod!cto 'recio Cantidad_()g* +onto2/15/200! car%e res 15.6 25.50 39".80

3/25/200! car%e cordero 1!.6 28."0 !19.02

1/12/2002 car%e cordero ".5 59.00 !!2.50

1/2!/2002 car%e (alli%a 8 "5.00 600.00

1/2!/2003 car%e avo 12.5 120.00 1,500.00

2/18/2002 car%e cordero ".5 120.30 902.25

1/25/2002 fr&as lio%es 3.2 120.30 38!.96

3/16/2002 fr&as lio%es 3.2 123.50 395.20

2/16/2002 fr&as eras 3 1!5.60 !36.80

2/16/2002 fr&as lio%es 3.2 1!".58 !"2.26

1/25/2002 car%e ollo 5.5 150.00 825.00

1/25/2002 car%e res 10 158.00 1,580.00

1/25/2002 fr&as eras 3 158.30 !"!.90

2/25/2002 car%e res 10 159.50 1,595.00

3/2/2002 fr&as la%o 2 169.!0 338.80


34/39

Im&!esto

2.53!6 'rod!cto 15.0692 ?@a%(os 0

1.3!52 ?@elo%es 0

2.5"83

2.39!

9.1""9.1""

25.1"5

25.1"5

!.9381

2.1!"

!.52295

51.528

8.8806

33.25

8.8806

29.68"5

21.96!19.665

6.555

8."!

11.286

"5.582

16.91

20.1552

!8.5336

10.!2"2

!0.!985

9.6!25

"9.6138

1".8"52

5.5062

6."56!

3.0"8

2.698

3.306

2."55

22.192

5.5!8

3.5568

6.52082.96!

r a*o ens ha-an

00).


35/39

".505

6.60!!

6.2852

!."595

!."595

9.150!

!.902

1!."06

9.!696

".182

29."312

!.51!!

19.665

12.502

9.8553

9.61!

21.888

9."2819.3!96

12.331

3.963!

13.1"65

!.89!!

39.85!!

6.091!

33.93!

16.1"66

20."5"5

12.0289

11.!31.!6!

20.216

19.!256

10.!196

16.0265

30.59

21.6258

23."8!2

16.!16

8!.0"5

22.6!8

".9268

11!

!1.0!

285

1"1.!2"5

"3.1!2!

2".5!2!

"5.088

"5.088

82.992

83.858!

55.996889."286!


36/39

156."5

3!.3368

300.2

39.0"5!

90.231

60.15!

90.!02

303.05

5!.56952

6!.3"2

25!.22

6"."92

196.9825

359.!8

35.682

80.3"

83.125

131.1159.6

!3.206

360.2!

202.312

290.13

2!1.0815

665

60!.5325

216.6

Im&!esto"5.582

"9.6138

8!.0"5

11!

285

1"1.!2"5

"3.1!2!

"5.088

82.992

89."286!

156."5

300.2

90.231

303.05

6!.3"2


37/39

Fecha %i&o 'rod!cto 'recio antidad_() +onto Im&!esto

3/10/2002 verd&ras %a-o 2.3 5.90 13.5" 2.5"83

3/10/2002 verd&ras col 1.2 10.50 12.60 2.39!

3/10/2002 e%esras allares !.6 10.50 !8.30 9.1""

3/13/2002 car%e avo 12.5 10.60 132.50 25.1"5

3/1!/2002 verd&ras al-eras 2.3 11.30 25.99 !.9381

3/1"/2003 e%esras (ar-a%zos 3.8 12.30 !6."! 8.88063/2/200! car%e res 12.! 20.60 255.!! !8.5336

3/10/200! fr&as a%(os 5.6 9.80 5!.88 10.!2"2

3/12/200! e%esras frioles 1!.5 1!."0 213.15 !0.!985

3/19/200! verd&ras aio 3.5 1!.50 50."5 9.6!25

3/25/200! car%e cordero 1!.6 28."0 !19.02 "9.6138

3/30/200! fr&as %ara%a 5.6 16.80 9!.08 1".8"52

3/18/2002 verd&ras aio 2.8 12."0 35.56 6."56!

3/10/2002 verd&ras vai%ias 1 1!.50 1!.50 2."55

3/16/2002 car%e (alli%a 8 1!.60 116.80 22.192

3/21/2002 verd&ras lec&(a 1.2 15.60 18."2 3.5568

3/22/2002 e%esras le%eas 2.2 15.60 3!.32 6.5208

3/16/2002 fr&as el:% 2 16.5! 33.08 6.28523/19/2002 verd&ras coliflor 1.5 16."0 25.05 !."595

3/23/2002 e%esras frioles !.5 1".20 "".!0 1!."06

3/16/2002 verd&ras za%aorias 0." 29.80 20.86 3.963!

3/16/2002 verd&ras a-as 1.9 36.50 69.35 13.1"65

3/16/2002 fr&as lio%es 3.2 123.50 395.20 "5.088

3/28/2002 fr&as a%(os 3 158.60 !"5.80 90.!02

3/2/2002 fr&as a%za%a 1.8 159.56 28".21 5!.56952

3/2/2002 fr&as la%o 2 169.!0 338.80 6!.3"2


38/39


39/39

Documents

EXAMEN DEL ISUR EXEL