Vai al contenuto
GridBelt
  • Test Excel
  • Esercizi
  • Programmi
  • Prezzi
Accedi
Inizia il test gratuito
  • Test Excel
  • Esercizi
  • Programmi
  • Prezzi
AccediCrea un account
Inizia il test gratuito
GridBelt

Esercitati con Excel nel tuo browser.

Test Excel

  • Livello 1: Principiante
  • Livello 2: Intermedio
  • Livello 3: Esperto
  • Test Excel in 7 giorni
  • Classifica
  • Test Excel per il colloquio
  • Valutazione Excel di Indeed

Esercizi

  • Tutti gli esercizi
  • Programmi
  • Per principianti

Guide

  • Formule Excel
  • Scorciatoie Excel

Azienda

  • Chi siamo
  • Prezzi
  • Come valutiamo

© GridBelt. Tutti i diritti riservati.

  • Informativa sulla privacy
  • Termini di utilizzo
  • Politica di rimborso

Excel è un marchio di Microsoft Corporation. Indeed, TestGorilla, SHL e gli altri marchi appartengono ai rispettivi proprietari. GridBelt è un sito di esercitazione indipendente e non è affiliato a Microsoft, TestGorilla, SHL o Indeed, né approvato o sponsorizzato da queste società.

  1. Esercizi
  2. /
  3. Charts

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

  • Principiante
  • ~6 min
  • Charts

Testo dell’esercizio in inglese

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.

Cosa devi fare

  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.

Celle di risposta

Domande

Scegli qui le tue risposte: il pulsante Verifica le valuta insieme alle celle di risposta.

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

    Scegli una risposta.

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

    Scegli una risposta.

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

    Scegli una risposta.

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

    Seleziona tutte le risposte corrette.

Correzione

Rispondi alle domande, scrivi la formula nella griglia, premi Enter, poi Verifica. Valutiamo le tue risposte, il valore in ogni cella di risposta e la formula che lo produce.

Attività

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

Consigliato il computer per le attività sul foglio di calcolo. Il foglio scorre all’interno di questo riquadro.

StartInsertFormulasDataView
A1fxPreparazione della cartella di lavoro…
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

Rispondi alle domande, compila le celle, poi verifica.

Informazioni sull’esercizio

Un set di dati di 7 righe su un foglio, una cella di risposta, circa 6 minuti. Correzione nel tuo browser: il valore e la formula che lo produce, con indicazioni su cosa sistemare. L’esercizio include anche 4 domande a risposta multipla, valutate con lo stesso pulsante Verifica.

Come risolverlo

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

Altri metodi validi

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

Risposte alle domande

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. Domanda 1. In the chart, what do the orange columns show?

    Risposta: 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. Domanda 2. Judging by the chart, which region added the most revenue in dollars from 2025 to 2026?

    Risposta: 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. Domanda 3. Which region's revenue fell from 2025 to 2026?

    Risposta: 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. Domanda 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.

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

Errori comuni

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.

Come valutiamo

È accettata qualsiasi formula che produce il risultato giusto, a meno che l’attività non indichi una funzione: in quel caso un’altra funzione vale metà dei punti. Confrontiamo i valori con una piccola tolleranza e ignoriamo maiuscole, minuscole e spazi nel testo. Un numero corretto digitato a mano invece di una formula vale metà dei punti. Le attività su più celle valgono il punteggio pieno con il 100% delle celle giuste, metà dei punti dal 50%. Dove serve, cambiamo anche una cella di input su una copia del tuo foglio e controlliamo che la formula si aggiorni.

Risposte calcolate con le regole di Excel 365 e verificate nel nostro correttore in data 20 novembre 2026. Autore: GridBelt team.

In questi programmi

  • Learn Excel From ScratchGiorno 2

Esercizi correlati

  • 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

Guida alla funzione

Documentazione ufficiale

Esercizio successivo

Spot a misleading chart axis and measure the real difference