bitos

Plan1Quantidade de trabalhadores envolvidos em Acidentes de Trabalho no BrasilAnoTrabalhadoresTpicoTrajetoDoenasTotal de AcidentadosbitosRelao Acid/bitosRelao bitos/Total Geral de bitos197917,637,1271,388,52552,2793,8231,444,6274,6730.3%198018,686,3551,404,53155,9673,7131,464,2114,8240.3%198119,188,5361,215,53951,7223,2041,270,4654,8080.4%198219,476,3621,117,83257,8742,7661,178,4724,4960.4%1Calcular totais horizontais (Linha 34) e verticais (Coluna F)198319,671,128943,11056,9893,0161,003,1154,2140.4%2Coluna I: Relao entre Total de Acidentados e bitos (Em percentual)198419,673,915901,23857,0543,233961,5254,5080.5%3Usar a ferramenta Formatao Condicional para a coluna G (bitos)198521,151,9941,010,34063,5154,0061,077,8614,3840.4%198622,163,8271,129,15272,6936,0141,207,8594,5780.4%4Criar grfico de Disperso contendo o nde bitos por ano198722,617,7871,065,91264,8306,3821,137,1245,7380.5%5Criar grfico tipo Pizza dos acidentes por tipo do ano de 2008198823,661,579926,35660,2025,025991,5834,6160.5%198924,486,553825,08158,5244,838888,4434,5540.5%199023,198,656632,01256,3435,217693,5725,3550.8%199123,004,264579,36246,6796,281632,3224,5270.7%199222,272,843490,91633,2998,299532,5143,5160.7%199323,165,027374,16722,70915,417412,2933,1100.8%199423,667,241350,21022,82415,270388,3043,1290.8%199523,755,736374,70028,79120,646424,1373,9670.9%199623,838,312325,87034,69634,889395,4554,4881.1%199724,140,428347,48237,21336,648421,3433,4690.8%199824,491,635347,73836,11430,489414,3413,7930.9%199924,993,265326,40437,51323,903387,8203,8961.0%200026,228,629304,96339,30019,605363,8683,0940.9%200127,189,614282,96538,79918,487340,2512,7530.8%200228,683,913323,87946,88122,311393,0712,9680.8%200329,544,927325,57749,64223,858399,0772,6740.7%200431,407,576375,17160,33530,194465,7002,8390.6%200533,238,617398,61367,97133,096499,6802,7660.6%200635,155,249407,42674,63630,170512,2322,7980.5%200737,607,430417,03679,00522,374518,4152,8450.5%200839,441,566438,53688,15618,576545,2682,7570.5%TOTAIS753,440,09119,350,6431,552,555461,75021,364,948116,1370.5%

Plan2