Calcule el promedio de las ventas de los

empeados por mes y por ao.

Cuadro 1
Nombre de empleado:
Ao:
Promedio de ventas en los seis meses:

Woll Pizarro, Ursula Kay

Cuadro 2
Mes:
Ao:
Promedio de ventas de todos los empleados:

Enero
Ao 2009
9,868.63

Ventas Ao 2009
Cdigo
E00352
E00228
E00338
E00445
E00313
E00498
E00345
E00457
E00123
E00125
E00141
E00320
E00404
E00197
E00371
E00295
E00244
E00497
E00036
E00189
E00097
E00165
E00307
E00083

DNI
24280596
28657286
28245681
24280596
21995443
26168784
24923246
25406160
25167618
23653584
25954763
27982098
27898734
24280596
24935872
23278973
24414743
21923395
21385102
24280596
24280596
21334059
24225851
26021590

Empleados
Cmero Kuroki, Patricia Lourdes
Woll Pizarro, Ursula Kay
Hurtado Morales, Reyna
Vilca Vsquez, Jessica Kiara
Ordinola Delgado, Lidia Socorro
Lambruschini Tarazona, Erika Sarita
Chau Dimitriades, Jorge
Zuschrott Garca, Valery
Aguilar Casas, Samuel
Barrientos Brquez, Gabriela
Alban Cuestas, Gina Cecilia
Pujaico Gutierrez, Jessica Karina
Gil, Liz Karen
Aldana Gonzles, Rocio
De Souza Ferreyra Seminario, Blanca Deborah
Torres Alarcn, Karina Alejandra
Paredes Villarreal, Darln Milagros
Galindo Ranilla, Milagros
Galindo Ranilla, Lourdes
Nacarino Gnzales, Yenni
Lpez Carranza, Mara Fernanda
Cmero Kuroki, Fanny Julissa
Cmero Kuroki, Aida Rosa
Sotelo Godoy, Sandra Eulalia

Enero
S/. 5,313.00
S/. 9,879.00
S/. 11,650.00
S/. 13,568.00
S/. 8,019.00
S/. 8,256.00
S/. 11,447.00
S/. 8,223.00
S/. 13,038.00
S/. 7,351.00
S/. 10,399.00
S/. 10,482.00
S/. 12,752.00
S/. 5,974.00
S/. 8,265.00
S/. 11,452.00
S/. 7,509.00
S/. 9,743.00
S/. 10,437.00
S/. 13,020.00
S/. 14,724.00
S/. 5,511.00
S/. 12,119.00
S/. 7,716.00

Febrero
S/. 14,574.00
S/. 7,321.00
S/. 12,972.00
S/. 13,318.00
S/. 12,953.00
S/. 12,273.00
S/. 8,995.00
S/. 5,731.00
S/. 14,421.00
S/. 13,093.00
S/. 5,237.00
S/. 13,918.00
S/. 9,140.00
S/. 8,209.00
S/. 10,394.00
S/. 8,442.00
S/. 14,938.00
S/. 11,196.00
S/. 11,918.00
S/. 6,968.00
S/. 6,791.00
S/. 11,414.00
S/. 8,801.00
S/. 8,766.00

Ventas Ao 2010
Cdigo
E00352
E00228
E00338
E00445
E00313
E00498
E00345
E00457
E00123
E00125
E00141
E00320
E00404
E00197
E00371
E00295
E00244
E00497
E00036
E00189
E00097
E00165
E00307
E00083

DNI
24280596
28657286
28245681
24280596
21995443
26168784
24923246
25406160
25167618
23653584
25954763
27982098
27898734
24280596
24935872
23278973
24414743
21923395
21385102
24280596
24280596
21334059
24225851
26021590

Empleados
Cmero Kuroki, Patricia Lourdes
Woll Pizarro, Ursula Kay
Hurtado Morales, Reyna
Vilca Vsquez, Jessica Kiara
Ordinola Delgado, Lidia Socorro
Lambruschini Tarazona, Erika Sarita
Chau Dimitriades, Jorge
Zuschrott Garca, Valery
Aguilar Casas, Samuel
Barrientos Brquez, Gabriela
Alban Cuestas, Gina Cecilia
Pujaico Gutierrez, Jessica Karina
Gil, Liz Karen
Aldana Gonzles, Rocio
De Souza Ferreyra Seminario, Blanca Deborah
Torres Alarcn, Karina Alejandra
Paredes Villarreal, Darln Milagros
Galindo Ranilla, Milagros
Galindo Ranilla, Lourdes
Nacarino Gnzales, Yenni
Lpez Carranza, Mara Fernanda
Cmero Kuroki, Fanny Julissa
Cmero Kuroki, Aida Rosa
Sotelo Godoy, Sandra Eulalia

Enero
S/. 9,107.00
S/. 9,742.00
S/. 11,040.00
S/. 10,934.00
S/. 13,257.00
S/. 9,187.00
S/. 6,789.00
S/. 10,625.00
S/. 10,624.00
S/. 9,005.00
S/. 8,850.00
S/. 8,315.00
S/. 11,789.00
S/. 13,659.00
S/. 10,016.00
S/. 8,762.00
S/. 10,344.00
S/. 14,528.00
S/. 13,502.00
S/. 10,272.00
S/. 12,990.00
S/. 13,022.00
S/. 7,812.00
S/. 10,700.00

Febrero
S/. 14,365.00
S/. 13,979.00
S/. 13,427.00
S/. 6,833.00
S/. 7,559.00
S/. 9,554.00
S/. 5,200.00
S/. 12,130.00
S/. 5,407.00
S/. 7,584.00
S/. 5,726.00
S/. 8,513.00
S/. 14,687.00
S/. 5,733.00
S/. 6,474.00
S/. 11,091.00
S/. 14,161.00
S/. 8,474.00
S/. 10,076.00
S/. 11,257.00
S/. 12,553.00
S/. 14,799.00
S/. 14,461.00
S/. 9,738.00

Woll Pizarro, Ursula Kay

Ao 2009
Ao 2010

Enero
Ao 2009
9,868.63

Marzo
S/. 5,936.00
S/. 8,691.00
S/. 12,759.00
S/. 14,728.00
S/. 10,046.00
S/. 11,721.00
S/. 14,704.00
S/. 13,887.00
S/. 11,695.00
S/. 14,423.00
S/. 7,114.00
S/. 14,661.00
S/. 9,287.00
S/. 14,522.00
S/. 14,609.00
S/. 13,115.00
S/. 8,792.00
S/. 5,612.00
S/. 12,436.00
S/. 7,870.00
S/. 8,916.00
S/. 6,734.00
S/. 7,755.00
S/. 14,754.00

S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.

Abril
5,339.00
12,885.00
9,616.00
11,965.00
11,047.00
13,296.00
9,738.00
12,960.00
11,314.00
14,870.00
11,776.00
6,941.00
8,621.00
7,209.00
8,036.00
5,031.00
9,595.00
7,018.00
6,406.00
12,880.00
6,710.00
6,366.00
14,053.00
10,855.00

Mayo
S/. 14,879.00
S/. 14,713.00
S/. 11,808.00
S/. 8,909.00
S/. 6,325.00
S/. 5,060.00
S/. 8,502.00
S/. 8,644.00
S/. 11,461.00
S/. 5,747.00
S/. 13,327.00
S/. 9,687.00
S/. 10,564.00
S/. 13,309.00
S/. 6,349.00
S/. 7,882.00
S/. 13,327.00
S/. 6,722.00
S/. 8,677.00
S/. 14,053.00
S/. 13,384.00
S/. 12,362.00
S/. 5,313.00
S/. 6,629.00

S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.

Junio
10,465.00
5,600.00
14,724.00
11,479.00
11,720.00
8,475.00
9,734.00
7,552.00
8,203.00
5,971.00
14,410.00
9,605.00
8,720.00
12,213.00
11,581.00
5,237.00
12,797.00
13,786.00
10,774.00
12,680.00
12,255.00
9,705.00
8,031.00
12,061.00

Marzo
S/. 5,606.00
S/. 8,825.00
S/. 8,442.00
S/. 11,154.00
S/. 7,764.00
S/. 5,805.00
S/. 6,394.00
S/. 11,877.00
S/. 9,594.00
S/. 5,226.00
S/. 5,055.00
S/. 9,696.00
S/. 9,667.00
S/. 11,438.00
S/. 7,345.00
S/. 12,709.00
S/. 7,906.00
S/. 10,965.00
S/. 9,797.00
S/. 13,884.00
S/. 9,462.00
S/. 11,745.00
S/. 6,334.00
S/. 5,566.00

S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.

Abril
12,598.00
10,080.00
6,725.00
9,414.00
10,833.00
8,410.00
11,930.00
13,422.00
5,090.00
10,445.00
8,506.00
11,567.00
11,966.00
8,374.00
14,630.00
14,348.00
7,211.00
13,360.00
9,052.00
10,968.00
11,912.00
9,484.00
7,895.00
7,957.00

Mayo
S/. 12,799.00
S/. 13,326.00
S/. 10,944.00
S/. 11,440.00
S/. 7,616.00
S/. 11,710.00
S/. 6,166.00
S/. 14,274.00
S/. 6,416.00
S/. 12,237.00
S/. 9,639.00
S/. 6,271.00
S/. 7,810.00
S/. 14,509.00
S/. 8,788.00
S/. 13,160.00
S/. 10,616.00
S/. 5,064.00
S/. 8,427.00
S/. 5,638.00
S/. 7,731.00
S/. 12,868.00
S/. 8,821.00
S/. 13,767.00

S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.
S/.

Junio
14,483.00
11,292.00
9,566.00
9,752.00
7,757.00
9,971.00
14,185.00
9,912.00
10,929.00
9,036.00
8,739.00
5,779.00
8,878.00
12,880.00
14,108.00
5,391.00
7,711.00
12,744.00
7,275.00
7,687.00
11,619.00
6,273.00
14,870.00
13,702.00

BUSCA SIMPLE EN BASE DE DATOS COMERCIAL

Cdigo
1256
1356
1485
5458
6589
2582
2541
2563
2568
7784
9586

1485
Estantera 80x8x200
198
NO
0
20000
3,960,000.00
712,800.00
4,672,800.00

Producto
Estantera 30x8x200
Estantera 50x8x200
Estantera 80x8x200
Estantera 70x8x200
Silla: Modelo "ACC"
Silla: Modelo "ACB"
Silla: Modelo "CCC"
Silla: Modelo "DDC"
Mesa: Modelo B
Mesa: Modelo C
Mesa: Modelo D

Usar desref

Precio Unitario

156.00
168.00
198.00
155.00
56.00
58.00
98.00
77.00
256.00
285.00
296.00

Disponibilidad
Almacen
SI
NO
NO
SI
SI
NO
NO
SI
NO
NO
SI

Existencias
12

18
58

15

25

En la celda D7 utilice validacin para ingresar los Cdigos

Uso de la Funcin ndice y Coincidir

Reg. N

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

Ciudad

Vendedor

Producto

Scaner

Producto

Cantidad

Cantidad

Vendedor

Salcedo

Vendedor

Producto

Cantidad

G-10282

Fecha

AREQUIPA

Salcedo

8/9/2003

Scaner

AREQUIPA

Salcedo

8/26/2003

Scaner

AREQUIPA

Salcedo

9/17/2003

Tinta

AREQUIPA

Salcedo

9/23/2003

Tinta

AREQUIPA

Sarmiento

10/25/2003

Modem

AYACUCHO

Salcedo

9/26/2003

Discos

AYACUCHO

Salcedo

10/4/2003

impresoras

AYACUCHO

Salcedo

10/8/2003

Scaner

AYACUCHO

Salcedo

12/4/2003

CPU

CAJAMARCA

Salcedo

11/20/2003

impresoras

CAJAMARCA

Sarmiento

11/25/2003

Teclado

CAJAMARCA

Salcedo

12/2/2003

CPU

CAJAMARCA

Salcedo

12/9/2003

impresoras

CAJAMARCA

Salcedo

12/13/2003

Cables

CAJAMARCA

Salcedo

12/13/2003

Fax

CUSCO

Salcedo

8/2/2003

ICA

Sarmiento

10/24/2003

Fax

IQUITOS

Sarmiento

10/11/2003

CD

IQUITOS

Sarmiento

11/5/2003

impresoras

IQUITOS

Salcedo

11/8/2003

Fax

IQUITOS

Sarmiento

11/15/2003

Discos

PIURA

Sarmiento

9/24/2003

Tinta

PIURA

Salcedo

12/3/2003

impresoras

PUNO

Sarmiento

8/28/2003

Modem

PUNO

Salcedo

9/2/2003

Modem

PUNO

Salcedo

9/11/2003

Cables

PUNO

Sarmiento

9/18/2003

Tinta

SAN MARTIN

Salcedo

10/14/2003

CPU

SAN MARTIN

Sarmiento

10/23/2003

Fax

TACNA

Salcedo

7/23/2003

Audifinos

TACNA

Sarmiento

12/2/2003

Teclado

TRUJILLO

Salcedo

12/24/2003

Parlantes

TUMBES

Salcedo

12/20/2003

Parlantes

TUMBES

Salcedo

12/23/2003

Parlantes

impresoras

Importe

4
3
27
14
2
9
3
5
2
8
64
2
1
58
1
2
4
119
3
5
4
3
3
4
10
57
32
3
1
65
6
7
14
9

2,320.00
1,743.36
954.40
498.50
285.12
268.80
2,094.30
2,835.00
950.00
5,398.72
8,593.28
1,167.68
690.00
863.60
480.00
1,376.00
2,036.16
1,191.20
2,070.00
2,436.18
141.60
88.80
2,046.24
479.40
1,296.00
848.70
1,117.80
1,497.00
480.00
1,614.88
834.20
525.00
1,058.40
691.20

Scaner
3
Salcedo
Cdigo
H-10269
G-10282
F-10300
D-10304
G-10333
E-10307
R-10312
T-10314
W-10366
W-10353
A-10354
Y-10363
U-10369
P-10375
A-10376
D-10265
L-10332
M-10320
C-10342
X-10346
Z-10348
K-10305
-10364
Z-10284
G-10288
D-10297
J-10302
H-10323
O-10330
R-10257
Q-10360
L-10385
S-10381
G-10383

Desref