8/16/2019 excel-12-ejercicio.xls

http://slidepdf.com/reader/full/excel-12-ejercicioxls 1/4

Artículo Cliente Zona Enero Febrero

Pez espada Cliente1 Sur   6,458.00 BsF 2,988.00 BsF

Cliente2 Oeste 6,987.00 BsF 3,012.00 BsF

ues! "an#$ Cliente1 Sur   4,658.00 BsF 3,562.00 BsF

Pez espada Cliente2 Oeste 5,297.00 BsF 3,665.00 BsF

Cliente3 Oeste 6,320.00 BsF 4,586.00 BsF

Cliente4 &!rte 4,114.00 BsF 4,587.00 BsF

Pez espada Cliente4 &!rte 2,354.00 BsF 4,785.00 BsF

 'l%as (!n)u Cliente5 *ste 4,897.00 BsF 4,932.00 BsFCua+ada de +u Cliente5 *ste 8,000.00 BsF 5,011.00 BsF

Cliente6 &!rte 5,265.00 BsF 5,023.00 BsF

Pez espada Cliente7 Sur   3,698.00 BsF 5,220.00 BsF

Cua+ada de +u Cliente8 Oeste 4,051.00 BsF 5,221.00 BsF

Cua+ada de +u Cliente9 *ste 5,789.00 BsF 5,477.00 BsF

Pez espada Cliente6 &!rte 3,589.00 BsF 5,645.00 BsF

 'l%as (!n)u Cliente10 *ste 4,859.00 BsF 5,984.00 BsF

 'l%as (!n)u Cliente7 Sur  3,614.00 BsF 6,041.00 BsF

ues! "an#$ Cliente8 Oeste 5,812.00 BsF 6,508.00 BsF

Cua+ada de +u Cliente9 *ste 6,296.00 BsF 6,955.00 BsF

!tales p!r Cliente Cliente

Cliente !tal Cliente1

Cliente1 29,078.00 BsF Cliente2

Cliente2 29,777.00 BsF Cliente3

Cliente3 17,460.00 BsF Cliente4

Cliente4 24,295.00 BsF Cliente5

Cliente5 30,838.00 BsF Cliente6

Cliente6 28,730.00 BsF Cliente7

Cliente7 28,498.00 BsF Cliente8Cliente8 33,149.00 BsF Cliente9

Cliente9 35,521.00 BsF Cliente10

Cliente10 16,327.00 BsF Total general!tal %eneral 273,673.00 BsF

Su-a de !tal !na

 'rt/#ul! *ste &!rte Oeste Sur 

 'l%as (!n)u 29,934.00 BsF 15,642.00 BsF

Cua+ada de +u 52,752.00 BsF 14,271.00 BsF

Pez espada 24,893.00 BsF 14,568.00 BsF 28,691.00 BsF

ues! Ca)rales 28,132.00 BsF 32,669.00 BsF

ues! "an#$e%! a Past!ra 18,878.00 BsF 13,243.00 BsF

VENTAS 1er  TRIMES

ues!Ca)rales

ues!Ca)rales

ues!Ca)rales

ues!Ca)rales

8/16/2019 excel-12-ejercicio.xls

http://slidepdf.com/reader/full/excel-12-ejercicioxls 2/4

!tal %eneral 82,686.00 BsF 53,025.00 BsF 80,386.00 BsF 57,576.00 BsF

Su-a de !tales 'rt/#ul!

!na Cliente 'l%as (!n)u Cua+ada de +ud/as Pez espada

*ste Cliente10 16,327.00 BsF

Cliente5 13,607.00 BsF 17,231.00 BsF

Cliente9 35,521.00 BsF

!tal *ste 29,934.00 BsF 52,752.00 BsF

&!rte Cliente4 11,107.00 BsF

Cliente6 13,786.00 BsF

!tal &!rte 24,893.00 BsF

Oeste Cliente2 14,568.00 BsF

Cliente3

Cliente8 14,271.00 BsF

!tal Oeste 14,271.00 BsF 14,568.00 BsF

Sur Cliente1 15,835.00 BsF

Cliente7 15,642.00 BsF 12,856.00 BsF!tal Sur  15,642.00 BsF 28,691.00 BsF

!tal %eneral 45,576.00 BsF 67,023.00 BsF 68,152.00 BsF

!na !das

Su-a de !tales

 'rt/#ul! !tal

 'l%as (!n)u 45,576.00

Cua+ada de +u 67,023.00

Pez espada 68,152.00

ues! Ca)ral 60,801.00 ues! "an#$ 32,121.00

!tal %eneral 273,673.00

Zona romedio de Ener Promedio de Febrero Promedio de Marzo

*ste 5,968.20 5,671.80 4,897.20

&!rte 3,830.50 5,010.00 4,415.75

Oeste 5,693.40 4,598.40 5,785.40

Sur 4,607.00 4,452.75 5,334.25

Total general !11"#$$ % "!&#'( % !1$"#)' %

8/16/2019 excel-12-ejercicio.xls

http://slidepdf.com/reader/full/excel-12-ejercicioxls 3/4

Marzo Totale*

6,389.00 BsF 15,835.00 BsF

5,210.00 BsF 15,209.00 BsF

5,023.00 BsF 13,243.00 BsF

5,606.00 BsF 14,568.00 BsF

6,554.00 BsF 17,460.00 BsF

4,487.00 BsF 13,188.00 BsF

3,968.00 BsF 11,107.00 BsF

3,778.00 BsF 13,607.00 BsF4,220.00 BsF 17,231.00 BsF

4,656.00 BsF 14,944.00 BsF

3,938.00 BsF 12,856.00 BsF

4,999.00 BsF 14,271.00 BsF

6,894.00 BsF 18,160.00 BsF

4,552.00 BsF 13,786.00 BsF

5,484.00 BsF 16,327.00 BsF

5,987.00 BsF 15,642.00 BsF

6,558.00 BsF 18,878.00 BsF

4,110.00 BsF 17,361.00 BsF

Enero Febrero Marzo11,116.00 BsF 6,550.00 BsF 11,412.00 BsF

12,284.00 BsF 6,677.00 BsF 10,816.00 BsF

6,320.00 BsF 4,586.00 BsF 6,554.00 BsF

6,468.00 BsF 9,372.00 BsF 8,455.00 BsF

12,897.00 BsF 9,943.00 BsF 7,998.00 BsF

8,854.00 BsF 10,668.00 BsF 9,208.00 BsF

7,312.00 BsF 11,261.00 BsF 9,925.00 BsF

9,863.00 BsF 11,729.00 BsF 11,557.00 BsF12,085.00 BsF 12,432.00 BsF 11,004.00 BsF

4,859.00 BsF 5,984.00 BsF 5,484.00 BsF

&+!),#)) -*F ,&!+)+#)) -*F &+!"1$#)) -*F

!tal %eneral

45,576.00 BsF

67,023.00 BsF

68,152.00 BsF

60,801.00 BsF

32,121.00 BsF

TRE

8/16/2019 excel-12-ejercicio.xls

http://slidepdf.com/reader/full/excel-12-ejercicioxls 4/4

273,673.00 BsF

ues! Ca)rales ues! "an#$e%! a Past!ra !tal %eneral

16,327.00 BsF

30,838.00 BsF

35,521.00 BsF

82,686.00 BsF

13,188.00 BsF 24,295.00 BsF

14,944.00 BsF 28,730.00 BsF

28,132.00 BsF 53,025.00 BsF

15,209.00 BsF 29,777.00 BsF

17,460.00 BsF 17,460.00 BsF

18,878.00 BsF 33,149.00 BsF

32,669.00 BsF 18,878.00 BsF 80,386.00 BsF

13,243.00 BsF 29,078.00 BsF

28,498.00 BsF13,243.00 BsF 57,576.00 BsF

60,801.00 BsF 32,121.00 BsF 273,673.00 BsF

& de entas p!r z!na

!na !tal

*ste 5

&!rte 4

Oeste 5

Sur 4

!tal %eneral 18