Teste Final Excel
352 pág.

Teste Final Excel


DisciplinaExcel1.656 materiais2.325 seguidores
Pré-visualização50 páginas
Ex. 1
		Exercício 1) Aponte em Base 1 as Regionais e RTVs correspondentes a partir dos dados indicados nas tabelas ao lado. Na sequência, filtre a regional Cereais MG e apresente o valor total para 2018 e 2019 nas células G4 e H4.
		Arraste para a direita para visualizar as tabelas de referência.
		Base 1				Totais	$ 41,856,294.50	$ 10,612,302.68
		Cód. Regional	Regional	Marca	Cód. RTV	RTV	2018 (USD)	2019 (USD)		Cód. Regional	Regional		Cód. RTV	RTV
		MWR6	CEREAIS MG	ALIETTE WG	OGB	Jonas Netto	138	- 0		MWR6	CEREAIS MG		OGB	Jonas Netto
		MWR6	CEREAIS MG	ALIETTE WG	OGM	Tiago Quintino	165	- 0		MWR7	HFF		OGM	Tiago Quintino
		MWR6	CEREAIS MG	ALIETTE WG	OGO	Vago Vago	1,480	1,480		MWR8	CANA CENTRO		OGO	Vago Vago
		MWR6	CEREAIS MG	ALION SC500	OGJ	Emerson Mesquita	21,222	- 0		MWR9	HFF NORDESTE		OGJ	Emerson Mesquita
		MWR6	CEREAIS MG	ALION SC500	OGK	Adriano Mapeli	7,525	- 0		MWRA	CITRUS		OGK	Adriano Mapeli
		MWR6	CEREAIS MG	ALION SC500	OGM	Tiago Quintino	4,211	- 0		MWRB	CAFÉ SUL DE MINAS		OGQ	Luis Fernando Souto
		MWR6	CEREAIS MG	ALION SC500	OGQ	Luis Fernando Souto	0	- 0		MWRC	CANA SUL		OGI	Vitor Almeida
		MWR6	CEREAIS MG	ANTRACOL 700 PM	OGI	Vitor Almeida	- 29	- 0		MWS7	CANA DISTRIBUIÇÃO - SP		OGD	Vago Vago
		MWR6	CEREAIS MG	ATENTO FS 167	OGB	Jonas Netto	60	- 0		MWSC	CEREAIS SP		OGF	Pedro Andrade
		MWR6	CEREAIS MG	ATENTO FS 167	OGJ	Emerson Mesquita	- 5,089	- 0		MWSM	CANA NORTE		OGL	Vago Vago
		MWR6	CEREAIS MG	ATENTO FS 167	OGK	Adriano Mapeli	752	- 0		MWSN	CAFÉ		OHB	Carlos Aguillar
		MWR6	CEREAIS MG	ATENTO FS 167	OGO	Vago Vago	- 145	- 0					OHC	Cassio Monteiro
		MWR6	CEREAIS MG	AUREO EC720	OGB	Jonas Netto	147,934	- 0					OHD	Rogerio Marques
		MWR6	CEREAIS MG	AUREO EC720	OGD	Vago Vago	117,516	- 0					OHE	Leticia Soares
		MWR6	CEREAIS MG	AUREO EC720	OGF	Pedro Andrade	55,937	- 0					OHF	Leandro Fontoura
		MWR6	CEREAIS MG	AUREO EC720	OGI	Vitor Almeida	80,505	- 0					OHG	Fabiano Murta
		MWR6	CEREAIS MG	AUREO EC720	OGJ	Emerson Mesquita	60,843	- 42,463					OHH	Eduardo Artigiani
		MWR6	CEREAIS MG	AUREO EC720	OGK	Adriano Mapeli	51,153	- 0					OHI	Vago Vago
		MWR6	CEREAIS MG	AUREO EC720	OGL	Vago Vago	90,452	29,737					OHJ	Leandro Marcussi
		MWR6	CEREAIS MG	AUREO EC720	OGM	Tiago Quintino	101,815	- 0					OHK	Fernando Marinho
		MWR6	CEREAIS MG	AUREO EC720	OGO	Vago Vago	17,288	7,763					OHL	Paulo Vitor Freitas
		MWR6	CEREAIS MG	AUREO EC720	OGQ	Luis Fernando Souto	20,889	- 0					OHM	Patrick Barbosa
		MWR6	CEREAIS MG	BAYFOLAN COBRE	OGB	Jonas Netto	1	- 0					OHN	Talita Campos
		MWR6	CEREAIS MG	BAYFOLAN COBRE	OGF	Pedro Andrade	180	- 0					OHO	Thiago Borges
		MWR6	CEREAIS MG	BAYFOLAN COBRE	OGK	Adriano Mapeli	2,888	- 0					OHP	Antonio Duarte
		MWR6	CEREAIS MG	BAYFOLAN COBRE	OGM	Tiago Quintino	971	- 0					OIO	HEBER OLIVEIRA
		MWR6	CEREAIS MG	BAYTAN SC	OGB	Jonas Netto	307	- 0					OIC	Flavio Carvalho
		MWR6	CEREAIS MG	BAYTAN SC	OGI	Vitor Almeida	1,305	- 0					OIE	Osvaldo Ferreira
		MWR6	CEREAIS MG	BELT SC 480	OGB	Jonas Netto	102,293	- 0					OIF	Clayton Barella
		MWR6	CEREAIS MG	BELT SC 480	OGD	Vago Vago	237,514	303,553					OII	Lucas Machado
		MWR6	CEREAIS MG	BELT SC 480	OGF	Pedro Andrade	105,934	- 0					OIM	Raphael Verri
		MWR6	CEREAIS MG	BELT SC 480	OGI	Vitor Almeida	20,032	- 0					OIN	Frederico Torquetti
		MWR6	CEREAIS MG	BELT SC 480	OGJ	Emerson Mesquita	134,928	- 59,358					OIR	Gustavo Peterlevitz
		MWR6	CEREAIS MG	BELT SC 480	OGK	Adriano Mapeli	282,011	154,216					OIS	Fernando Baracioli
		MWR6	CEREAIS MG	BELT SC 480	OGL	Vago Vago	166,117	- 0					OIT	Dionisio Borba
		MWR6	CEREAIS MG	BELT SC 480	OGM	Tiago Quintino	458,560	32,510					OIB	Vago Vago
		MWR6	CEREAIS MG	BELT SC 480	OGO	Vago Vago	210,447	348,586					OJB	Vago Vago
		MWR6	CEREAIS MG	BELT SC 480	OGQ	Luis Fernando Souto	36,500	- 0					OJE	Vago Vago
		MWR6	CEREAIS MG	BIAGRO NG	OGM	Tiago Quintino	- 16	- 0					OJF	Gustavo Bim
		MWR6	CEREAIS MG	BIAGRO NG	OGO	Vago Vago	1,969	1,969					OJG	Vago Vago
		MWR6	CEREAIS MG	BULLDOCK 125 SC	OGF	Pedro Andrade	1,133	- 0					OJH	Andre Pimenta
		MWR6	CEREAIS MG	BULLDOCK 125 SC	OGI	Vitor Almeida	23,108	- 0					OJI	Vago Vago
		MWR6	CEREAIS MG	BULLDOCK 125 SC	OGK	Adriano Mapeli	144	- 0					OJJ	Vago Vago
		MWR6	CEREAIS MG	BULLDOCK 125 SC	OGM	Tiago Quintino	107	- 0					OJD	Vago Vago
		MWR6	CEREAIS MG	BULLDOCK 125 SC	OGO	Vago Vago	66,528	- 0					OJC	Vago Vago
		MWR6	CEREAIS MG	BULLDOCK 125 SC	OGQ	Luis Fernando Souto	0	- 0					OKE	Anselmo Koga
		MWR6	CEREAIS MG	CALYPSO 480 SC	OGI	Vitor Almeida	495	- 0					OKJ	Paulo Ronqui
		MWR6	CEREAIS MG	CENSOR	OGB	Jonas Netto	11,499	- 0					OKL	Joao Fajardo
		MWR6	CEREAIS MG	CERTERO SC 480	OGB	Jonas Netto	87,188	- 0					OKB	Marcio Lima
		MWR6	CEREAIS MG	CERTERO SC 480	OGD	Vago Vago	160,989	- 0					OKC	FERNANDO GIROTO
		MWR6	CEREAIS MG	CERTERO SC 480	OGF	Pedro Andrade	134,881	- 0					OKG	Jonas Gardino
		MWR6	CEREAIS MG	CERTERO SC 480	OGI	Vitor Almeida	67,279	- 0					OKM	Aloisio de Padua Mendes
		MWR6	CEREAIS MG	CERTERO SC 480	OGJ	Emerson Mesquita	106,206	- 0					OLG	Vago Vago
		MWR6	CEREAIS MG	CERTERO SC 480	OGK	Adriano Mapeli	62,475	- 0					OLH	Vago Vago
		MWR6	CEREAIS MG	CERTERO SC 480	OGL	Vago Vago	200,597	- 0					OLI	Vago Vago
		MWR6	CEREAIS MG	CERTERO SC 480	OGM	Tiago Quintino	240,545	6,115					OLK	Vago Vago
		MWR6	CEREAIS MG	CERTERO SC 480	OGO	Vago Vago	34,489	41,703					OLL	Vago Vago
		MWR6	CEREAIS MG	CERTERO SC 480	OGQ	Luis Fernando Souto	55,480	6,716					OLO	Vago Vago
		MWR6	CEREAIS MG	CONNECT	OGB	Jonas Netto	430,475	72,413					OLM	Leila Rodrigues
		MWR6	CEREAIS MG	CONNECT	OGD	Vago Vago	336,288	- 0					OLP	Vago Vago
		MWR6	CEREAIS MG	CONNECT	OGF	Pedro Andrade	618,759	137,866					OLJ	RTV VAGO - OLJ
		MWR6	CEREAIS MG	CONNECT	OGI	Vitor Almeida	457,230	48,756					OMD	Leonardo Silverio
		MWR6	CEREAIS MG	CONNECT	OGJ	Emerson Mesquita	725,363	279,516					OME	Renan Zanni
		MWR6	CEREAIS MG	CONNECT	OGK	Adriano Mapeli	253,516	31,112					OMF	Vago Vago
		MWR6	CEREAIS MG	CONNECT	OGL	Vago Vago	353,737	92,166					OMG	Onofre Bassan Junior
		MWR6	CEREAIS MG	CONNECT	OGM	Tiago Quintino	773,157	53,692					OMI	Vago Vago
		MWR6	CEREAIS MG	CONNECT	OGO	Vago Vago	450,866	417,222					OMJ	Alexandre Coelho
		MWR6	CEREAIS MG	CONNECT	OGQ	Luis Fernando Souto	109,766	3,802					OMO	Eduardo Vila
		MWR6	CEREAIS MG	CONSENTO SC 450	OGB	Jonas Netto	77	- 0					OMP	LAURO CHAGAS
		MWR6	CEREAIS MG	CONSENTO SC 450	OGF	Pedro Andrade	- 244	- 0					OMQ	Aureo Henrique
		MWR6	CEREAIS MG	CONSENTO SC 450	OGI	Vitor Almeida	- 158	- 0					OZE	Vago Vago
		MWR6	CEREAIS MG	CONSENTO SC 450	OGM	Tiago Quintino	252	- 0					PCB	Adriano Oliane
		MWR6	CEREAIS MG	CONSENTO SC 450	OGO	Vago Vago	18,215	16,862					PCD	Mariana Trevisan
		MWR6	CEREAIS MG	CROPSTAR	OGB	Jonas Netto	318,628	82,015					PCF	Paulo Castro
		MWR6	CEREAIS MG	CROPSTAR	OGD	Vago Vago	105,234	- 0					PCG	GUSTAVO ABRÃO
		MWR6	CEREAIS MG	CROPSTAR	OGF	Pedro Andrade	454,032	201,174					PCH	VALMIR MARSON MARSON
		MWR6	CEREAIS MG	CROPSTAR	OGI	Vitor Almeida	237,568	12,647					PCI	Douglas Da Rocha
		MWR6	CEREAIS MG	CROPSTAR	OGJ	Emerson Mesquita	64,868	56,324					PCE	Newmar Panaggio
		MWR6	CEREAIS MG	CROPSTAR	OGK	Adriano Mapeli	139,356	46,978					PCC	Ivan Furlan
		MWR6	CEREAIS MG	CROPSTAR	OGL	Vago Vago	- 24,161	- 0					PCJ	PEDRO JUNQUEIRA
		MWR6	CEREAIS MG	CROPSTAR	OGM	Tiago Quintino	459,934	91,067					PCK	Rodrigo Silva
		MWR6	CEREAIS MG	CROPSTAR	OGO	Vago Vago	72,903	135,380					PQG	Fabricio Alvim
		MWR6	CEREAIS MG	CROPSTAR	OGQ	Luis Fernando Souto	54,101	9,133					PQJ	Artur Pinheiro
		MWR6	CEREAIS MG	CURBIX	OGK	Adriano Mapeli	39,659	- 0					PQB	ANGELO VOLPATO
		MWR6	CEREAIS MG	CURBIX	OGM	Tiago Quintino	1,032	- 0					PQC	Bruno Lima
		MWR6	CEREAIS MG	DECIS 25 CE	OGB	Jonas Netto	0	- 0					PQD	Paulo Vohlk
		MWR6	CEREAIS MG	DECIS 25 CE	OGF	Pedro Andrade	1,623	- 0					PQE	Vago Vago
		MWR6	CEREAIS MG	DECIS 25 CE	OGI	Vitor Almeida	- 0	- 0					PQF	Evanderlei Alkamin
		MWR6	CEREAIS MG	DECIS 25 CE	OGM	Tiago Quintino	165	- 0					PQI	Daniel Oliveira
		MWR6	CEREAIS MG	DEROSAL PLUS	OGB	Jonas Netto	46,993	- 0					PQK	Adriano Souza
		MWR6	CEREAIS MG	DEROSAL PLUS	OGD	Vago Vago	759,992	- 0					PQL	Vago Vago