PRACTICAS DE EXCEL

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		Hotel Viajero SA de CV	Platillos		Bebidas		Postres		Entradas		Cafés		Ventas Totales	D.T	T.A	T.F	% Faltas
2		Nombre del Empleado	10		27		18		5		23		Ventas Totales	35	T.A	T.F	% Faltas
3	1	ALVAREZ SANDOVAL ENRIQUE ABDIEL	10	10	26	9.6	15	8.3	5	10.0	23	10.0	9.6	35	35	0	0%
4	2	DAVILA HERNANDEZ MIGUEL ANGEL	10	10	21	7.8	17	9.4	3	6.0	22	9.6	8.3	35	33	2	6%
5	3	DAVILA JUAREZ BELEN	10	10	27	10	18	10	5	10.0	21	9.1	10.0	35	34	1	3%
6	4	DE LA CRUZ CERON ALLISON	10	10	27	10	18	10	5	10.0	14	6.1	10.0	35	34	1	3%
7	5	DE LA ROSA MANCILLA EVA MONSERRATH	10	10	23	8.5	18	10	5	10.0	14	6.1	9.6	35	34	1	3%
8	6	ESPINOZA PONCE CARLOS EDUARDO	10	10	23	8.5	16	8.9	3	6.0	16	7.0	8.4	35	34	1	3%
9	7	FERMAN DIAZ CARLOS	0	0	22	8.1	16	8.9	5	10.0	22	9.6	6.8	35	32	3	9%
10	8	FLORES REYES MARGARITA	10	10	22	8.1	18	10	2	4.0	21	9.1	8.0	35	33	2	6%
11	9	FLORES JUAREZ CONSTANTINO	10	10	23	8.5	18	10	5	10.0	16	7.0	9.6	35	34	1	3%
12	10	FLORES RAMIREZ ABIGAIL	0	0	20	7.4	18	10	5	10.0	9	3.9	6.9	35	29	6	21%
13	11	GARCIA GARCIA ADRIANA	10	10	27	10	18	10	5	10.0	15	6.5	10.0	35	35	0	0%
14	12	GARCIA GARITA YONATHAN	6	6	16	5.9	16	8.9	4	8.0	18	7.8	7.2	35	25	10	40%
15	13	GARITA JUAREZ CITLALI	0	0	0	0	18	10	0	0.0	13	5.7	2.5	35	27	8	30%
16	14	GARITA QUINTERO DAVID SALOMON	0	0	19	7	18	10	4	8.0	14	6.1	6.3	35	33	2	6%
17	15	GARITA CESAR IVETH	0	0	0	0	10	5.6	0	0.0	12	5.2	1.4	35	22	13	59%
18	16	GARITA HERNANDEZ LIZETH	10	10	22	8.1	18	10	2	4.0	10	4.3	8.0	35	33	2	6%
19	17	GUARNEROS MUNIVE JOSE MIGUEL	0	0	0	0	15	8.3	0	0.0	19	8.3	2.1	35	30	5	17%
20	18	GUEVARA CASTRO LUIS ARTURO	0	0	22	8.1	18	10	3	6.0	17	7.4	6.0	35	30	5	17%
21	19	GUTIERREZ BLANCAS ERICK	7	7	20	7.4	15	8.3	1	2.0	18	7.8	6.2	35	35	0	0%
22	20	HERNANDEZ CASTILLA VIANEY	0	0	24	8.9	18	10	4	8.0	9	3.9	6.7	35	30	5	17%
23	21	HERNANDEZ CESAR VENANCIO EDOARDO	0	0	21	7.8	18	10	4	8.0	12	5.2	6.4	35	35	0	0%
24	22	HERNANDEZ JUAREZ JAQUELINE	10	10	24	8.9	18	10	5	10.0	15	6.5	9.7	35	33	2	6%
25	23	HERNANDEZ PEÑAFLOR ITZEL	10	10	24	8.9	18	10	5	10.0	20	8.7	9.7	35	34	1	3%
26	24	HERNANDEZ REYES JUAN CARLOS	10	10	21	7.8	18	10	1	2.0	19	8.3	7.4	35	32	3	9%
27	25	JUAREZ AMARO YARELI	0	0	0	0	0	0	0	0.0		0.0	0.0	35	0	35	#¡DIV/0!
28	26	JUAREZ AUSTRIA BRAYAN	10	10	21	7.8	18	10	5	10.0	20	8.7	9.4	35	33	2	6%
29	27	JUAREZ CARRANZA FERNANDA	10	10	27	10	18	10	4	8.0	19	8.3	9.5	35	34	1	3%
30	28	JUAREZ ROMAN RAUL	8	8	10	3.7	16	8.9	3	6.0	13	5.7	6.6	35	25	10	40%
31	29	JUAREZ CALVA ANGEL JHOVANY	7	7	20	7.4	15	8.3	2	4.0	10	4.3	6.7	35	32	3	9%
32	30	JUAREZ DAVILA OMAR	0	0	0	0	0	0	1	2.0	18	7.8	0.5	35	29	6	21%
33	31	JUAREZ PIEDRAS ADILENE	10	10	27	10	18	10	5	10.0	18	7.8	10.0	35	32	3	9%
34	32	JUAREZ RAMIREZ JESUS	0	0	0	0	0	0	1	2.0	16	7.0	0.5	35	31	4	13%
35	33	JUAREZ ROJANO GABRIEL	0	0	21	7.8	18	10	3	6.0	21	9.1	5.9	35	35	0	0%
36	34	LOPEZ GARITA ANET MICHEL	0	0	22	8.1	18	10	4	8.0	12	5.2	6.5	35	30	5	17%
37	35	PEREZ ROJANO MIRIAM	0	0	0	0	0	0	0	0.0	25	10.9	0.0	35	26	9	35%
38	36	PEREZ SANDOVAL EDGAR	10	10	27	10	18	10	5	10.0	16	7.0	10.0	35	33	2	6%
39	37	PEREZ FLORES ALEXIS	10	10	22	8.1	18	10	4	8.0	21	9.1	9.0	35	32	3	9%
40	38	RAMIREZ SALTILLO YASMIN	10	10	28	10	15	8.3	3	6.0	22	9.6	8.7	35	34	1	3%
41	39	RAMIREZ SOLANO NATALY	0	0	0	0	0	0		0.0		0.0	0.0	35	0	35	#¡DIV/0!
42	40	SANDOVAL CESAR EMMANUEL	0	0	26	9.6	18	10	4	8.0	9	3.9	6.9	35	33	2	6%
43	41	SOLIS HERNANDEZ ARTURO	0	0	0	0	0	0	0	0.0	13	5.7	0.0	35	32	3	9%
44	42	VAZQUEZ CESAR ANGEL	0	0	0	0	0	0	0	0.0	16	7.0	0.0	35	34	1	3%
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100