Sobre este exercício
Um conjunto de dados de 7 linhas em uma planilha, uma célula de resposta, cerca de 6 minutos. Corrigido no seu navegador: o valor e a fórmula por trás dele, com feedback que mostra o que corrigir. O exercício também traz 4 questões de múltipla escolha, corrigidas pelo mesmo botão Verificar.
Como resolver
- D2
=(C2-B2)/B2
Growth is the change divided by the starting value: =(C2-B2)/B2 gives the first region's 2026 change as a share of 2025, and filling down to the Total row gives the company's rate to compare with; the 0.0% format shows 0.044 as 4.4%. Reading the chart: the legend says orange is 2026; the biggest dollar increase is the widest gap between a region's two columns (Southeast); the only orange column shorter than its blue partner is Midwest's; and column D shows that Southeast, Southwest and Mountain grew faster than the company.
In Excel: select A1:C7 (leave the Total row out, or its two columns dwarf every region) and choose Insert → Insert Column or Bar Chart → Clustered Column; Excel makes the two year columns the series because the range has more rows than columns. Data labels: Chart Design → Add Chart Element → Data Labels (the tab is called Design, under Chart Tools, in Excel 2016–2019); the number format code #,##0, (Format Axis or Format Data Labels → Number) shows thousands, 879,400 as 879. Pitfall 1: a chart compares heights, so it shows dollar differences; growth in percent needs the calculation, and a small region can grow fastest with the shortest columns. Pitfall 2: if the year headers were numbers instead of text, Excel could plot them as data; clearing the corner cell A1 or storing the years as text keeps them as series names (fix an existing chart with Chart Design → Select Data). Pitfall 3: =C2-B2/B2 without brackets divides first and returns a huge number instead of a percentage.
Outras formas que funcionam
- =C2/B2-1 — the same result, shorter
- =(C2-B2)/ABS(B2) — also right when a starting value can be negative (not the case for revenue)
- =IFERROR((C2-B2)/B2,"") — blank instead of #DIV/0! for a region that is new this year
Respostas às questões
Questão 1. In the chart, what do the orange columns show?
Resposta: Revenue in 2026
The legend under the chart maps each colour to a series: blue is 2025 and orange is 2026. A clustered column chart draws one column per series in every category, side by side, so each region gets a 2025 column and a 2026 column.
Questão 2. Judging by the chart, which region added the most revenue in dollars from 2025 to 2026?
Resposta: Southeast region
Compare the gap between each region's two columns, not the height of the orange one: Southeast goes from about 612 to 689 thousand, about $78K more, the widest gap. Northeast has the tallest columns but adds only about $37K.
Questão 3. Which region's revenue fell from 2025 to 2026?
Resposta: Midwest region
Midwest is the only region whose orange 2026 column is shorter than its blue 2025 column (about 575 down to 531 thousand). Mountain has the shortest columns, but small is not the same as falling: its 2026 column is the taller of its pair.
Questão 4. Now look at your column D. Which regions grew faster in percent than the company as a whole (the Total row)? Select all that apply.
Respostas: Southeast region, Southwest region e Mountain region
The company grew by 5.6%. Southeast (12.7%), Southwest (10.8%) and Mountain (20.6%) beat that. Mountain has the highest rate of all although its columns are the shortest: a percentage divides the increase by the starting value, and a small start makes a modest gain a big percentage.
Erros comuns
Typing =C2-B2/B2 without brackets: Excel divides B2 by itself first and returns the 2026 revenue minus 1 (879,399 for Northeast) instead of a growth rate. Wrap the difference in brackets: =(C2-B2)/B2.
Como corrigimos
Qualquer fórmula que produza o resultado certo é aceita, a menos que a tarefa cite uma função: nesse caso, outra função vale metade da pontuação. Comparamos os valores com uma pequena tolerância e ignoramos maiúsculas e espaços no texto. Um número certo digitado à mão em vez de uma fórmula vale metade da pontuação. Tarefas com várias células valem a pontuação integral com 100% das células certas e metade a partir de 50%. Quando faz diferença, também mudamos uma célula de entrada em uma cópia da sua planilha e verificamos se sua fórmula acompanha.
Respostas calculadas com as regras do Excel 365 e verificadas no nosso corretor em 20 de novembro de 2026. Autor: GridBelt team.