← Practice challengesFree companion · 15 minute suggested activity

Calculate growth without confusing percentage points

Excel practice · Use the supplied CSV with headers in row 1. Formulas use English function names and commas; your locale may use translated names or semicolons.

Learn → Try → ExplainReviewed 2026-10-15

Your task

Use April EUR 300 and May EUR 400 to calculate absolute and relative growth. Write the metric definition and output unit before choosing a formula.

Hint

Use a separate calculation area so the raw source stays unchanged. Keep excluded rows and reconcile the total.

Worked solution

If G2=300 and H2=400: =H2-G2 gives EUR 100; =IF(G2=0,"Not defined",H2/G2-1) gives 33.33% when formatted as percent. This is relative growth, not 33 percentage points.

Boundary check

A zero starting value makes relative growth undefined. Show the absolute change rather than silently replacing the denominator with one.

Make the reasoning yours.

Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.

Resume guidance and examples are for learning and preparation only. They do not guarantee interviews, a job offer or employment.

Public registration, payments and new paid enrolment remain disabled. These free resources do not grant access to protected course modules.

Learner dashboard ↗ · Ask a question ↗