atividade prática final excel josé augusto rocha cabral

Prévia do material em texto

Plan1
		Sonho Doce - Hardware e Software Rua Nestor Lima , 01 - Fernando de noronha - PE
	N°	NOME	salário bruto	INSS	Gratificação	INSS R$	Gratificação R$	Salário Líquido
	1	Eduardo	R$853.00	10.00%	9.00%	R$85.30	R$76.77	R$844.47
	2	Maria	R$951.00	9.99%	8.00%	R$95.00	R$76.08	R$932.08
	3	Helena	R$456.00	8.64%	6.00%	R$39.40	R$27.36	R$443.96
	4	Gabriela	R$500.00	8.50%	6.00%	R$42.50	R$30.00	R$487.50
	5	Edson	R$850.00	8.99%	7.00%	R$76.42	R$59.50	R$833.09
	6	Elisangela	R$559.00	6.25%	5.00%	R$34.94	R$27.95	R$552.01
	7	Regina 	R$478.00	7.12%	5.00%	R$34.03	R$23.90	R$467.87
	8	Paulo	R$658.00	5.99%	4.00%	R$39.41	R$26.32	R$644.91
gráfico Sonho Doce
salário bruto	Eduardo	Maria	Helena	Gabriela	Edson	Elisangela	Regina 	Paulo	853	951	456	500	850	559	478	658	INSS	Eduardo	Maria	Helena	Gabriela	Edson	Elisangela	Regina 	Paulo	0.1	9.9900000000000003E-2	8.6400000000000005E-2	8.5000000000000006E-2	8.9899999999999994E-2	6.25E-2	7.1199999999999999E-2	5.9900000000000002E-2	Gratificação	Eduardo	Maria	Helena	Gabriela	Edson	Elisangela	Regina 	Paulo	0.09	0.08	0.06	0.06	7.0000000000000007E-2	0.05	0.05	0.04	INSS R$	Eduardo	Maria	Helena	Gabriela	Edson	Elisangela	Regina 	Paulo	85.300000000000011	95.004900000000006	39.398400000000002	42.5	76.414999999999992	34.9375	34.0336	39.414200000000001	Gratificação R$	Eduardo	Maria	Helena	Gabriela	Edson	Elisangela	Regina 	Paulo	76.77	76.08	27.36	30	59.500000000000007	27.950000000000003	23.900000000000002	26.32	Salário Líquido	Eduardo	Maria	Helena	Gabriela	Edson	Elisangela	Regina 	Paulo	844.47	932.07509999999991	443.96160000000003	487.5	833.08500000000004	552.01250000000005	467.8664	644.9058