Spreadsheets 4

Gap-fill exercise

Fill in all the gaps, then press "Check" to check your answers. Use the "Hint" button to get a free letter if an answer is giving you trouble.

   absolute      cell      charts      columns      format      formula      formulas      graphs      insert      numbers      password      pie      reference      relative      replication      rows      spreadsheet      text   
1. A is a general purpose package that is mostly used for calculations.

2. A spreadsheet is divided into and .

3. Each on a spreadsheet can be identified by its cell , e.g. A5.

4. Cells can contain , or .

5. You can force a spreadsheet to do a calculation by putting a into a cell.

6. To change the way that the contents of a cell look, you change its .

7. If necessary, you can extra rows or columns into a spreadsheet.

8. Copying a formula from one cell to other cells is called .

9. You can create bar , line or charts with your data in a spreadsheet.

10. In a formula, if a reference to a cell is fixed, then this is called referencing.

11. In a formula, if a reference to a cell is relative to its present position, then this is called referencing.

12. Cells of a spreadsheet can be -protected, to prevent them being changed.