← Back to demoPrototype · Interactive Cell

Excel lesson — interactive edition

Same lesson structure as today, but the practice sections are real spreadsheets. Type a formula, press Enter, see it evaluate against the actual cells.

Intro

VLOOKUP, but you actually try it

Reading about formulas only takes you so far. Below is a real spreadsheet — type the formula yourself, hit Enter, and watch it work.

Key concept

SUM adds a range of numbers

=SUM(A1:A3) adds the values in cells A1, A2, and A3.

You can pass any range. The colon means "everything between."

Example

=SUM(A1:A3) → 60

Try it

Add up January sales

Column A has three days of sales. In cell B1, write a formula that adds them all up.

AB
110
220·
330·
Type in cell B1, press Enter

Key concept

AVERAGE gives you the mean

=AVERAGE(range) returns the arithmetic mean.

Same shape as SUM — just a different function name.

Try it

What is the average?

Same numbers as before. In B1, write a formula that returns their average.

AB
110
220·
330·
Type in cell B1, press Enter

Pro tip

You can reference any cell

Formulas live anywhere. =A1+A2 works just as well as =SUM(A1:A2). Use ranges when you have more than a couple of cells.

Summary

What you just did

  • Wrote your first SUM formula and saw it compute live
  • Swapped SUM for AVERAGE in the same shape
  • Built muscle memory the boring text version cannot give you