Start Here — A Complete Tour
Sums, products & the formula library
continues from lesson 6 — values defined earlier in the course stay live here
For "add this up over a range," use Sum (capital S): Sum("expression", "index", start, end) — the expression and index go in quotes. Prod is the same for multiplication. You never have to type these from memory: the Σ Formulas button in the toolbar opens a searchable library of ready-made formulas you can drop in.
= 1 + 2 + ⋯ + 100, the long way
✓ pass Gauss was right
= 5! = 1·2·3·4·5
✓ pass