43
Produto Teclado 100 120 130 90 50 110 Mouse 200 247 232 258 274 290 Monitor 34 38 35 37 37 38 Impressora 12 15 18 21 24 27 Pentium 20 25 30 35 41 46 Pentium MMX 11 14 17 19 22 25 Disquetes 400 493 607 708 811 915 Drive 50 62 76 88 101 114 Janeiro Fevereiro março abril maio junho

Exercícios Excel Módulo I

Embed Size (px)

Citation preview

Page 1: Exercícios Excel Módulo I

Produto

Teclado 100 120 130 90 50 110Mouse 200 247 232 258 274 290Monitor 34 38 35 37 37 38Impressora 12 15 18 21 24 27Pentium 20 25 30 35 41 46Pentium MMX 11 14 17 19 22 25Disquetes 400 493 607 708 811 915Drive 50 62 76 88 101 114

Janei

ro

Fever

eiro

mar

çoab

rilm

aio

junho

Page 2: Exercícios Excel Módulo I

Total do semestre %

6001400

200150250100

4000300

Meta do semestreju

nho

Page 3: Exercícios Excel Módulo I

Sequencia num sequencia ano data hora

1 010 2000 6/10/2008 12:002 020 2002 6/11/2008 12:153 030 2004 6/12/2008 12:304 040 2006 6/13/2008 12:455 050 2008 6/14/2008 13:006 060 2010 6/15/2008 13:157 070 2012 6/16/2008 13:308 080 2014 6/17/2008 13:459 090 2016 6/18/2008 14:0010 100 2018 6/19/2008 14:1511 110 2020 6/20/2008 14:3012 120 2022 6/21/2008 14:4513 130 2024 6/22/2008 15:0014 140 2026 6/23/2008 15:1515 150 2028 6/24/2008 15:3016 160 2030 6/25/2008 15:4517 170 2032 6/26/2008 16:0018 180 2034 6/27/2008 16:1519 190 2036 6/28/2008 16:3020 200 2038 6/29/2008 16:45

sequência numérica

Page 4: Exercícios Excel Módulo I

dias da semana meses

6/10/2008 janeiro6/11/2008 fevereiro6/12/2008 março6/13/2008 abril6/16/2008 maio6/17/2008 junho6/18/2008 julho6/19/2008 agosto6/20/2008 setembro6/23/2008 outubro6/24/2008 novembro6/25/2008 dezembro6/26/20086/27/20086/30/20087/1/20087/2/20087/3/20087/4/20087/7/2008

Page 5: Exercícios Excel Módulo I

INSTRUTOR CURSO

PEDRO EXCEL 30 2 60GIOVANE WORD 25 1 25SILVANA EXCEL 30 3 90CARLOS EXCEL 15 2 30SIMONE EXCEL 22 1 22ALEXANDRO WORD 30 2 60

TOTAL 152 11 287

QTDE DE HORAS DE CADA CURSO

TOTAL DE CURSOS

TOTAL DE HORAS

Page 6: Exercícios Excel Módulo I

NÚMERO QUADRADO CUBO QUARTA QUINTA2 4 8 16 323 9 27 81 2435 25 125 625 3125

10 100 1000 10000 10000015 225 3375 50625 75937520 400 8000 160000 3200000

Page 7: Exercícios Excel Módulo I

Data: 5/23/2011Dolar: 1.63Frete 10

ALFA IMPORTAÇÃO E EXPORTAÇÃOExportação

Material Destino Peso

Produto Países Quantidade R$ R$ R$ US$Caneta Canadá 2000 0.8 1600 1610 987.73Lápis Japão 3000 0.5 1500 1510 926.38Régua França 3500 1 3500 3510 2153.37Folha A4 Polônia 1000 12 12000 12010 7368.10Borracha Inglaterra 300 0.3 90 100 61.35Compasso Portugal 400 4 1600 1610 987.73Esquadro Estados Unidos 15000 1.23 18450 18460 11325.15Tesoura Canadá 12000 5 60000 60010 36815.95Cola Estados Unidos 4500 2.3 10350 10360 6355.83Caderno Itália 2800 9.8 27440 27450 16840.49

Preço por quilo

Preço do produto

Preço com o frete

Preço em Dólar

Page 8: Exercícios Excel Módulo I

Pesquisa de Artista do Ano

Artista Votos %Cazuza 3456 6%Tim Maia 5634 10%Lulu Santos 8592 16%Raul Seixas 7308 13%Sidnei Magal 4813 9%Cássia Eller 2378 4%Paulinho da Viola 6308 12%Tiririca 812 1%Ivete Sangalo 9567 18%Gaúcho da Fronteira 1276 2%Erasmo Carlos 2387 4%Jorge Aragão 1678 3%TOTAL 54209

Page 9: Exercícios Excel Módulo I

Venda de ProdutosTipos Meses

Produtos Janeiro Fevereiro Março AbrilAAA R$ 200.00 R$ 350.00 R$ 550.00 R$ 235.00 BBB R$ 254.00 R$ 578.00 R$ 854.00 R$ 221.00 CCC R$ 568.00 R$ 546.00 R$ 254.00 R$ 244.00 DDD R$ 540.00 R$ 650.00 R$ 780.00 R$ 980.00 EEE R$ 320.00 R$ 321.00 R$ 355.00 R$ 654.00 FFF R$ 254.00 R$ 321.00 R$ 589.00 R$ 879.00 Somatório 2136 2766 3382 3213Médias 356 461 563.666667 535.5Maior Valor 568 650 854 980Menor Valor 200 321 254 221

Total dos somatórios 11497Média geral dos somatórios 2874.25

Page 10: Exercícios Excel Módulo I

Empresa XYZ Ltda. Saldo Anterior R$ 10,000.00 Fluxo de Caixa Data: 4/8/2023

Conta Nº Doc nº Histórico Entrada Saída D/C Saldo23.2 NF 14567 Material de escritório 0 118 R$ 9,882.00 12.4 NF 3456 Aluguel computador 234 456 R$ 10,338.00 23.4 - Treinamento 5600 R$ 4,738.00 12.5 NF 45678 Venda computador 25000 R$ 29,738.00 23.7 NF 7899 Locação veículo 800 R$ 28,938.00 23.56 - Reforma salas 2 e 3 2347.89 R$ 26,590.11 12.8 - Venda impressora 2456 R$ 29,046.11 13.7 - Livros didáticos 2300 R$ 26,746.11

Totais 27912 11165.89Saldo ATUAL R$ 26,746.11

Page 11: Exercícios Excel Módulo I

1º Semestre de 2008JAN FEV MAR ABR MAI JUN TOTAL

Receitas 1560 1420 860 1980 2500 2800 11120Despesas 920 1100 1200 700 500 700 5120Resultado 2480 2520 2060 2680 3000 3500 16240

Page 12: Exercícios Excel Módulo I

1,500.00 2475 2760 26402,500.00 4125 4600 4400 COTAÇÕES

1,800.00 2970 3312 3168 US$ Oficial2,500.00 4125 4600 4400 1.654,900.00 8085 9016 8624 US$ Paralelo

4,000.00 6600 7360 7040 1.843,600.00 5940 6624 6336 US$ Turismo1,900.00 3135 3496 3344 1.765,000.00 8250 9200 88006,850.00 11302.5 12604 12056

10,000.00 16500 18400 17600

VALOR (US$)

Valor em Reais (US$ Oficial)

Valor em Reais (US$ Paralelo)

Valor em Reais (US$ Turismo)

Page 13: Exercícios Excel Módulo I

Resumo TrimestralRS SC PR

Trigo 100 200 300Soja 100 200 300Feijão 100 200 300

Page 14: Exercícios Excel Módulo I

Funções de Texto Conector de Texto "&"

Digite algo>>> kuehne João Antônio

kuehn Unindo ambos João Antônio

ehne

ehn Juntando tudodigite 1º nome aline

Maiúuscula KUEHNE digite 2º nome saulMinúscula kuehne digite 3º nome friedrich

KuehneFRIEDRICH, Aline Saul

Os primeiros 5 caracteres

Os últimos 4 caracteres

Apartir do terceiro, mostrar 3 caracteres

Primeiras em maiúsculas

B5
Aline Friedrich: direita
B6
Aline Friedrich: esquerda
B7
Aline Friedrich: ext.
B9
Aline Friedrich: maiuscula
B10
Aline Friedrich: minuscula
B11
Aline Friedrich: pri.maiuscula
Page 15: Exercícios Excel Módulo I

EmployeeID NationalIDNumber ContactID LoginID ManagerID178 363910111 1246 adventure-works\barbara1 139216 480951955 1247 adventure-works\mike0 139139 30845 1245 adventure-works\david6 140166 663843431 1251 adventure-works\dragan0 139201 519756660 1252 adventure-works\janet0 139

94 60517918 1249 adventure-works\candy0 13959 363923697 1248 adventure-works\deborah0 139

130 931190412 1250 adventure-works\bryan1 139176 58317344 1262 adventure-works\karen1 42102 671089628 1260 adventure-works\dan0 42

66 525932996 1259 adventure-works\janaina0 42149 314747499 1261 adventure-works\ramesh0 42103 231203233 1244 adventure-works\david5 140

70 619308550 1239 adventure-works\mindy0 30238 367453993 1046 adventure-works\frank2 274233 466142721 1040 adventure-works\gordon0 274231 482810518 1045 adventure-works\fukiko0 274223 407505660 1044 adventure-works\linda2 274244 785853949 1041 adventure-works\erin0 274241 381073001 1042 adventure-works\eric2 274261 20269531 1043 adventure-works\ben0 274198 792847334 1048 adventure-works\arvind0 274164 603686790 1047 adventure-works\mikael0 274109 295847284 1287 adventure-works\ken0140 184188301 1288 adventure-works\laura1 109212 260805477 1263 adventure-works\chris1 90

54 540688287 1264 adventure-works\tengiz0 90117 643805155 1255 adventure-works\françois0 42128 929666391 1254 adventure-works\dan1 42

9 695256908 1005 adventure-works\gail0 311 998320692 1006 adventure-works\jossef0 3

270 56920285 1004 adventure-works\sharon0 3161 260770918 1267 adventure-works\karen0 90127 242381745 1266 adventure-works\sean1 90

90 345106466 1265 adventure-works\zainal0 2003 509647174 1002 adventure-works\roberto0 12

284 982310417 1013 adventure-works\amy0 273225 552560652 1275 adventure-works\magnus0 218218 141165819 1274 adventure-works\gary1 148

71 121491555 1243 adventure-works\wendy0 140191 476980013 1241 adventure-works\grant0 30154 416679555 1240 adventure-works\hao0 30

30 535145551 1242 adventure-works\paula0 14042 441044382 1253 adventure-works\jean0 109

260 153479919 1279 adventure-works\jo1 49251 879334904 1278 adventure-works\lori1 49242 646304055 1277 adventure-works\pat0 49259 28414965 1276 adventure-works\stuart1 49

49 553069203 1280 adventure-works\christian0 218269 323403273 1029 adventure-works\wanida0 6272 52541318 1031 adventure-works\mary2 6

2 253022876 1030 adventure-works\kevin0 66 24756624 1028 adventure-works\david0 109

Page 16: Exercícios Excel Módulo I

106 767955365 1034 adventure-works\mary0 6271 222969461 1036 adventure-works\john5 6119 72636981 1035 adventure-works\jill0 6203 243322160 1032 adventure-works\terry0 6

46 95958330 1033 adventure-works\sariya0 644 685233686 1232 adventure-works\ascott0 14828 749389530 1258 adventure-works\ashvini0 150

188 672243793 1257 adventure-works\peter1 150150 858323870 1256 adventure-works\stephanie0 42268 502097814 1011 adventure-works\stephen0 273288 481044938 1012 adventure-works\syed0 273

21 277173473 1231 adventure-works\peter0 14825 360868122 1054 adventure-works\zheng0 2164 7201901 1055 adventure-works\cristian0 21

185 33237992 1053 adventure-works\andrew0 21143 319472946 1229 adventure-works\yuhong0 21182 862951447 1230 adventure-works\katie0 21108 45615666 1228 adventure-works\eric0 21135 386315192 1057 adventure-works\cynthia0 21184 60114406 1056 adventure-works\jack0 21173 578935259 1058 adventure-works\michael3 21210 634335025 1059 adventure-works\brenda0 21

87 750905084 1061 adventure-works\david4 2151 370989364 1060 adventure-works\reuben0 21

123 712885347 1062 adventure-works\jeff0 21197 332349500 1064 adventure-works\lori0 21159 551834634 1063 adventure-works\shane0 21

14 233069302 1067 adventure-works\taylor0 2174 778552911 1066 adventure-works\kok-ho0 2138 630184120 1065 adventure-works\jinghao0 21

7 309738752 1070 adventure-works\jolynn0 2118 494170342 1069 adventure-works\john0 2116 446466105 1068 adventure-works\jo0 2110 912265825 1076 adventure-works\barry0 18519 9659517 1075 adventure-works\diane0 18517 565090917 1074 adventure-works\doris0 185

8 690627818 1071 adventure-works\ruth0 18515 132674823 1073 adventure-works\jeffrey0 18513 844973625 1072 adventure-works\sidney0 185

224 294148271 1087 adventure-works\betsy0 64252 82638150 1085 adventure-works\danielle0 64245 90888098 1084 adventure-works\patrick0 64230 109272464 1077 adventure-works\bonnie0 185234 390124815 1083 adventure-works\kimberly0 64227 717889520 1082 adventure-works\mary1 25228 801365500 1078 adventure-works\kevin2 25220 455563743 1081 adventure-works\ebru0 25256 561196580 1080 adventure-works\john4 25248 393421437 1079 adventure-works\christopher0 25262 826454897 1086 adventure-works\tom0 64237 339233463 1093 adventure-works\prasanna0 108

65 97728960 1098 adventure-works\raymond0 143258 163347032 1091 adventure-works\olinda0 108221 701156975 1092 adventure-works\sylvester0 108

Page 17: Exercícios Excel Módulo I

250 56772045 1090 adventure-works\krishna0 108232 113393530 1088 adventure-works\hung-fu0 108189 63761469 1096 adventure-works\anibal0 108239 872923042 1089 adventure-works\min0 108100 322160340 1099 adventure-works\lane0 143

55 568596888 1103 adventure-works\hanying0 143199 621932914 1107 adventure-works\stefen0 182147 812797414 1100 adventure-works\linda1 143125 969985265 1105 adventure-works\barbara0 182

26 964089218 1097 adventure-works\ivo0 10839 545337468 1108 adventure-works\michael0 182

177 404159499 1101 adventure-works\terrence0 143160 305522471 1106 adventure-works\john2 182

78 368920189 1109 adventure-works\nitin0 182214 300946911 1102 adventure-works\shelley0 143151 25011600 1095 adventure-works\samantha0 108

92 212801092 1104 adventure-works\fadi0 143115 886023130 1094 adventure-works\paul1 108209 587567941 1118 adventure-works\jan0 184

73 604664374 1125 adventure-works\sandra0 13562 476115505 1114 adventure-works\george0 18420 443968955 1129 adventure-works\steven0 173

180 993310268 1128 adventure-works\rostislav0 13524 498138869 1113 adventure-works\david1 18486 746373306 1120 adventure-works\david3 184

183 551346974 1112 adventure-works\russell1 184204 568626529 1115 adventure-works\john3 184133 363996959 1132 adventure-works\michiko0 173196 878395493 1123 adventure-works\michael5 135

50 351069889 1119 adventure-works\susan1 184205 301435199 1134 adventure-works\merav0 173

33 160739235 1124 adventure-works\jianshuo0 13561 138280935 1130 adventure-works\carole0 173

142 764853868 1127 adventure-works\andy0 13532 271438431 1122 adventure-works\garrett0 184

171 860123571 1117 adventure-works\david7 184134 585408256 1116 adventure-works\benjamin0 184113 364818297 1110 adventure-works\marc0 184124 87268837 1121 adventure-works\eugene0 184167 227319668 1133 adventure-works\carol0 173110 733022683 1126 adventure-works\jason0 135146 259388196 1111 adventure-works\reed0 184

97 420023788 1131 adventure-works\bjorn0 173246 947029962 1154 adventure-works\frank3 51240 697712387 1148 adventure-works\eric1 51236 943170460 1153 adventure-works\sandeep0 51222 1662732 1151 adventure-works\brian2 51229 413787783 1152 adventure-works\mihail0 51

93 769680433 1147 adventure-works\ryan0 51168 578953538 1159 adventure-works\rob1 87257 58791499 1150 adventure-works\jack1 51249 988315686 1149 adventure-works\patrick1 51138 746201340 1143 adventure-works\brian0 210

81 632092621 1136 adventure-works\rajesh0 210

Page 18: Exercícios Excel Módulo I

68 370487086 1141 adventure-works\shammi0 21027 384162788 1156 adventure-works\paul0 87

190 693168613 1139 adventure-works\ken1 21056 918737118 1146 adventure-works\kevin1 210

186 1300049 1155 adventure-works\nicole0 87105 992874797 1142 adventure-works\paula1 210116 749211824 1144 adventure-works\frank0 210215 440379437 1145 adventure-works\gabe0 210

63 502058701 1157 adventure-works\gary0 8791 19312190 1137 adventure-works\lorraine0 21031 761597760 1140 adventure-works\alejandro0 21045 295971920 1135 adventure-works\fred0 210

152 436757988 1138 adventure-works\tawana0 210172 273260055 1160 adventure-works\baris0 87

99 830150469 1158 adventure-works\michael1 8722 835460180 1172 adventure-works\stuart0 197

181 20244403 1171 adventure-works\belinda0 19723 687685941 1173 adventure-works\greg0 197

112 187369436 1169 adventure-works\janeth0 15988 514829225 1163 adventure-works\laura0 12352 275962311 1162 adventure-works\kirk0 123

144 456839592 1170 adventure-works\robert0 15975 435234965 1168 adventure-works\douglas0 15998 199546871 1174 adventure-works\scott0 197

193 399658727 1166 adventure-works\lionel0 159211 65848458 1161 adventure-works\andrew1 123126 539490372 1164 adventure-works\chris0 123

40 713403643 1167 adventure-works\yvonne0 159155 377784364 1165 adventure-works\alex0 123136 167554340 1175 adventure-works\kathie0 197169 222400012 1176 adventure-works\don0 38187 10708100 1198 adventure-works\frank1 14131 153288994 1191 adventure-works\houman0 74

43 718299860 1194 adventure-works\russell0 74104 204035155 1195 adventure-works\lolan0 74141 398737566 1186 adventure-works\michael2 38101 827686041 1201 adventure-works\pete0 14

36 113695504 1183 adventure-works\alice0 3858 415823523 1181 adventure-works\suroor0 38

107 342607223 1185 adventure-works\mindaugas0 3883 981597097 1179 adventure-works\john1 38

165 152085091 1192 adventure-works\sameer0 7495 431859843 1190 adventure-works\nuan0 7448 857651804 1178 adventure-works\jun0 3867 843479922 1200 adventure-works\bob0 14

163 370581729 1188 adventure-works\mandar0 7429 571658797 1199 adventure-works\kendall0 1460 674171828 1189 adventure-works\jim0 74

207 211789056 1177 adventure-works\kitti0 3869 54759846 1184 adventure-works\linda0 38

153 652535724 1197 adventure-works\denise0 14192 334834274 1182 adventure-works\michael4 38118 92096924 1196 adventure-works\diane2 14202 912141525 1193 adventure-works\elizabeth0 74

Page 19: Exercícios Excel Módulo I

179 599942664 1187 adventure-works\chad0 38120 563680513 1180 adventure-works\angela0 38243 414476027 1218 adventure-works\maciej0 18235 6298838 1212 adventure-works\kim1 16226 834186596 1216 adventure-works\karan0 18255 8066363 1217 adventure-works\randy0 18219 537092325 1215 adventure-works\charles0 18247 461786517 1213 adventure-works\ed0 16122 458159238 1223 adventure-works\bryan0 7254 582347317 1214 adventure-works\michael7 18156 66073987 1224 adventure-works\eugene1 7208 63179277 1220 adventure-works\jay0 18

57 801758002 1205 adventure-works\annik0 16157 999440576 1210 adventure-works\brandon0 16

80 330211482 1211 adventure-works\rebecca0 16129 948320468 1207 adventure-works\mark1 16

1 14417807 1209 adventure-works\guy1 1676 339712426 1227 adventure-works\james0 7

162 788456780 1208 adventure-works\jose0 1653 36151748 1221 adventure-works\david2 18

194 500412746 1225 adventure-works\thomas0 789 750246141 1206 adventure-works\margie0 16

213 442121106 1204 adventure-works\chris2 16175 754372876 1203 adventure-works\suchitra0 16

84 693325305 1222 adventure-works\nancy0 7137 410742000 1202 adventure-works\britta0 16

37 276751903 1226 adventure-works\simon0 7174 752513276 1219 adventure-works\steve0 18266 280633567 1039 adventure-works\reinout0 274264 437296311 1038 adventure-works\annette0 274274 895209680 1037 adventure-works\sheela0 71200 398223854 1268 adventure-works\hazem0 148

41 885055826 1269 adventure-works\peng0 200253 343861179 1273 adventure-works\sootha0 41

77 403414852 1270 adventure-works\sean0 41111 381772114 1271 adventure-works\mark0 41145 131471224 1272 adventure-works\andreas0 41

47 332040978 1237 adventure-works\willis0 3082 264306399 1238 adventure-works\vidur0 30

114 658797903 1051 adventure-works\gigi0 15879 811994146 1050 adventure-works\diane1 158

217 879342154 1289 adventure-works\michael6 158158 134969118 1049 adventure-works\dylan0 3277 615389812 1016 adventure-works\jillian0 268282 399771412 1020 adventure-works\josé1 268281 139397894 1017 adventure-works\shu0 268285 668991357 1025 adventure-works\jae0 284275 841560125 1026 adventure-works\michael9 268290 758596752 1024 adventure-works\lynn0 288279 716374314 1019 adventure-works\tsvi0 268283 987554265 1015 adventure-works\david8 268280 61161660 1014 adventure-works\pamela0 268278 234474252 1021 adventure-works\garrett1 268289 954276278 1023 adventure-works\rachel0 284

Page 20: Exercícios Excel Módulo I

286 134219713 1022 adventure-works\ranjit0 284287 90836195 1027 adventure-works\tete0 268276 191644724 1018 adventure-works\linda3 268

96 621209647 1233 adventure-works\william0 44170 470689086 1235 adventure-works\alan0 44206 368691270 1236 adventure-works\brian1 44132 981495526 1234 adventure-works\sairaj0 44267 42487730 1003 adventure-works\michael8 3

4 112457891 1290 adventure-works\rob0 3263 974026903 1007 adventure-works\ovidiu0 3121 584205124 1282 adventure-works\matthias0 85

35 337752649 1283 adventure-works\vamsi0 8585 521265716 1281 adventure-works\pilar0 2134 586486572 1285 adventure-works\susan0 8572 420776180 1286 adventure-works\kim0 85

195 652779496 1284 adventure-works\jimmy0 855 480168528 1009 adventure-works\thierry0 263

265 486228782 1008 adventure-works\janice0 26312 245797967 1001 adventure-works\terri0 109

148 519899904 1052 adventure-works\james1 109273 112432117 1010 adventure-works\brian3 109

Page 21: Exercícios Excel Módulo I

Title BirthDate MaritalStatus Gender HireDateAccountant 2/4/1966 M F 3/22/1999Accountant 8/1/1969 S M 4/9/1999Accounts Manager 8/8/1973 M M 3/3/1999Accounts Payable Specialist 3/18/1967 M M 3/15/1999Accounts Payable Specialist 4/9/1969 M F 4/2/1999Accounts Receivable Specialist 3/26/1966 S F 2/7/1999Accounts Receivable Specialist 4/7/1966 M F 1/19/1999Accounts Receivable Specialist 10/22/1974 S M 2/25/1999Application Specialist 6/19/1968 S F 3/20/1999Application Specialist 7/28/1971 M M 2/12/1999Application Specialist 3/3/1975 M F 1/24/1999Application Specialist 4/14/1978 S M 3/7/1999Assistant to the Chief Financial Officer 7/23/1954 S M 2/13/1999Benefits Specialist 12/22/1974 M F 1/26/1999Buyer 6/13/1942 M M 2/24/2000Buyer 12/30/1956 M M 2/12/2000Buyer 12/25/1960 M M 2/5/2000Buyer 12/31/1960 M F 1/18/2000Buyer 2/4/1961 S F 3/3/2000Buyer 10/19/1962 S M 2/28/2000Buyer 7/5/1963 M M 4/9/2000Buyer 9/21/1964 M M 4/1/1999Buyer 9/18/1974 S M 3/14/1999Chief Executive Officer 3/2/1959 S M 2/15/1999Chief Financial Officer 2/6/1966 M F 3/4/1999Control Specialist 6/26/1977 M M 4/7/1999Control Specialist 5/29/1980 S M 1/17/1999Database Administrator 6/17/1965 S M 2/18/1999Database Administrator 2/6/1966 M M 2/23/1999Design Engineer 10/29/1942 M F 2/6/1998Design Engineer 4/11/1949 M M 2/24/1998Design Engineer 6/3/1951 M F 2/18/2001Document Control Assistant 1/25/1966 M F 3/13/1999Document Control Assistant 4/12/1977 S M 2/23/1999Document Control Manager 3/2/1966 M M 2/5/1999Engineering Manager 12/13/1964 M M 12/12/1997European Sales Manager 10/22/1947 M F 5/18/2002Facilities Administrative Assistant 9/27/1961 M M 1/22/2000Facilities Manager 3/21/1961 M M 1/3/2000Finance Manager 11/12/1974 S F 1/26/1999Human Resources Administrative Assistant 5/18/1966 S M 3/29/1999Human Resources Administrative Assistant 5/19/1967 S M 3/10/1999Human Resources Manager 3/14/1966 M F 1/7/1999Information Services Manager 1/13/1966 S F 1/12/1999Janitor 5/25/1944 M F 4/7/2000Janitor 8/31/1960 M F 3/19/2000Janitor 1/3/1961 S M 2/28/2000Janitor 1/17/1962 M M 4/5/2000Maintenance Supervisor 2/18/1966 M M 1/15/1999Marketing Assistant 4/17/1965 M F 2/7/2001Marketing Assistant 3/1/1968 S F 3/17/2001Marketing Assistant 6/3/1977 S M 2/26/1997Marketing Manager 4/19/1965 S M 1/20/1998

Page 22: Exercícios Excel Módulo I

Marketing Specialist 10/14/1952 M F 2/13/1999Marketing Specialist 4/6/1968 S M 3/10/2001Marketing Specialist 7/19/1969 M F 2/19/1999Marketing Specialist 3/7/1976 M M 4/3/1999Marketing Specialist 6/21/1977 S M 1/13/1999Master Scheduler 10/19/1958 S M 1/13/1999Network Administrator 4/28/1967 S M 1/5/1999Network Administrator 6/29/1970 S M 3/27/1999Network Manager 4/26/1974 S F 3/8/1999North American Sales Manager 11/17/1941 M M 2/4/2001Pacific Sales Manager 2/11/1965 M M 4/15/2003Production Control Manager 12/4/1972 M M 1/2/1999Production Supervisor - WC10 11/26/1973 S M 1/4/1999Production Supervisor - WC10 5/13/1974 M M 1/23/1999Production Supervisor - WC10 10/8/1978 S M 3/26/1999Production Supervisor - WC20 5/8/1967 M M 3/5/1999Production Supervisor - WC20 12/20/1974 S F 3/24/1999Production Supervisor - WC20 2/20/1975 M M 2/15/1999Production Supervisor - WC30 9/19/1971 S F 2/28/1999Production Supervisor - WC30 7/23/1973 S M 3/25/1999Production Supervisor - WC30 3/2/1979 S M 3/19/1999Production Supervisor - WC40 3/31/1973 M F 4/6/1999Production Supervisor - WC40 8/2/1973 S M 2/4/1999Production Supervisor - WC40 9/27/1977 M M 1/16/1999Production Supervisor - WC45 2/16/1967 M M 2/22/1999Production Supervisor - WC45 8/19/1970 S F 3/30/1999Production Supervisor - WC45 6/24/1980 S M 3/12/1999Production Supervisor - WC50 5/3/1946 M M 3/11/1998Production Supervisor - WC50 5/30/1970 S M 1/28/1999Production Supervisor - WC50 3/9/1979 S M 1/9/1999Production Supervisor - WC60 2/16/1946 S F 1/26/1998Production Supervisor - WC60 9/8/1946 M M 4/18/1998Production Supervisor - WC60 11/9/1946 S F 3/30/1998Production Technician - WC10 4/27/1946 S M 2/7/1998Production Technician - WC10 4/30/1946 M F 4/29/1998Production Technician - WC10 5/6/1946 M F 4/11/1998Production Technician - WC10 7/6/1946 M F 2/6/1998Production Technician - WC10 8/12/1946 S M 3/23/1998Production Technician - WC10 10/1/1946 M M 3/5/1998Production Technician - WC10 1/17/1957 S F 1/19/2000Production Technician - WC10 10/8/1976 S F 3/23/2000Production Technician - WC10 10/11/1976 S M 3/4/2000Production Technician - WC10 10/11/1976 M F 2/2/2000Production Technician - WC10 10/14/1976 S F 2/13/2000Production Technician - WC10 10/20/1976 M F 1/26/2000Production Technician - WC10 10/20/1976 S M 1/26/2000Production Technician - WC10 10/23/1976 S M 1/7/2000Production Technician - WC10 10/29/1976 S M 3/30/2000Production Technician - WC10 11/1/1976 M M 3/11/2000Production Technician - WC10 11/1/1976 M M 4/10/2000Production Technician - WC20 6/1/1943 M M 2/23/2000Production Technician - WC20 4/2/1957 M M 1/24/1999Production Technician - WC20 5/5/1960 S F 4/4/2000Production Technician - WC20 12/13/1960 M M 1/12/2000

Page 23: Exercícios Excel Módulo I

Production Technician - WC20 10/6/1961 S M 3/16/2000Production Technician - WC20 11/23/1961 S M 2/7/2000Production Technician - WC20 10/6/1964 S F 3/27/1999Production Technician - WC20 10/11/1964 M M 2/25/2000Production Technician - WC20 10/24/1964 M M 2/12/1999Production Technician - WC20 11/16/1964 S M 1/17/1999Production Technician - WC20 1/21/1966 S M 4/1/1999Production Technician - WC20 11/6/1967 S F 3/7/1999Production Technician - WC20 8/2/1969 M F 2/23/1999Production Technician - WC20 2/4/1972 M M 1/5/1999Production Technician - WC20 12/19/1974 S M 1/10/1999Production Technician - WC20 1/9/1975 S M 3/20/1999Production Technician - WC20 5/6/1976 M M 3/13/1999Production Technician - WC20 1/1/1977 S M 1/29/1999Production Technician - WC20 1/8/1977 S F 4/8/1999Production Technician - WC20 12/23/1977 M F 3/8/1999Production Technician - WC20 3/19/1979 S M 2/5/1999Production Technician - WC20 12/5/1980 M M 2/18/1999Production Technician - WC30 12/16/1964 S M 4/6/1999Production Technician - WC30 12/6/1965 M F 1/27/1999Production Technician - WC30 5/18/1967 M M 1/22/1999Production Technician - WC30 6/15/1967 M M 1/2/1999Production Technician - WC30 10/15/1967 M M 3/23/1999Production Technician - WC30 12/3/1969 S M 1/3/1999Production Technician - WC30 9/4/1971 S M 2/3/1999Production Technician - WC30 3/14/1972 M M 3/25/1999Production Technician - WC30 4/24/1972 S M 4/4/1999Production Technician - WC30 7/28/1972 S M 2/27/1999Production Technician - WC30 10/19/1972 M M 3/30/1999Production Technician - WC30 5/3/1973 S F 1/15/1999Production Technician - WC30 6/13/1973 M F 4/4/1999Production Technician - WC30 8/27/1973 S M 1/8/1999Production Technician - WC30 11/19/1973 M F 1/20/1999Production Technician - WC30 11/20/1973 M M 3/4/1999Production Technician - WC30 9/26/1974 S M 1/8/1999Production Technician - WC30 10/25/1975 M M 3/18/1999Production Technician - WC30 2/6/1976 S M 2/28/1999Production Technician - WC30 11/24/1976 M M 2/17/1999Production Technician - WC30 8/15/1977 S M 2/22/1999Production Technician - WC30 11/18/1978 M F 3/16/1999Production Technician - WC30 1/8/1979 S M 2/15/1999Production Technician - WC30 2/9/1979 M M 3/6/1999Production Technician - WC30 12/8/1979 S M 2/8/1999Production Technician - WC40 4/3/1942 M M 3/8/2000Production Technician - WC40 1/8/1957 M M 2/25/2000Production Technician - WC40 1/3/1961 S M 2/18/2000Production Technician - WC40 1/23/1961 S M 1/12/2000Production Technician - WC40 4/9/1961 S M 1/30/2000Production Technician - WC40 7/15/1962 M M 2/6/1999Production Technician - WC40 9/5/1963 S M 3/17/1999Production Technician - WC40 9/30/1963 S M 4/3/2000Production Technician - WC40 1/24/1964 M M 3/15/2000Production Technician - WC40 3/14/1967 S M 3/2/1999Production Technician - WC40 11/5/1967 M M 2/1/1999

Page 24: Exercícios Excel Módulo I

Production Technician - WC40 11/5/1970 M M 1/25/1999Production Technician - WC40 12/15/1970 S M 1/5/1999Production Technician - WC40 6/29/1971 M M 3/28/1999Production Technician - WC40 1/26/1976 S M 1/18/1999Production Technician - WC40 5/10/1976 M F 3/26/1999Production Technician - WC40 3/13/1977 M F 2/13/1999Production Technician - WC40 10/7/1977 M M 2/18/1999Production Technician - WC40 6/11/1978 M M 4/9/1999Production Technician - WC40 6/17/1978 S M 1/23/1999Production Technician - WC40 12/28/1978 M F 2/5/1999Production Technician - WC40 1/6/1979 S M 1/7/1999Production Technician - WC40 7/27/1979 S M 1/13/1999Production Technician - WC40 12/12/1979 S M 3/9/1999Production Technician - WC40 11/7/1980 S M 3/19/1999Production Technician - WC40 2/4/1981 S M 2/11/1999Production Technician - WC45 10/14/1952 S M 1/3/1999Production Technician - WC45 10/19/1959 S F 3/24/1999Production Technician - WC45 11/18/1960 S M 1/3/1999Production Technician - WC45 8/25/1962 S F 2/16/1999Production Technician - WC45 1/26/1971 S F 2/4/1999Production Technician - WC45 3/10/1975 S M 1/16/1999Production Technician - WC45 4/1/1975 S M 3/6/1999Production Technician - WC45 12/26/1975 M M 1/28/1999Production Technician - WC45 3/13/1977 M M 2/9/1999Production Technician - WC45 4/15/1978 S M 3/30/1999Production Technician - WC45 10/26/1978 S M 4/7/1999Production Technician - WC45 1/17/1979 M M 2/23/1999Production Technician - WC45 5/17/1979 M F 1/10/1999Production Technician - WC45 5/14/1980 M M 3/12/1999Production Technician - WC45 12/2/1980 M F 2/28/1999Production Technician - WC50 7/14/1961 M M 3/17/1999Production Technician - WC50 8/24/1961 S M 3/27/1999Production Technician - WC50 9/30/1961 M M 2/26/1999Production Technician - WC50 12/27/1962 M M 1/13/1999Production Technician - WC50 2/25/1963 M M 2/13/1999Production Technician - WC50 6/3/1964 S M 3/4/1999Production Technician - WC50 3/7/1967 S M 2/12/1999Production Technician - WC50 2/27/1968 M F 1/8/1999Production Technician - WC50 3/28/1968 S M 1/18/1999Production Technician - WC50 6/7/1968 M M 2/14/1999Production Technician - WC50 7/1/1968 S M 2/2/1999Production Technician - WC50 7/27/1968 M M 3/15/1999Production Technician - WC50 4/29/1969 S M 2/7/1999Production Technician - WC50 8/6/1969 S M 1/15/1999Production Technician - WC50 9/16/1969 S M 1/25/1999Production Technician - WC50 4/21/1976 S M 3/14/1999Production Technician - WC50 6/30/1976 M M 1/6/1999Production Technician - WC50 10/9/1976 M M 1/20/1999Production Technician - WC50 7/7/1977 S F 4/5/1999Production Technician - WC50 8/17/1977 M F 1/26/1999Production Technician - WC50 8/7/1978 M F 3/9/1999Production Technician - WC50 7/17/1979 S M 3/29/1999Production Technician - WC50 9/10/1979 S F 2/19/1999Production Technician - WC50 2/26/1980 M F 4/3/1999

Page 25: Exercícios Excel Módulo I

Production Technician - WC50 9/4/1980 M M 3/22/1999Production Technician - WC50 7/1/1981 S F 2/21/1999Production Technician - WC60 3/2/1945 S M 3/1/2000Production Technician - WC60 1/14/1957 M F 2/17/2000Production Technician - WC60 4/7/1960 S M 1/23/2000Production Technician - WC60 5/29/1960 M M 3/26/2000Production Technician - WC60 10/3/1961 S M 1/4/2000Production Technician - WC60 10/12/1961 S M 3/8/2000Production Technician - WC60 9/28/1963 S M 2/22/1999Production Technician - WC60 10/7/1963 S M 3/26/2000Production Technician - WC60 3/13/1966 S M 3/12/1999Production Technician - WC60 3/14/1966 S M 4/6/1999Production Technician - WC60 1/27/1967 M M 1/18/1999Production Technician - WC60 2/11/1967 M M 3/12/1999Production Technician - WC60 8/11/1967 M F 1/30/1999Production Technician - WC60 10/26/1969 S M 2/24/1999Production Technician - WC60 5/15/1972 M M 7/31/1996Production Technician - WC60 8/26/1974 M M 1/28/1999Production Technician - WC60 9/1/1974 M M 3/14/1999Production Technician - WC60 1/30/1975 M M 1/16/1999Production Technician - WC60 2/11/1976 M M 3/30/1999Production Technician - WC60 6/20/1976 M F 2/5/1999Production Technician - WC60 9/7/1976 S M 4/8/1999Production Technician - WC60 7/11/1977 M F 3/20/1999Production Technician - WC60 12/21/1978 M F 2/3/1999Production Technician - WC60 10/30/1979 M F 3/2/1999Production Technician - WC60 6/17/1980 S M 1/9/1999Production Technician - WC60 5/7/1981 S M 3/19/1999Purchasing Assistant 2/18/1968 M M 1/25/2001Purchasing Assistant 3/1/1968 M F 1/6/2001Purchasing Manager 3/13/1968 S F 3/28/2001Quality Assurance Manager 11/27/1967 S M 4/1/1999Quality Assurance Supervisor 4/19/1966 M M 1/10/1999Quality Assurance Technician 1/5/1957 M M 3/26/2000Quality Assurance Technician 4/7/1966 S M 1/29/1999Quality Assurance Technician 5/31/1976 S M 2/16/1999Quality Assurance Technician 4/29/1979 M M 3/6/1999Recruiter 8/18/1968 S M 1/14/1999Recruiter 9/2/1974 S M 2/2/1999Research and Development Engineer 2/21/1969 M F 2/17/1999Research and Development Engineer 7/6/1976 S F 1/30/1999Research and Development Manager 1/1/1975 M M 6/4/1999Research and Development Manager 3/27/1977 M M 3/12/1999Sales Representative 9/29/1952 S F 7/1/2001Sales Representative 1/11/1954 M M 7/1/2001Sales Representative 4/10/1958 M M 7/1/2001Sales Representative 4/18/1958 M F 7/1/2002Sales Representative 1/26/1959 S M 7/1/2001Sales Representative 4/18/1961 S F 7/1/2003Sales Representative 2/19/1964 M M 7/1/2001Sales Representative 3/14/1964 S M 7/1/2001Sales Representative 1/6/1965 S F 7/1/2001Sales Representative 3/7/1965 M M 7/1/2001Sales Representative 8/9/1965 S F 7/1/2003

Page 26: Exercícios Excel Módulo I

Sales Representative 10/31/1965 S M 7/1/2002Sales Representative 2/6/1968 M M 11/1/2002Sales Representative 3/30/1970 M F 7/1/2001Scheduling Assistant 12/8/1971 M M 2/8/1999Scheduling Assistant 4/30/1974 M M 3/17/1999Scheduling Assistant 9/12/1974 M M 4/4/1999Scheduling Assistant 1/22/1978 M M 2/27/1999Senior Design Engineer 7/17/1969 S M 1/30/2001Senior Tool Designer 1/23/1965 S M 1/5/1998Senior Tool Designer 2/18/1968 S M 1/5/2001Shipping and Receiving Clerk 12/13/1963 M M 2/21/1999Shipping and Receiving Clerk 4/19/1967 M M 1/8/1999Shipping and Receiving Supervisor 10/11/1962 S M 2/3/1999Stocker 3/20/1968 S F 1/8/1999Stocker 6/1/1974 S F 1/27/1999Stocker 6/5/1975 M M 3/30/1999Tool Designer 8/29/1949 M M 1/11/1998Tool Designer 6/29/1979 M F 1/23/2001Vice President of Engineering 9/1/1961 S F 3/3/1998Vice President of Production 2/7/1973 S M 3/7/1999Vice President of Sales 7/8/1967 S M 3/18/2001

Page 27: Exercícios Excel Módulo I

SalariedFlag VacationHours SickLeaveHours CurrentFlag-1 58 49 -1-1 59 49 -1-1 57 48 -10 63 51 -10 64 52 -10 61 50 -10 60 50 -10 62 51 -1

-1 74 57 -1-1 72 56 -1-1 71 55 -1-1 73 56 -10 56 48 -10 51 45 -10 58 49 -10 52 46 -10 57 48 -10 56 48 -10 53 46 -10 54 47 -10 55 47 -10 60 50 -10 59 49 -1

-1 99 69 -1-1 0 20 -10 75 57 -10 76 58 -1

-1 67 53 -1-1 66 53 -1-1 5 22 -1-1 6 23 -1-1 4 22 -10 79 59 -10 78 59 -10 77 58 -1

-1 2 21 -1-1 21 30 -10 87 63 -1

-1 86 63 -1-1 55 47 -10 53 46 -10 52 46 -1

-1 54 47 -1-1 65 52 -10 91 65 -10 90 65 -10 89 64 -10 88 64 -1

-1 92 66 -10 41 40 -10 43 41 -10 42 41 -1

-1 40 40 -1

Page 28: Exercícios Excel Módulo I

0 46 43 -10 48 44 -10 47 43 -10 44 42 -10 45 42 -10 44 42 -10 70 55 -10 69 54 -1

-1 68 54 -1-1 14 27 -1-1 20 30 -1-1 43 41 -10 66 53 -10 67 53 -10 65 52 -10 41 40 -10 42 41 -10 40 40 -10 69 54 -10 68 54 -10 70 55 -10 71 55 -10 73 56 -10 72 56 -10 74 57 -10 76 58 -10 75 57 -10 79 59 -10 78 59 -10 77 58 -10 82 61 -10 81 60 -10 80 60 -10 88 64 -10 87 63 -10 86 63 -10 83 61 -10 85 62 -10 84 62 -10 99 69 -10 97 68 -10 96 68 -10 89 64 -10 95 67 -10 94 67 -10 90 65 -10 93 66 -10 92 66 -10 91 65 -10 98 69 -10 5 22 -10 10 25 -10 3 21 -10 4 22 -1

Page 29: Exercícios Excel Módulo I

0 2 21 -10 0 20 -10 8 24 -10 1 20 -10 11 25 -10 15 27 -10 19 29 -10 12 26 -10 17 28 -10 9 24 -10 20 30 -10 13 26 -10 18 29 -10 21 30 -10 14 27 -10 7 23 -10 16 28 -10 6 23 -10 30 35 -10 37 38 -10 26 33 -10 41 40 -10 40 40 -10 25 32 -10 32 36 -10 24 32 -10 27 33 -10 44 42 -10 35 37 -10 31 35 -10 46 43 -10 36 38 -10 42 41 -10 39 39 -10 34 37 -10 29 34 -10 28 34 -10 22 31 -10 33 36 -10 45 42 -10 38 39 -10 23 31 -10 43 41 -10 66 53 -10 60 50 -10 65 52 -10 63 51 -10 64 52 -10 59 49 -10 71 55 -10 62 51 -10 61 50 -10 55 47 -10 48 44 -1

Page 30: Exercícios Excel Módulo I

0 53 46 -10 68 54 -10 51 45 -10 58 49 -10 67 53 -10 54 47 -10 56 48 -10 57 48 -10 69 54 -10 49 44 -10 52 46 -10 47 43 -10 50 45 -10 72 56 -10 70 55 -10 84 62 -10 83 61 -10 85 62 -10 81 60 -10 75 57 -10 74 57 -10 82 61 -10 80 60 -10 86 63 -10 78 59 -10 73 56 -10 76 58 -10 79 59 -10 77 58 -10 87 63 -10 88 64 -10 10 25 -10 3 21 -10 6 23 -10 7 23 -10 98 69 -10 13 26 -10 95 67 -10 93 66 -10 97 68 -10 91 65 -10 4 22 -10 2 21 -10 90 65 -10 12 26 -10 0 20 -10 11 25 -10 1 20 -10 89 64 -10 96 68 -10 9 24 -10 94 67 -10 8 24 -10 5 22 -1

Page 31: Exercícios Excel Módulo I

0 99 69 -10 92 66 -10 30 35 -10 24 32 -10 28 34 -10 29 34 -10 27 33 -10 25 32 -10 35 37 -10 26 33 -10 36 38 -10 32 36 -10 17 28 -10 22 31 -10 23 31 -10 19 29 -10 21 30 -10 39 39 -10 20 30 -10 33 36 -10 37 38 -10 18 29 -10 16 28 -10 15 27 -10 34 37 -10 14 27 -10 38 39 -10 31 35 -10 51 45 -10 50 45 -1

-1 49 44 -1-1 80 60 -1-1 81 60 -10 85 62 -10 82 61 -10 83 61 -10 84 62 -10 49 44 -10 50 45 -1

-1 63 51 -1-1 62 51 -1-1 16 64 -1-1 61 50 -1-1 24 32 -1-1 31 35 -1-1 26 33 -1-1 37 38 -1-1 38 39 -1-1 36 38 -1-1 29 34 -1-1 23 31 -1-1 22 31 -1-1 33 36 -1-1 35 37 -1

Page 32: Exercícios Excel Módulo I

-1 34 37 -1-1 39 39 -1-1 27 33 -10 45 42 -10 47 43 -10 48 44 -10 46 43 -1

-1 3 21 -10 48 80 -10 7 23 -10 94 67 -10 95 67 -1

-1 93 66 -10 97 68 -10 98 69 -10 96 68 -10 9 24 -10 8 24 -1

-1 1 20 -1-1 64 52 -1-1 10 25 -1

Page 33: Exercícios Excel Módulo I

rowguid ModifiedDate{3FFBA84E-8E97-4649-A5E1-859649D83AAE} 7/31/2004{AC35337D-7C75-4DEE-BB11-6564F257FE18} 7/31/2004{2DC9D534-F5D1-4A14-8282-0A2A0EB6FD4D} 7/31/2004{51C54D34-064B-44F7-A6B1-7702BD491980} 7/31/2004{0C641D77-8675-493F-9947-8C65136559CD} 7/31/2004{9E9F713B-707C-4F7E-9504-DE188052A045} 7/31/2004{09F75454-028C-46CA-BC08-0147BD0220D7} 7/31/2004{CB3E71EC-A381-4716-87DF-D3841AB9795A} 7/31/2004{45C3D0F5-3332-419D-AD40-A98996BB5531} 7/31/2004{71B0D010-5AC5-4E91-8EFA-C311C1372A73} 7/31/2004{241535C7-7A31-4A6A-9E0D-A83C30C2EDDA} 7/31/2004{BE190269-4003-4D7F-809E-7B3FDC235DA8} 7/31/2004{BE81FD77-428C-449F-AB79-48B1CDF53D6A} 7/31/2004{834D7AB6-06E6-4944-B42F-028CD4BD388E} 7/31/2004{0423D8D0-1B14-4718-8C17-85E2F98D222F} 7/31/2004{2CB2D5C3-C437-49B1-9FFD-FAA096F6126F} 7/31/2004{36CD6636-C657-4FC7-9BFA-CC1BFA9102A2} 7/31/2004{ED06F9F4-2123-4C44-89D7-E43E1E1ABC2F} 7/31/2004{B60712A9-50A5-4296-B892-69C4701834B0} 7/31/2004{A28AB377-06F5-417A-A5E2-59F459088699} 7/31/2004{B9641CAE-765C-4662-B760-C167A1F2B8B5} 7/31/2004{51DE26F0-6ED9-4A70-B689-88EB882674B6} 7/31/2004{D0FD55FF-42FA-491E-8B3B-AB3316018909} 7/31/2004{F01251E5-96A3-448D-981E-0F99D789110D} 7/31/2004{D5E315A6-BD65-4D67-9D5F-81EF5C4EF8A6} 7/31/2004{45C358FB-9C7F-4D36-8EC7-3D89E9FD07F4} 7/31/2004{C609B3B2-7969-410C-934C-62C34B63C4EE} 7/31/2004{0C7F025D-8D56-48EF-86C0-F09DB63D0182} 7/31/2004{2474E1A9-902D-466C-B0B2-6DCAC927F753} 7/31/2004{EC84AE09-F9B8-4A15-B4A9-6CCBAB919B08} 7/31/2004{E39056F1-9CD5-478D-8945-14ACA7FBDCDD} 7/31/2004{54F2FDC0-87C4-4065-A7A8-9AC8EA624235} 7/31/2004{8A41ED23-7AE2-4C15-AA5D-9496E721F848} 7/31/2004{F78657A9-83EF-4B4D-9809-3C4C6D1A7BB4} 7/31/2004{DC60EEED-9F9F-4435-8666-4DE4FAFDE9C3} 7/31/2004{9BBBFB2C-EFBB-4217-9AB7-F97689328841} 7/31/2004{66D66445-EE78-4676-9E66-0E22D6109A92} 7/31/2004{0A4BCC09-ACE5-4481-9067-8B9ED70ECA18} 7/31/2004{62F6EC59-5635-44F3-9CC1-2D8EEAF90A05} 7/31/2004{8F410408-4AA8-4D67-886D-530BFE4EBE3B} 7/31/2004{4511ABBA-7F34-400E-907B-A663C20E1A41} 7/31/2004{FD53C4C8-B34E-460F-9EE5-747B07FE98B3} 7/31/2004{65028F15-4149-4DE5-B203-9D7EC86BAF87} 7/31/2004{794A0B1F-C46A-401C-984D-008996FC7092} 7/31/2004{39AF5CCA-9B52-41E5-B510-72901D2578F6} 7/31/2004{929FE187-EE24-4F5F-AF2A-F96324F09423} 7/31/2004{49238447-30EE-4009-993F-0B6C756AB436} 7/31/2004{CC2791E6-7629-49C5-922A-81445AFDF033} 7/31/2004{4611C7C5-90A0-407F-B054-93BD51533609} 7/31/2004{43CCA446-DA1C-454C-8530-873AD2923E1B} 7/31/2004{1F6DA901-C7F7-48A8-8EEF-D81868D72B52} 7/31/2004{1B480240-95C0-410F-A717-EB29943C8886} 7/31/2004{E87029AA-2CBA-4C03-B948-D83AF0313E28} 7/31/2004

Page 34: Exercícios Excel Módulo I

{90899830-127E-4876-85CA-7F6E03025281} 7/31/2004{64730415-1F58-4E5B-8FA8-5E4DAEBA53B4} 7/31/2004{53575C58-FBA1-4C1A-B8FF-95E050B44393} 7/31/2004{AD0D7626-4506-45C4-898F-9D7A0E13AABD} 7/31/2004{AF21F1B7-0691-48AD-B325-B8F2D7B2268A} 7/31/2004{13909262-4136-492F-BCA3-0B0E3773B03E} 1/26/2005{2E680C1C-7C02-4343-9626-6F97273414C0} 7/31/2004{86601E6A-6955-40FC-BB4A-1053A843CE99} 7/31/2004{221CBB7B-8BAE-452B-A16F-A67EBB3873C8} 7/31/2004{86D5FA9E-4BC0-48C8-91DC-1EC467418D11} 7/31/2004{86F292DB-B73C-429D-9912-800994D809FB} 7/31/2004{69D5D162-E817-45E7-9DEC-5D9B8310E7B1} 1/26/2005{C75F2740-ACE3-4EBF-91C5-7AB352E1095F} 7/31/2004{5BE16416-8570-417D-9E54-047DB468B5E9} 7/31/2004{08365B05-C143-4260-A93C-6B69418B1946} 7/31/2004{F1A684F4-02DB-4B22-8977-6D8D3A21100E} 7/31/2004{5BE8B211-CBE5-45D8-84FD-23F36A881473} 7/31/2004{2ABCF39B-88D7-49FA-820A-83D223322BA5} 7/31/2004{F9E1DC46-0D03-4A8A-B693-1A964BC13E6C} 7/31/2004{69A47230-70EE-48FD-AC15-C39F3712FF14} 7/31/2004{1AD772D7-7B4A-4A7B-8676-49DD7608CB94} 7/31/2004{714D519B-375E-4C5A-8491-C758D00CF95F} 7/31/2004{516538E8-115B-44F4-AA7B-E6C1D9F8ADFC} 7/31/2004{71EEE2A6-B9B3-4BF4-8949-01239DF7C901} 7/31/2004{7C7D459E-1F49-427D-9BD5-DE31880C85DC} 7/31/2004{23D436FC-08F7-4988-8B4D-490AA4E8B7E7} 7/31/2004{2625C358-672A-4000-AD67-B8CD3F318285} 7/31/2004{28F7EF89-2793-4989-B67D-25046543C1E3} 7/31/2004{57FB2C0F-B105-49F0-967A-88F3D743CB3F} 7/31/2004{2BCA07D3-F2AC-4406-904F-E09156F3EB3E} 7/31/2004{2CC71B96-F421-485E-9832-8723337749BB} 7/31/2004{D4ED1F78-7C28-479B-BFEF-A73228BA2AAA} 7/31/2004{83FFAAC6-B895-481F-B897-14F965D4DA47} 7/31/2004{756A60AE-378F-43D8-9F93-1E821D1EAF52} 7/31/2004{C334B2D2-0C56-4906-9095-F1D07A98CBEC} 7/31/2004{692B8826-03B4-4C3B-82FC-1FC6F1409689} 7/31/2004{3E3B6905-209E-442E-B8A8-9A0980241C6A} 7/31/2004{6E086F41-B81D-4BDC-9F13-0EEC488DC43E} 7/31/2004{40D603D9-7F99-48B7-A580-B17CF429BED2} 7/31/2004{EBCDBA1C-6C1D-4D36-90F7-1893755C85E3} 7/31/2004{BB886159-1400-4264-B7C9-A3769BEB1274} 7/31/2004{D5FBE9E6-B8C5-484C-B4B8-48059E0EF267} 7/31/2004{E950A52A-DF61-4FEC-9063-545664D65B89} 7/31/2004{CE256B6C-1EEE-43ED-9969-7CAC480FF4D7} 7/31/2004{6DC9F7D0-5664-4E4A-90F5-7AB85EBB02E6} 7/31/2004{8B21E53D-E705-479A-B32E-6E63AC2F4BCD} 7/31/2004{6C25A32B-88B5-4F84-A129-F7F688DFA588} 7/31/2004{D4CF23D9-21B6-45E4-827C-22890DF0373B} 7/31/2004{F71C6055-557B-4660-86FF-8C0FA14B24E6} 7/31/2004{B3BF7FC5-2014-48CE-B7BB-76124FA8446C} 7/31/2004{72ED240A-0FD8-4423-8A49-9078BA6BCF6C} 7/31/2004{9F01E1FB-B893-40CC-9F5C-AAF89F9B7AF5} 7/31/2004{6456CEC3-9B1E-4EBC-9FD8-732B93363F65} 7/31/2004{D9C43D08-3882-4E5C-BDF0-F6BD7004CD04} 7/31/2004

Page 35: Exercícios Excel Módulo I

{42A506A5-0AC0-4148-B702-BB7B804EF98C} 7/31/2004{065D8D5F-9504-4FFE-98DC-E69677F19F15} 7/31/2004{BC18A829-F0CE-4EAF-9785-2D84C86F925A} 7/31/2004{CC75C35D-1566-43FA-B2E9-D1E508EFDCD1} 7/31/2004{042427B8-3883-4A87-A6A3-724EE1690F49} 7/31/2004{618B71BC-6E8C-492D-8862-B9EFB7A4E06A} 7/31/2004{B9EEBF9F-F694-4BC2-98EC-9B4FB0379EDF} 7/31/2004{F963F913-449E-4EBB-BFDA-FC0C3010DB65} 7/31/2004{045C9CBB-3448-4599-9FA9-6C7A9F82F832} 7/31/2004{D83A26F3-7EA7-477B-A5BB-7EAADFC13A09} 7/31/2004{4FD6FE82-535A-4DD1-BEB1-154A8B5E42F0} 7/31/2004{4DA76442-5EEF-41FB-AE19-16C55714F9AD} 7/31/2004{BAB69951-28AD-4BCA-B5AC-032746D0CC6F} 7/31/2004{EBBC6787-3F2D-4F6B-9EA3-4DEF02EF382E} 7/31/2004{13942056-2930-4490-83CE-AF2386D5A5E7} 7/31/2004{1629EDDD-D0AE-4CB9-A59C-3A175F7027E5} 7/31/2004{9923376F-26D0-4845-9D99-CC3D696CAEB8} 7/31/2004{DC5BA622-B860-41EE-AF92-5FEB4779B589} 7/31/2004{975F827D-BE71-4EB1-8DBF-E6C451D1FAD5} 7/31/2004{F69F3FF9-E1E0-4419-A6BF-F705E1556160} 7/31/2004{01B119A2-2AF3-4775-818E-B421FECB07A7} 7/31/2004{0A8937C9-68AA-4D48-BA4E-B40493D764AA} 7/31/2004{00027A8C-C2F8-4A31-ABA8-8A203638B8F1} 7/31/2004{ED7EE92E-A9D0-4E3A-8DEE-4B143E459F7E} 7/31/2004{84C358D4-2493-452C-B7D6-B212C893A009} 7/31/2004{D54C7989-2675-4EF3-B392-370A8D264B2B} 7/31/2004{96C7EAB1-6DEA-4C59-AFD8-923F0E8DE1F6} 7/31/2004{F359F5B6-5E18-4C62-8531-14D951911CE5} 7/31/2004{2B0876D4-8996-4E71-A613-BE2E98E7ACCF} 7/31/2004{F73D75D5-B47B-46EE-AD11-7BF13DD6C55D} 7/31/2004{2EE7914A-62D3-473B-A0E1-E4E55341EC4E} 7/31/2004{6FFF136A-9664-4EB9-9243-FAC76E21B9DD} 7/31/2004{C76A41F1-A390-4AE4-A82A-2A87764C6391} 7/31/2004{615A6BFE-3046-4037-9764-238535F725BE} 7/31/2004{A6F5F72F-AA03-41B7-8B6E-B123BD360753} 7/31/2004{85AFB689-7EAB-41A8-B154-9446195D5BDE} 7/31/2004{F1A6F824-895B-4A0F-AF1B-05FBA703E69F} 7/31/2004{1F151ABC-DB4A-431A-8A5D-15F46C5B8FFC} 7/31/2004{1BA1D374-18AE-48ED-938F-6F5D2EEC4D4D} 7/31/2004{8D0182A3-5B59-4EEA-9B3C-C7F05DA9A2CE} 7/31/2004{C16C501D-942D-4EB0-B5C4-EF8119FBEBA2} 7/31/2004{B3967C00-7014-4960-AF15-B1A6D3094F6F} 7/31/2004{A942E1E0-2D5E-4858-97C0-947020E96860} 7/31/2004{9AF24ACC-EA3E-4EFE-B5E3-4762C496D57C} 7/31/2004{55F62E38-9457-46C8-A824-E46A3117A935} 7/31/2004{606C21E2-3EC0-48A6-A9FE-6BC8123AC786} 7/31/2004{C294F676-CAAF-4924-9730-BC81AE408BE1} 7/31/2004{03A9BA14-0D5B-4671-B851-2C1721EFBF01} 7/31/2004{10E5BD6F-2B9C-4192-A94D-6A2D50EA1ADB} 7/31/2004{54FDA597-6822-42B4-B128-63ECA03071F2} 7/31/2004{D308D387-F7F3-4B5F-ABDA-FAF5574245CD} 7/31/2004{296C52AE-169F-4292-975D-C508476DCECF} 7/31/2004{18D594A8-B4ED-43C0-9C43-6033FEAADF4E} 7/31/2004{ACA7B40C-7AC0-4DAA-B4C7-1051D850D7D9} 7/31/2004

Page 36: Exercícios Excel Módulo I

{9BEF0C94-7969-4905-9A42-CE469C754800} 7/31/2004{0217049E-1566-42B6-8027-41B751E2B00B} 7/31/2004{699C00D8-C4AB-4CD2-A48F-37CBCB5BFCCA} 7/31/2004{DC7E95FF-275E-41C2-8ED3-686864F0540A} 7/31/2004{15671E3B-016F-41FD-840B-5A9F7D776D9A} 7/31/2004{5DD2BE46-204F-4AF3-91F5-5EF082F6D6A6} 7/31/2004{DD9AD278-ED17-40CF-8619-BAF1BB9D1CF2} 7/31/2004{790C9A7C-264C-4D48-A9D3-E2571A8011D8} 7/31/2004{A03D6052-1F85-4EBE-AAC9-B67CFDCD91A6} 7/31/2004{A63966B6-9AD6-40BC-AFD4-A83745879F4D} 7/31/2004{8C7321D2-2C64-4902-9D64-8F5C1EB7F747} 7/31/2004{45358AE8-0B0E-4C11-90BB-DAC3EC0D5C82} 7/31/2004{BB4A3E50-232E-4212-9FAF-E67429FEBC7D} 7/31/2004{232D68BF-DF58-48F9-9235-53BD4B009B4B} 7/31/2004{416BF905-7D6C-4692-8FD6-40F6C4F9ECC4} 7/31/2004{4F361B4F-7920-4037-9A0A-46D616F9B9C7} 7/31/2004{F714B5EC-CA7C-4E6E-A812-2C5A119F4C30} 7/31/2004{A36B5D6B-72A5-47F8-9F6B-5D922130E760} 7/31/2004{8261B8CB-BC3F-4BCE-B364-86035D870263} 7/31/2004{FCCD65BA-2702-4409-AE56-75AF1710AC78} 7/31/2004{08D25BAA-167B-499C-8B51-31DCC856A8CF} 7/31/2004{2203154E-5EBD-4ACA-99BE-D835A3309D03} 7/31/2004{1AB0EDEB-7558-4734-8423-5A11B44DCA35} 7/31/2004{E35DA50A-BB51-4E08-8B8D-87EF4650247A} 7/31/2004{231B1798-F67B-45C1-9688-265180F93D28} 7/31/2004{A2A2CF20-4E5C-45F7-A7BD-1B94F0C3A43A} 7/31/2004{300223F3-5587-4230-909B-D9C4AFD6D683} 7/31/2004{83C6DABF-FD7D-4F5B-BB22-EB7EEBB9A772} 7/31/2004{B96BC9C2-5A25-4A9B-887A-C7C10E47B80C} 7/31/2004{25FC84D7-E013-44B8-82CD-63CD4723AF81} 7/31/2004{E720053D-922E-4C91-B81A-A1CA4EF8BB0E} 7/31/2004{B395CD84-77BA-4D3C-A49D-D9E8D6CF100B} 7/31/2004{9CE8B2E8-9944-4BA5-97DE-441D8314F161} 7/31/2004{6B10192F-D570-47C4-82C9-3D979B1EFDC1} 7/31/2004{9B9B768D-7CC1-4DCE-87CB-765AB73A6AFF} 7/31/2004{C6EB2566-CF28-4602-9A25-5B91C8728838} 7/31/2004{1F1D813D-3EDC-4274-8E9B-4519D71685B6} 7/31/2004{7E632B21-0D11-4BBA-8A68-8CAE14C20AE6} 7/31/2004{14010B0E-C101-4E41-B788-21923399E512} 7/31/2004{1D784088-DACB-4185-9F60-3D2DB4925BA5} 7/31/2004{B6998410-EE0F-4307-9E6E-FE348F11012D} 7/31/2004{A703169F-1563-488E-914D-D784FD07F29A} 7/31/2004{A6089357-2F2F-48CC-AB3C-D9B75A3C09D7} 7/31/2004{9C5F84D1-FB96-4D82-92A1-F932903DEAAD} 7/31/2004{68616AEA-81E5-4940-A7E4-6FBA882BCCF6} 7/31/2004{1F0E068A-48C5-40BF-8190-565150EFDADD} 7/31/2004{65207627-5521-4A8E-AD3C-B2F1B5226B85} 7/31/2004{6175876E-8FCC-4917-BE06-FC358515E6DF} 7/31/2004{49A05524-FA34-45B1-95BC-489901DC5B50} 7/31/2004{FB84759C-B687-43B2-8727-125EFE0F5E13} 7/31/2004{77878C43-F16E-437D-892F-3CFCC0715A0A} 7/31/2004{EB27C026-9470-4450-8D5E-1F38A41793B5} 7/31/2004{721A2921-C415-46DE-9111-13F25F428B8B} 7/31/2004{62A9F73F-6443-4F2F-B864-18186614BFB6} 7/31/2004

Page 37: Exercícios Excel Módulo I

{83A32D4C-4725-478F-9997-91739BB957BA} 7/31/2004{4958E1C3-C872-4222-954E-09D2060EA7EF} 7/31/2004{3229D93F-6A14-4BAC-ABC5-A91B9ECFB4D3} 7/31/2004{891C27F4-28CC-44BB-BEA3-DA5EA7FBE957} 7/31/2004{08B1BA74-DD80-4FDA-8327-93268B84977B} 7/31/2004{9A08108D-E039-4862-8F93-55F18017AD72} 7/31/2004{CDC11292-DF74-4FB0-8676-5B2AA4687142} 7/31/2004{8EF22FB3-AF37-4B44-8862-D60A7CB09D82} 7/31/2004{4652D4E4-6A27-47ED-9F51-C377E293DA28} 7/31/2004{492B24BD-BDE9-4371-B96E-CCD72264B91F} 7/31/2004{33543B35-77DA-4600-A41B-1EAFEA0AD643} 7/31/2004{18187809-5294-474F-85A1-D5BE6BD518D6} 7/31/2004{51FDE6AC-BD50-467C-90E5-10CA7310455C} 7/31/2004{CA5D1935-44E2-4C45-93BB-809E59F56796} 7/31/2004{BDADEB5C-A596-4DA1-88BA-842C7A0CC10F} 7/31/2004{CDB2C6DF-93E5-4558-91C8-424D5E7C658B} 7/31/2004{AAE1D04A-C237-4974-B4D5-935247737718} 7/31/2004{82E52D5A-165B-4C6D-9773-C3A6B6332ECD} 7/31/2004{9E912556-88BA-41EE-B946-CB84AB4C1102} 7/31/2004{FC617BB8-D2A3-4374-873C-8EF38D80127D} 7/31/2004{8FF3AF67-32F2-4A08-98C3-A40F842D41A3} 7/31/2004{352D6E2F-655B-49A2-9FEC-EFD7D8CD0D30} 7/31/2004{77B384C7-AFFB-4816-992B-F5B3034EE4FF} 7/31/2004{6ADBD932-0DA5-4F5C-AF67-8E3A53630896} 7/31/2004{6B7EB306-9A00-496A-98A9-4E94FE72F77C} 7/31/2004{FC12677F-42F8-4790-AD69-685088ED7E5F} 7/31/2004{F734D38A-56B5-471E-8DED-A682E958A9B3} 7/31/2004{12F678D7-EAD3-4CF4-8518-A19AACF2A6D4} 7/31/2004{9825EB00-8E36-4506-93A2-6DDCDC0B13C3} 7/31/2004{9E03395F-4D5D-4A53-880E-174BD8C1DB59} 7/31/2004{7D6B0155-0191-4599-8394-378EBDE63C9A} 7/31/2004{05C84608-F445-4F9D-BB5C-0828C309C29D} 1/26/2005{E249D613-36C9-4544-9B6F-6CE50E5E0DA5} 7/31/2004{A3DADF19-27F0-460A-9888-CE6CAA9E3583} 7/31/2004{34E128CF-D904-4327-8014-9DF0D5DE7D08} 7/31/2004{6B63EF27-2C55-4F4C-BE29-FCE8B694DC4A} 7/31/2004{F4DDD64F-DFFE-4DF3-AA17-D6BEA1924818} 7/31/2004{A1D86ECC-EA17-4B1B-8369-F1D07AB0A469} 7/31/2004{47E76B59-B137-4572-AD55-6B3E68C13BD3} 7/31/2004{50B6CDC6-7570-47EF-9570-48A64B5F2ECF} 7/31/2004{31112635-663B-4018-B4A2-A685C0BF48A4} 7/31/2004{EAA43680-5571-40CB-AB1A-3BF68F04459E} 7/31/2004{4F46DECA-EF01-41FD-9829-0ADAB368E431} 7/31/2004{A011C97B-081C-4739-996F-C1CAC4532F8D} 7/31/2004{FD3992FB-3067-451D-A09D-73BD53C0FECA} 7/31/2004{4103C891-37E8-4DFC-AEAC-B55E2BC1BE1C} 7/31/2004{723A5921-D8A1-4659-9BC4-13C4CF7C9C91} 7/31/2004{E19F8DE2-0F40-418C-84A2-DB48B98DC6A2} 7/31/2004{4A9A8407-A680-4A6B-8D03-511CB58F9A8A} 7/31/2004{BB510FCE-0105-4306-B591-6450D9EBF401} 7/31/2004{1E8F9E91-508F-4D49-ACD2-775C836030ED} 7/31/2004{7627B9D6-0707-4706-9AD9-0D37506B08AE} 7/31/2004{50EECC16-0D0D-43A9-9649-016C06DE8D78} 7/31/2004{B9BF7741-E0CA-4F37-ACDE-A4F78C6D03E9} 7/31/2004

Page 38: Exercícios Excel Módulo I

{604213F9-DD0F-43B4-BDD2-C96E93D3F4BF} 7/31/2004{0C67CE00-DE78-4712-908F-06939A2C58D5} 7/31/2004{4509F387-D73A-43DC-A502-B1C27AA1DC9E} 7/31/2004{1A68CD62-6FE9-4613-90D4-2CD178E4E54A} 7/31/2004{DE321854-B076-4D59-BB7B-42152031B108} 7/31/2004{DFA02733-C26E-4E31-99D8-9167E4E5131D} 7/31/2004{4D36A720-CE32-4C47-866A-DB7844449309} 7/31/2004{46286CA4-46DD-4DDB-9128-85B67E98D1A9} 7/31/2004{59747955-87B8-443F-8ED4-F8AD3AFDF3A9} 7/31/2004{F68C7C19-FAC1-438C-9BB7-AC33FCC341C3} 7/31/2004{54ED63DC-C62C-4CC7-89C2-015DF49C49A5} 7/31/2004{A8838AB2-99DE-415C-8675-D82EBF1C4752} 7/31/2004{01BCCE22-D63A-4C3F-9BA8-D3D5A4C3BD52} 7/31/2004{923ECFD6-E202-429A-9141-6CB183531439} 7/31/2004{6150F197-7923-40D4-84F2-936207D468AB} 7/31/2004{96442787-9520-4955-A457-38AFDDB6FF13} 7/31/2004{1D955171-E773-4FAD-8382-40FD898D5D4D} 7/31/2004{954B91B6-5AA7-48C2-8685-6E11C6E5C49A} 7/31/2004{45E8F437-670D-4409-93CB-F9424A40D6EE} 7/31/2004{D7314F24-2AF1-429C-9BBB-4038F45F3E6C} 7/31/2004{F3EC557C-8B41-4EE6-BB0C-E3B93AFF81E5} 7/31/2004

Page 39: Exercícios Excel Módulo I

Norte Sul Leste Oeste -

200.00

400.00

600.00

800.00

1,000.00

1,200.00

275.00

836.00

954.00

473.00

304.00

894.00

336.00

824.00

462.00

99.00

623.00

180.00

Chart Title

Jan

Fev

Mar

Page 40: Exercícios Excel Módulo I

Região Jan Fev MarNorte 275.00 304.00 462.00 Sul 836.00 894.00 99.00 Leste 954.00 336.00 623.00 Oeste 473.00 824.00 180.00

275.00

836.00

954.00

473.00

Comparativo de parto normal Jan

Norte

Sul

Leste

Oeste

304.00

894.00

336.00

824.00

Fev

Norte

Sul

Leste

Oeste

462.00

99.00 623.00

180.00

Mar

Norte

Sul

Leste

Oeste

Page 41: Exercícios Excel Módulo I

275.00

836.00

954.00

473.00

Comparativo de parto normal Jan

Norte

Sul

Leste

Oeste

304.00

894.00

336.00

824.00

Fev

Norte

Sul

Leste

Oeste

Page 42: Exercícios Excel Módulo I

4/8/20234/8/2023 7:07

#NAME?