Topic 10-Spreadsheets

Topic 10-Spreadsheets

1. Spreadsheet- a spreadsheet such as exel can store all data in a single file. This file is called a workbook.

2. A workbook is made up of one or more worksheets. A worksheet is a single tab in the spreadsheet worksheet

3. Cells

   • A cell reference always starts with a letter and end with a number, A5
   • Each cell can contain
     • labels- any text in a cell describing data in a row or column
     • Data- any values that are entered for the use of a calculation
     • Formulas and functions-mathematical calculations carried out automatically

4. Formulas

   • must start with an =
   • Perform calculations on cell contents
   • Appear in formula bar
   • Automatic recalculation

5. Functions

   • Must start with an =
   • part of spreadsheet software which are specialised

6. Formatting

   • The format of a cell can be formatted: font style, size, colour, border style etc
   • Cells are often formatted to reflect data that is held within them, e.g currency

7. Replicating cells- When you position the mouse pointer in the bottom right hand corner of the cell and drag down or across the spreadsheet tries to respond intelligently. If there is a formula in the cell, the spreadsheet tries to adjust it as it goes down the page to fit in with the new position and the cells being referred to.

8. Graphs and Charts

   • Using charts/graphs allows us to notice patterns & trends more easily
   • Specific data can be selected on a spreadsheet and a chart/graph of this data can be created.

9. Cell referencing

   • Specific data can be selected on a spreadsheet and a chart/graph of this data can be created.

10. Relative cell referencing

    • Relative cell references is when a cell is used in a formula and the formula is copied to a new cell reference (address) , the cell references (cell address) changes to take account of the formula’s new position.

11. Absolute cell references

    • Absolute cell referencing is where a reference to a cell used in a formula where, when the formula is copied to a new cell reference (cell address), the cell reference (cell address) does not change. It is glued in place by the $ character.