ACTIVIDAD EXCEL GRADO 11
Realice la siguiente tabla de excel a partir de las siguientes instrucciones:
Comenzando en la celda C3, Debes construir una
Tabla de 7 Columnas. El título principal de la tabla será: PLANTA DE PERSONAL. Los subtítulos de cada
columna están en los datos que se describen a continuación.
La tabla que construirás, debe tener los datos
en el siguiente orden:
|
Matricula |
Apellido |
Nombre |
Cargo |
Dependencia |
Salario |
Fecha de Ingreso |
|
Matrícula |
Apellido |
Nombre |
|
1011 |
Gorton |
Hazel |
|
1012 |
Preston |
Liza |
|
1041 |
Tercan |
Robert |
|
1054 |
Smith |
Howard |
|
1055 |
Albert |
Maxine |
|
1056 |
Gonzales |
Joe |
|
1067 |
Scote |
Gail |
|
1068 |
Mann |
Alyssa |
|
1075 |
Kane |
Sheryl |
|
1076 |
McKormick |
Brad |
|
1078 |
Hapsbuch |
Kendrick |
|
1079 |
Price |
Ellen |
|
1080 |
Foss |
Felix |
|
1152 |
Henders |
Mark |
|
1153 |
Plant |
Allen |
|
1154 |
Solomon |
Ari |
|
1167 |
Berwick |
Sam |
|
1168 |
Asonte |
Toni |
|
1169 |
Dorfberg |
Jeremy |
|
1284 |
Bellwood |
Frank |
|
1285 |
Taylor |
Ralph |
|
1290 |
Cooper |
Linda |
|
1291 |
Constance |
Burt |
|
1292 |
Seidel |
Matt |
|
1293 |
Cronwith |
Brent |
|
1294 |
North |
Robert |
|
1299 |
Simpson |
Sandrae |
|
1300 |
Richards |
Phillip |
|
1301 |
Sofer |
Ariel |
|
1301 |
Sindole |
Randy |
|
1302 |
Berg |
Bobby |
|
1303 |
Lark |
Donald |
|
1310 |
Smith |
Ellen |
|
1311 |
Cane |
Nate |
|
1329 |
Vuanuo |
Tuome |
|
1330 |
Selznick |
Anna |
|
1331 |
Cash |
Mary |
|
1333 |
Szcznyck |
Tadeuz |
|
1334 |
Kaneko |
Midori |
|
1352 |
Ygarre |
Lisa |
|
1353 |
Hardy |
Bill |
|
1354 |
Beech |
Susan |
|
1359 |
Morton |
Sara |
|
1360 |
Raye |
Alice |
|
1361 |
Stone |
Cindy |
|
1368 |
Wu |
Tammy |
|
1369 |
Barth |
Sandra |
|
1370 |
Townes |
Everett |
|
1426 |
Lampstone |
Pete |
|
1427 |
Price |
David |
|
1428 |
Ferngood |
Jules |
|
1509 |
Kegler |
Pam |
|
1510 |
White |
Jessica |
|
1516 |
Bell |
Tom |
|
1517 |
Quan |
Karen |
|
1518 |
Smythe |
Leslie |
|
1529 |
Kellerman |
Tommie |
|
1530 |
Stewart |
Iain |
|
1531 |
Lempert |
Alexandra |
|
1556 |
Davison |
Karen |
|
1557 |
Bates |
Lisa |
|
1558 |
Sargent |
Evelyn |
|
1572 |
Tuppman |
Lise-Anne |
|
1573 |
Robbins |
Bob |
|
1574 |
Weston |
Sam |
|
1656 |
Kourios |
Theo |
|
1657 |
Wells |
Rose |
|
1658 |
Coyne |
Dennis |
|
1673 |
Dixon-Waite |
Sherrie |
|
1674 |
Boughton |
Frank |
|
1674 |
Cummins |
Dave |
|
1675 |
Melendez |
Jaime |
|
1675 |
Miller |
Janet |
|
1676 |
Wells |
Jason |
|
1677 |
Levine |
Eric |
|
1695 |
Nelson |
Ed |
|
1696 |
Abdul |
Cathy |
|
1723 |
Alstain |
Isolde |
|
1724 |
Chu |
Steven |
|
1724 |
Sammler |
Mark |
|
1725 |
Hodge |
Alex |
|
1725 |
Farley |
Sam |
|
1758 |
Brwyne |
Melia |
|
1759 |
Alexi |
Stephanie |
|
1792 |
Barton |
Eileen |
|
1793 |
Able |
Aaron |
|
1794 |
Goldberg |
Malcolm |
|
1814 |
Al-Sabah |
Daoud |
|
1815 |
Fein |
Caroline |
|
1816 |
Lin |
Michael |
|
1906 |
Bankler |
Rowena |
|
1907 |
Homes |
Megan |
|
1908 |
Zostoc |
Melissa |
|
1922 |
Smith |
Barbara |
|
1923 |
Barber |
Lisa |
|
1931 |
Mueller |
Ursula |
|
1932 |
McGuire |
Ellen |
|
1933 |
Johnson |
Miguel |
|
1949 |
Sampson |
Carla |
|
1950 |
Smith |
Rich |
|
1960 |
Fontaine |
Jean |
|
1961 |
Mueller |
Kris |
|
1962 |
Wolf |
Hilda |
|
1966 |
Corwick |
Rob |
|
1967 |
Aruda |
Felice |
|
1967 |
Cortlandt |
Charles |
|
1968 |
Larssen |
Erika |
|
1968 |
Martinez |
Sara |
|
1969 |
West |
Cara |
|
1975 |
Franklin |
Larry |
|
1976 |
Petry |
Robin |
|
1977 |
Maguire |
Mollie |
|
1977 |
Gladstone |
Wes |
|
1978 |
Silverberg |
Jay |
|
Cargo |
Dependencia |
|
Auxiliar Contable |
Contabilidad |
|
Ing. Mecánico |
Ingeniería |
|
Aux. Admin. Unidad |
I + D |
|
Aux. Diseño |
Diseño |
|
Aux. Admin. Unidad |
Mercado |
|
Director Unidad |
Administración |
|
Especialista Diseño |
Diseño |
|
Ing. Mecánico |
Ingeniería |
|
Aux. Diseño |
Diseño |
|
Ingeniero Jefe |
Ingeniería |
|
Aux. Administrativo |
Mercado |
|
Aux. Administrativo |
Administración |
|
Investigador |
I + D |
|
Auxiliar Contable |
Contabilidad |
|
Aux. Admin. Unidad |
Contabilidad |
|
Ing. Software |
Ingeniería |
|
Representante |
Mercado |
|
Aux. Admin. Unidad |
Ingeniería |
|
Ing. Software |
Ingeniería |
|
Respon. Producto |
Mercado |
|
Group Mgr. |
Mercado |
|
Aux. Administrativo |
Administración |
|
Aux. Administrativo |
Administración |
|
Representante |
Mercado |
|
Técnico |
Ingeniería |
|
Ing. Mecánico |
Ingeniería |
|
Aux. Técnico |
Ingeniería |
|
Contable |
Contabilidad |
|
Ing. Técnico |
Ingeniería |
|
Aux. Administrativo |
Mercado |
|
Director Ingeniero |
Ingeniería |
|
Ing. Software |
Ingeniería |
|
Técnico |
Ingeniería |
|
Respon. Producto |
Mercado |
|
Técnico |
Ingeniería |
|
Contable |
Contabilidad |
|
Ing. Software |
Ingeniería |
|
Técnico |
Ingeniería |
|
Aux. Admin. Unidad |
I + D |
|
Aux. Técnico |
Ingeniería |
|
Investigador Jefe |
I + D |
|
Ing. Técnico |
Ingeniería |
|
Respon. Producto |
Mercado |
|
Aux. Admin. Unidad |
Ingeniería |
|
Técnico |
I + D |
|
Aux. Administrativo |
Administración |
|
Investigador Jefe |
I + D |
|
Investigador |
I + D |
|
Representante |
Mercado |
|
Investigador Jefe |
I + D |
|
Ing. Técnico |
Ingeniería |
|
Aux. Administrativo |
Ingeniería |
|
Ing. Mecánico |
Ingeniería |
|
Auxiliar Contable |
Contabilidad |
|
Director Ingeniero |
Ingeniería |
|
Ing. Software |
Ingeniería |
|
Aux. Administrativo |
Ingeniería |
|
Aux. Administrativo |
Administración |
|
Investigador |
I + D |
|
Técnico |
Ingeniería |
|
Aux. Administrativo |
Administración |
|
Respon. Producto |
Mercado |
|
Técnico |
Ingeniería |
|
Contable |
Contabilidad |
|
Ing. Técnico |
Ingeniería |
|
Aux. Administrativo |
Mercado |
|
Contable |
Contabilidad |
|
Ing. Software |
Ingeniería |
|
Aux. Administrativo |
Ingeniería |
|
Auxiliar Contable |
Contabilidad |
|
Aux. Admin. Unidad |
I + D |
|
Aux. Admin. Unidad |
Contabilidad |
|
Representante |
Mercado |
|
Aux. Administrativo |
Administración |
|
Investigador |
I + D |
|
Especialista Diseño |
Diseño |
|
Ing. Mecánico |
Ingeniería |
|
Técnico |
Ingeniería |
|
Aux. Admin. Unidad |
Mercado |
|
Respon. Producto |
Mercado |
|
Director Unidad |
Administración |
|
Director Unidad |
Mercado |
|
Especialista Diseño |
Diseño |
|
Ingeniero Jefe |
Ingeniería |
|
Especialista Diseño |
Diseño |
|
Aux. Administrativo |
Administración |
|
Respon. Producto |
Mercado |
|
Aux. Técnico |
Ingeniería |
|
Director Ingeniero |
Ingeniería |
|
Ing. Software |
Ingeniería |
|
Aux. Administrativo |
Mercado |
|
Aux. Admin. Unidad |
Mercado |
|
Director Unidad |
Administración |
|
Aux. Técnico |
Ingeniería |
|
Respon. Producto |
Mercado |
|
Contable |
Contabilidad |
|
Contable |
Contabilidad |
|
Ing. Técnico |
Ingeniería |
|
Respon. Producto |
Mercado |
|
Group Mgr. |
Mercado |
|
Aux. Admin. Unidad |
Contabilidad |
|
Aux. Administrativo |
Administración |
|
Representante |
Mercado |
|
Aux. Diseño |
Diseño |
|
Aux. Administrativo |
Administración |
|
Representante |
Mercado |
|
Office Manager |
Administración |
|
Respon. Producto |
Mercado |
|
Representante |
Mercado |
|
Auxiliar Contable |
Contabilidad |
|
Aux. Admin. Unidad |
Ingeniería |
|
Especialista Diseño |
Diseño |
|
Ing. Software |
Ingeniería |
|
Ingeniero Jefe |
Ingeniería |
|
Salario |
Fecha ingreso |
|
$27.598 |
2/3/86 |
|
$43.394 |
1/26/86 |
|
$28.044 |
4/16/92 |
|
$25.176 |
4/16/91 |
|
$26.041 |
4/8/91 |
|
$116.511 |
10/25/79 |
|
$36.940 |
9/20/87 |
|
$47.883 |
9/12/87 |
|
$23.239 |
8/7/92 |
|
$105.753 |
7/30/79 |
|
$29.983 |
4/1/86 |
|
$29.983 |
3/24/86 |
|
$64.738 |
10/29/88 |
|
$26.646 |
1/21/90 |
|
$28.044 |
1/13/90 |
|
$56.177 |
7/7/87 |
|
$31.914 |
4/18/91 |
|
$23.036 |
4/10/91 |
|
$34.002 |
10/13/92 |
|
$46.486 |
1/4/85 |
|
$77.179 |
12/27/84 |
|
$26.114 |
1/3/85 |
|
$35.786 |
12/26/84 |
|
$51.340 |
11/20/87 |
|
$40.897 |
9/14/84 |
|
$58.358 |
9/6/84 |
|
$24.854 |
12/21/89 |
|
$30.452 |
12/13/89 |
|
$58.326 |
1/9/86 |
|
$27.081 |
8/6/84 |
|
$79.280 |
7/29/84 |
|
$56.177 |
3/3/88 |
|
$30.411 |
10/4/86 |
|
$43.487 |
9/26/86 |
|
$30.411 |
2/22/89 |
|
$31.539 |
2/14/89 |
|
$42.872 |
5/11/89 |
|
$29.362 |
4/16/90 |
|
$28.044 |
4/8/90 |
|
$31.068 |
9/18/82 |
|
$59.455 |
9/10/82 |
|
$69.070 |
5/6/86 |
|
$49.485 |
8/9/90 |
|
$33.051 |
8/1/88 |
|
$34.605 |
7/22/88 |
|
$32.884 |
3/11/83 |
|
$57.756 |
3/3/83 |
|
$53.685 |
11/27/87 |
|
$34.689 |
9/8/77 |
|
$59.455 |
8/31/77 |
|
$53.721 |
11/12/86 |
|
$29.983 |
6/19/85 |
|
$46.387 |
6/11/85 |
|
$28.550 |
3/6/85 |
|
$62.590 |
2/26/85 |
|
$44.351 |
6/18/90 |
|
$25.147 |
1/28/87 |
|
$25.147 |
1/20/91 |
|
$41.053 |
5/11/86 |
|
$29.362 |
11/26/81 |
|
$30.000 |
11/18/81 |
|
$41.987 |
10/16/82 |
|
$34.605 |
7/15/88 |
|
$35.889 |
7/7/88 |
|
$50.651 |
2/9/86 |
|
$29.015 |
12/14/87 |
|
$32.627 |
12/6/87 |
|
$44.351 |
6/6/88 |
|
$29.983 |
4/16/90 |
|
$27.598 |
3/25/92 |
|
$31.048 |
4/8/90 |
|
$29.045 |
3/17/92 |
|
$33.301 |
10/26/81 |
|
$30.000 |
10/18/81 |
|
$37.896 |
11/6/87 |
|
$38.094 |
10/20/84 |
|
$79.307 |
10/12/84 |
|
$29.362 |
8/6/90 |
|
$28.044 |
7/29/90 |
|
$58.482 |
2/10/78 |
|
$79.061 |
2/12/78 |
|
$97.096 |
2/2/78 |
|
$35.785 |
3/18/82 |
|
$61.856 |
3/10/82 |
|
$28.859 |
12/24/90 |
|
$24.180 |
12/16/90 |
|
$37.489 |
12/18/84 |
|
$21.304 |
3/4/89 |
|
$70.935 |
2/25/80 |
|
$35.480 |
7/8/90 |
|
$31.917 |
9/28/89 |
|
$33.051 |
9/20/89 |
|
$72.820 |
5/15/84 |
|
$28.405 |
12/5/86 |
|
$47.986 |
11/27/86 |
|
$26.101 |
6/20/89 |
|
$47.853 |
6/12/89 |
|
$67.535 |
1/8/84 |
|
$62.981 |
10/12/81 |
|
$104.565 |
10/4/81 |
|
$28.044 |
11/13/86 |
|
$27.081 |
11/5/86 |
|
$66.603 |
10/22/87 |
|
$23.239 |
11/17/91 |
|
$23.212 |
11/9/91 |
|
$58.278 |
4/13/82 |
|
$65.822 |
4/5/82 |
|
$35.989 |
1/1/93 |
|
$58.278 |
4/14/89 |
|
$21.888 |
5/7/91 |
|
$23.036 |
4/29/91 |
|
$30.014 |
6/13/80 |
|
$48.786 |
9/9/91 |
|
$51.879 |
6/5/80 |
Comentarios
Publicar un comentario