Elements of a spreadsheet
A table consists of cells at the crossing of rows and columns; each cell’s address is made from the column letter and row number (B3, AZ105). The selected cell is called the current cell. A block (range) of cells is written with two opposite corner addresses: C2:D4 means cells C2, C3, C4, D2, D3, D4. A cell can contain text, a number, a date, a time, a formula or a function; a formula always begins with “=” (=A1+7*B2). If a number does not fit, ##### is shown – widen the column. To edit, select the cell and press F2; to clear, press Delete; Alt+Enter starts a new line inside a cell; formatting (font, colour, border, number type) is in the Ctrl+1 window. A reference is the use of another cell’s address in a formula. A relative reference changes when copied: copying =A4+C2 from B5 to B6 gives =A5+C3. In an absolute reference the $ sign fixes the address: $B$4 never changes; in $B4 the column is fixed, in B$4 the row. The F4 key switches the reference type while editing. A cell or block can be given a name (in the Name Box) and the name used in formulas instead of the address.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 1 | |||
| 2 | 2 | |||
| 3 | 15 | |||
| 4 |
In class a pupil gave their seat exactly as “third row, second desk”. With such an address nobody was confused and the teacher found it at once.
Mapmakers, accountants and programmers find a place by an address or coordinates.
Draw a grid in your notebook with columns A, B, C and rows 1, 2, 3, place three small items on it and write their addresses.
| Cell | Formula |
|---|---|
| C2 | =B1+$D$2 |
| E5 | =D4+$D$2 |
| Cell | Formula |
|---|---|
| C3 | =B$2*$A3 |
| E6 | =D$2*$A6 |
“Cell battle”: pairs find hidden addresses in a table (for example “column 3, row 5” – C5) and then give each other formula-copying puzzles.