Lesson 1: The grid, cells and SUM

SheetDrill Lesson 1 · The grid, cells and SUM

Lesson 1

fx

✓

Lesson 1 done.

You can add cells, total a column with SUM, and pull averages, highs and lows. That's already more than most people do in Excel.

Lesson 2: IF, make the sheet decide →

What you're learning

A spreadsheet is a grid. Columns have letters, rows have numbers, so every cell has an address like B3. A formula starts with = and tells Excel to calculate something from other cells. When those cells change, the formula updates on its own. That's the whole point: never type a number you could calculate.

SUM(B2:B6) adds everything from B2 down to B6. The colon means "through". AVERAGE, MAX, MIN and COUNT work the same way on a range.