Topic 10

Topic 10

1. A spread sheet application such as exel can store all its data in a single file.

   • The 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 workbook

3. A cell reference always starts with a letter and ends with a number e.g. A5 or H28

4. A range of cells is a set of cells in a row or column

5. Data entered into cells can be different data types e.g. text, number, currency, date, etc.

6. Each cell can contain, labels, data and formulas and functions

7. Formulas must start with an =

8. Formulas perform calculations on cell content

9. Formulas appear in the formula bar

10. The result of the formula is automatically recalculated every time the data on a spreadsheet changes

11. Functions must start with an =

12. Functions are part of spreadsheet software

13. Function names describe what a function can do e.g. SUM, COUNT, AVERAGE, MIN, MAX, IF

14. The content of a cell can be formatted

15. You can format the font style, size, colour, border style, alignment, cell colour

16. You can use graphs and charts

17. Using graphs and charts allows us to notice patterns and trends more easily

18. A relative cell reference is when you drag down a formula the cell reference is changed. This is because its uses the relative address of the cells based on their position on the worksheet

19. An absolute cell reference is when you use the $ character in front of the letter and number that are required to stay the same (glued)

20. benefits of using a spreadsheet

    • Automatic recalculation
    • Accurate calculations
    • Graphs/Charts
    • Replication

21. allow you to make and test predictions

22. allow you to see what would happen if certain figures were changed