Spreadsheet cells, formulas and relative copies
This is a fixed question bank. Later sets may repeat these questions
This complete synthetic spreadsheet records counts of completed items. The letter at the top identifies a column and the number at the left identifies a spreadsheet row
| Row | A | B | C |
|---|---|---|---|
| 1 | Team | Monday | Tuesday |
| 2 | Cedar | 3 | 2 |
| 3 | Elm | 5 | 6 |
| 4 | Fir | 2 | 1 |
| 5 | Ash | 4 | 4 |
A reference such as B2 means the value in column B, row 2. Row 1 contains text headings; the numeric data are in rows 2 to 5
A formula starts with =. The + operator adds the referenced values; SUM(first:last) adds every cell in the rectangular range, including both endpoints
Evaluate this formula without changing any input cell: =SUM(C3:C5)