spreadsheets

spreadsheets

1. Absolute cell reference is when you use the $ key to stick a part of the formular

2. Functions must always start with =

3. The content of a cell can be formatted e.g. colour change

4. Replicating cells is when you drag down the mouse pointer and the content of the cell will be copied down

5. Using graphs and charts allows us to notice patterns

6. A cell reference is eg. B3. It is how we identify cells

7. What if calculations allow you to make test predictions

8. Automatic recalculation is when every time the content of a cell is changed, this data will change in the formula too instead of having to re-write it all

9. Functions are used in calculations

10. data is any value or text in a cell