Scribd
Upload
215 views8 pages

Teste Excel

The document is a sales table from 2020 that lists car sales data including date, sale number, model, manufacturer, color, and salesperson. It shows 77 car sales took place in 2020, with 7 Fiat Palio sales. 5 Honda Civics in black were sold. The total value of Toyota Corolla sales was R$644,000.00 and Chevrolet Cruze sales in silver totaled R$364,000. Salesperson Willian made sale 1088. Total sales in August 2020 were R$616,000.00.

Uploaded by

talitha rodrigues
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
215 views8 pages

Teste Excel

The document is a sales table from 2020 that lists car sales data including date, sale number, model, manufacturer, color, and salesperson. It shows 77 car sales took place in 2020, with 7 Fiat Palio sales. 5 Honda Civics in black were sold. The total value of Toyota Corolla sales was R$644,000.00 and Chevrolet Cruze sales in silver totaled R$364,000. Salesperson Willian made sale 1088. Total sales in August 2020 were R$616,000.00.

Uploaded by

talitha rodrigues
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

TABELA DE VENDAS 2020

Data Numero da Venda Modelo do Carro Montadora Cor


1/7/2020 1050 Civic Honda Preto
1/12/2020 1051 Corolla Toyota Branco
1/17/2020 1052 Gol Volkswagen Prata
1/22/2020 1053 Fit Honda Preto
1/27/2020 1054 Palio Fiat Branco
2/1/2020 1055 Golf Volkswagen Prata
2/6/2020 1056 S10 Chevrolet Preto
2/11/2020 1057 Cruze Chevrolet Branco
2/16/2020 1058 Onix Chevrolet Preto
2/21/2020 1059 EcoSport Ford Branco
2/26/2020 1060 Toro Fiat Prata
3/2/2020 1061 Civic Honda Preto
3/7/2020 1062 Corolla Toyota Branco
3/12/2020 1063 Gol Volkswagen Prata
3/17/2020 1064 Fit Honda Preto
3/22/2020 1065 Palio Fiat Branco
3/27/2020 1066 Golf Volkswagen Preto
4/1/2020 1067 S10 Chevrolet Branco
4/6/2020 1068 Cruze Chevrolet Prata
4/11/2020 1069 Onix Chevrolet Preto
4/16/2020 1070 EcoSport Ford Branco
4/21/2020 1071 Toro Fiat Prata
4/26/2020 1072 Civic Honda Preto
5/1/2020 1073 Corolla Toyota Branco
5/6/2020 1074 Gol Volkswagen Preto
5/11/2020 1075 Fit Honda Branco
5/16/2020 1076 Palio Fiat Prata
5/21/2020 1077 Golf Volkswagen Preto
5/26/2020 1078 S10 Chevrolet Branco
5/31/2020 1079 Cruze Chevrolet Prata
6/5/2020 1080 Onix Chevrolet Preto
6/10/2020 1081 EcoSport Ford Branco
6/15/2020 1082 Toro Fiat Preto
6/20/2020 1083 Civic Honda Branco
6/24/2020 1084 Corolla Toyota Prata
6/28/2020 1085 Gol Volkswagen Preto
7/2/2020 1086 Fit Honda Branco
7/6/2020 1087 Palio Fiat Prata
7/10/2020 1088 Golf Volkswagen Preto
7/14/2020 1089 S10 Chevrolet Branco
7/18/2020 1090 Cruze Chevrolet Preto
7/22/2020 1091 Onix Chevrolet Branco
7/26/2020 1092 EcoSport Ford Prata
7/30/2020 1093 Toro Fiat Preto
8/3/2020 1094 Civic Honda Branco
8/7/2020 1095 Corolla Toyota Prata
8/11/2020 1096 Gol Volkswagen Preto
8/15/2020 1097 Fit Honda Branco
8/19/2020 1098 Palio Fiat Branco
8/23/2020 1099 Golf Volkswagen Preto
8/27/2020 1100 S10 Chevrolet Branco
8/31/2020 1101 Cruze Chevrolet Prata
9/4/2020 1102 Onix Chevrolet Preto
9/8/2020 1103 EcoSport Ford Branco
9/12/2020 1104 Toro Fiat Prata
9/16/2020 1105 Civic Honda Preto
9/20/2020 1106 Corolla Toyota Branco
9/24/2020 1107 Gol Volkswagen Prata
9/28/2020 1108 Fit Honda Preto
10/2/2020 1109 Palio Fiat Branco
10/6/2020 1110 Golf Volkswagen Preto
10/10/2020 1111 S10 Chevrolet Branco
10/14/2020 1112 Cruze Chevrolet Prata
10/18/2020 1113 Onix Chevrolet Preto
10/22/2020 1114 EcoSport Ford Branco
10/26/2020 1115 Toro Fiat Prata
10/30/2020 1116 Civic Honda Preto
11/3/2020 1117 Corolla Toyota Branco
11/7/2020 1118 Gol Volkswagen Prata
11/11/2020 1119 Fit Honda Preto
11/15/2020 1120 Palio Fiat Preto
11/19/2020 1121 Golf Volkswagen Branco
11/23/2020 1122 S10 Chevrolet Prata
11/27/2020 1123 Cruze Chevrolet Preto
12/1/2020 1124 Onix Chevrolet Branco
12/5/2020 1125 EcoSport Ford Prata
12/9/2020 1126 Toro Fiat Preto
Valor Vendedor
R$ 90,000.00 Paulo
R$ 92,000.00 Paulo
R$ 56,000.00 Willian
R$ 75,000.00 Sandro
R$ 48,000.00 Paulo
R$ 69,000.00 Willian
R$ 95,000.00 Wagner
R$ 91,000.00 Camila
R$ 62,000.00 Wagner
R$ 79,000.00 Paulo
R$ 89,000.00 Willian
R$ 90,000.00 Sandro
R$ 92,000.00 Paulo
R$ 56,000.00 Paulo
R$ 75,000.00 Willian
R$ 48,000.00 Sandro
R$ 69,000.00 Paulo
R$ 95,000.00 Willian
R$ 91,000.00 Wagner
R$ 62,000.00 Camila
R$ 79,000.00 Wagner
R$ 89,000.00 Paulo
R$ 90,000.00 Willian
R$ 92,000.00 Sandro
R$ 56,000.00 Paulo
R$ 75,000.00 Paulo
R$ 48,000.00 Willian
R$ 69,000.00 Sandro
R$ 95,000.00 Paulo
R$ 91,000.00 Willian
R$ 62,000.00 Wagner
R$ 79,000.00 Camila
R$ 89,000.00 Wagner
R$ 90,000.00 Paulo
R$ 92,000.00 Willian
R$ 56,000.00 Sandro
R$ 75,000.00 Paulo
R$ 48,000.00 Paulo
R$ 69,000.00 Willian
R$ 95,000.00 Sandro
R$ 91,000.00 Paulo
R$ 62,000.00 Willian
R$ 79,000.00 Wagner
R$ 89,000.00 Camila
R$ 90,000.00 Wagner
R$ 92,000.00 Paulo
R$ 56,000.00 Willian
R$ 75,000.00 Sandro
R$ 48,000.00 Paulo
R$ 69,000.00 Paulo
R$ 95,000.00 Willian
R$ 91,000.00 Sandro
R$ 62,000.00 Paulo
R$ 79,000.00 Willian
R$ 89,000.00 Wagner
R$ 90,000.00 Camila
R$ 92,000.00 Wagner
R$ 56,000.00 Paulo
R$ 75,000.00 Willian
R$ 48,000.00 Sandro
R$ 69,000.00 Paulo
R$ 95,000.00 Paulo
R$ 91,000.00 Willian
R$ 62,000.00 Sandro
R$ 79,000.00 Paulo
R$ 89,000.00 Willian
R$ 90,000.00 Wagner
R$ 92,000.00 Camila
R$ 56,000.00 Wagner
R$ 75,000.00 Paulo
R$ 48,000.00 Willian
R$ 69,000.00 Sandro
R$ 95,000.00 Paulo
R$ 91,000.00 Paulo
R$ 62,000.00 Willian
R$ 79,000.00 Sandro
R$ 89,000.00 Paulo
TESTE PARA ENTREVISTA
Nome

Item Questão Resposta

1 Quantas vendas foram realizadas no ano de 2020? 77

2 Quantos Carros “Palio” foram vendidas em 2020? 7

3 Quantos "Civic" da Cor “Preto” foram vendidos em todo o período? 5

4 Qual é a soma do valor de venda do carro "Corolla"? 644,000.00

5 Qual é a soma do valor de venda do carro "Cruze" na cor "Prata"? 364,000.00

6 Quem foi o funcionário que realizou a venda de código “1088”? Willian

7 Qual o faturamento no mês de Agosto/2020? R$ 616,000.00

Questão Final
8 Classifique as montadoras que mais faturaram do maior para o menor faturamento?

Classificação Montadora Faturamento


1 CHECROLET R$ 1,736,000.00
2 HONDA R$ 1,155,000.00
3 FIAT R$ 959,000.00
4 WOLKSWAGEN R$ 819,000.00
5 TOYOTA R$ 644,000.00
6 FORD R$ 553,000.00

Os campos em BEGE devem ser preenchidos com fórmulas


1088

You might also like