Saltar al contenido
GridBelt
  • Prueba de Excel
  • Práctica
  • Programas
  • Precios
Iniciar sesión
Empezar la prueba gratuita
  • Prueba de Excel
  • Práctica
  • Programas
  • Precios
Iniciar sesiónCrear cuenta
Empezar la prueba gratuita
GridBelt

Practica Excel en tu navegador.

Prueba de Excel

  • Nivel 1: Principiante
  • Nivel 2: Intermedio
  • Nivel 3: Experto
  • Prueba de Excel en 7 días
  • Clasificación
  • Prueba de Excel para entrevistas
  • Evaluación de Excel de Indeed

Práctica

  • Todos los ejercicios
  • Programas
  • Para principiantes

Guías

  • Fórmulas de Excel
  • Atajos de Excel

Empresa

  • Acerca de
  • Precios
  • Cómo corregimos

© GridBelt. Todos los derechos reservados.

  • Política de privacidad
  • Términos de uso
  • Política de reembolso

Excel es una marca comercial de Microsoft Corporation. Indeed, TestGorilla, SHL y otras marcas son propiedad de sus respectivos titulares. GridBelt es un sitio de práctica independiente y no está afiliado a Microsoft, TestGorilla, SHL ni Indeed, ni respaldado ni patrocinado por ellos.

  1. Práctica
  2. /
  3. Charts

Excel chart practice: read a clustered column chart of revenue by region

  • Principiante
  • ~6 min
  • Charts

Enunciado en inglés

A kitchen-appliance wholesaler sells in six US regions. Before the sales kick-off, the director looks at a clustered column chart of revenue by region for 2025 and 2026, built from the table in A1:C8; the Total row adds up the regions. Read the chart to answer the questions, and put each growth rate next to the table: the chart shows dollars, not percentages.

Clustered column chart "Revenue by region ($ thousands)" with two columns per region, a blue one for 2025 and an orange one for 2026 (legend below the chart), each labelled with its value in thousands of dollars on an axis that starts at 0. Six regions from left to right, 2025 then 2026: Northeast 842 and 879; Southeast 612 and 689; Midwest 575 and 531; Southwest 403 and 446; Mountain 186 and 225; Pacific 736 and 771.

Qué tienes que hacer

  1. 1The table A1:C8 holds the numbers behind the chart: one row per region with its 2025 revenue in column B and its 2026 revenue in column C, and the Total row 8.
  2. 2Click D2. Growth is the change divided by the starting year: subtract the 2025 revenue (B2) from the 2026 revenue (C2), put brackets around the difference and divide by B2.
  3. 3Press Enter and fill D2 down to D8 (double-click the fill handle or press Ctrl+D / ⌘D on the selected range), so the Total row gets the company's growth too.
  4. 4Select D2:D8 and apply a percentage format with one decimal place: Ctrl+Shift+% (Control+Shift+% on a Mac), then Increase Decimal once (in this grid: the toolbar's Increase decimal places button, under ⋮ when the toolbar is narrow; in Excel, Format Cells with Ctrl+1 / ⌘1 → Percentage → 1 decimal place works too). A fall shows as a negative percentage.
  5. 5Then answer the questions: the first three need only the chart, the last one uses your column D. The chart is a picture: this practice grid has no chart command.

Celdas de respuesta

Preguntas

Elige aquí tus respuestas: el botón Comprobar las corrige junto con las celdas de respuesta.

  1. Pregunta 1In the chart, what do the orange columns show?

    Elige una respuesta.

  2. Pregunta 2Judging by the chart, which region added the most revenue in dollars from 2025 to 2026?

    Elige una respuesta.

  3. Pregunta 3Which region's revenue fell from 2025 to 2026?

    Elige una respuesta.

  4. Pregunta 4Now look at your column D. Which regions grew faster in percent than the company as a whole (the Total row)? Select all that apply.

    Selecciona todas las que correspondan.

Corrección

Responde a las preguntas, escribe tu fórmula en la cuadrícula, presiona Enter y luego haz clic en Comprobar. Evaluamos tus respuestas, el valor de cada celda de respuesta y la fórmula que lo produce.

Tareas

  1. Sin comprobarIn D2:D8, compute each row's growth from 2025 to 2026, (2026 − 2025) ÷ 2025, with one formula filled down through the Total row.
  2. Sin comprobarFormat D2:D8 as a percentage with one decimal place (for example 4.4% or -7.6%).
  3. Sin comprobarPregunta 1: In the chart, what do the orange columns show?
  4. Sin comprobarPregunta 2: Judging by the chart, which region added the most revenue in dollars from 2025 to 2026?
  5. Sin comprobarPregunta 3: Which region's revenue fell from 2025 to 2026?
  6. Sin comprobarPregunta 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.

Para las tareas de hoja de cálculo se recomienda una pantalla grande. La hoja se desplaza dentro de este recuadro.

StartInsertFormulasDataView
A1fxPreparando tu libro…
A
B
C
D
E
F
G
H
I
J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Sheet1

Responde a las preguntas, rellena las celdas y comprueba.

Sobre este ejercicio

Un conjunto de datos de 7 filas en una hoja, una celda de respuesta, unos 6 minutos. Se corrige en tu navegador: el valor y la fórmula que lo produce, con comentarios que te dicen qué arreglar. Incluye además 4 preguntas de opción múltiple, que se corrigen con el mismo botón Comprobar.

Cómo resolverlo

  • 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.

Otras formas válidas

  • =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

Respuestas a las preguntas

Clustered column chart "Revenue by region ($ thousands)" with two columns per region, a blue one for 2025 and an orange one for 2026 (legend below the chart), each labelled with its value in thousands of dollars on an axis that starts at 0. Six regions from left to right, 2025 then 2026: Northeast 842 and 879; Southeast 612 and 689; Midwest 575 and 531; Southwest 403 and 446; Mountain 186 and 225; Pacific 736 and 771.
  1. Pregunta 1. In the chart, what do the orange columns show?

    Respuesta: 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.

  2. Pregunta 2. Judging by the chart, which region added the most revenue in dollars from 2025 to 2026?

    Respuesta: 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.

  3. Pregunta 3. Which region's revenue fell from 2025 to 2026?

    Respuesta: 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.

  4. Pregunta 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.

    Respuestas: Southeast region, Southwest region y 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.

Errores frecuentes

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.

Cómo corregimos

Se acepta cualquier fórmula que produzca el resultado correcto, salvo que la tarea nombre una función: entonces otra función obtiene media puntuación. Comparamos los valores con una pequeña tolerancia y, en el texto, ignoramos mayúsculas y espacios. Un número correcto escrito a mano en lugar de una fórmula obtiene media puntuación. Las tareas de varias celdas obtienen la puntuación completa con el 100% de las celdas correctas y media puntuación desde el 50%. Cuando importa, también cambiamos una celda de entrada en una copia de tu hoja y comprobamos que tu fórmula se adapta.

Respuestas calculadas con las reglas de Excel 365 y comprobadas en nuestro corrector el 20 de noviembre de 2026. Autor: GridBelt team.

En estos programas

  • Learn Excel From ScratchDía 2

Ejercicios relacionados

  • Year-over-year % changePrincipiante, ~4 min
  • Pick the right chart for each questionPrincipiante, ~9 min
  • Spot a misleading chart axis and measure the real differenceIntermedio, ~8 min

Referencia de la función

Documentación oficial

Siguiente ejercicio

Spot a misleading chart axis and measure the real difference