Spreadsheets II — Formulas, Functions, and Charts
18 levels · 7 phases · Levels 1–3 free
Functions: Doing the Adding for You (3 levels)
Logic: Formulas That Decide (3 levels)
Copying Formulas Correctly (4 levels)
Organising and Exploring Data (3 levels)
Charts (3 levels)
Putting It Together (1 level)
Capstone (1 level)
infoStep 1 of 7
Module 10 taught you `+ - * /`. A function is a formula someone else already built for you.
`=SUM(B2:B6)` adds up every number in B2 to B6 — the same answer as typing `=B2+B3+B4+B5+B6`, but you never have to list every cell, and it still works if you add a sixth row later. This is the single biggest reason real spreadsheets use functions instead of long addition chains.
Snack bar week
A1
fx
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Day | Sales (UGX) | ||||
| 2 | Monday | 24000 | ||||
| 3 | Tuesday | 31000 | ||||
| 4 | Wednesday | 18000 | ||||
| 5 | Thursday | 27000 | ||||
| 6 | Friday | 35000 | ||||
| 7 | ||||||
| 8 | Week total | |||||
| 9 | ||||||
| 10 |
Click a cell, then type. Enter moves down a row; Tab moves right a column. Type =A1+B1 style formulas straight into a cell or the formula bar above. Ctrl+C copies a cell; select a range and Ctrl+V pastes into every cell in it.