Spreadsheet Resources Note: If you are using a dail-up modem these files may take some time to download. The links provide a short Quicktime movie on |
|
| naming cells and entering text into cells in an Excel spreadsheet. | |
| entering numbers into cells in an Excel spreadsheet. | |
| entering a formula into a cell and copying the formula down to other cells in an Excel spreadsheet. | |
| entering a function into a cell and copying the function down to other cells in an Excel spreadsheet. The concept of a range of cells is also discussed. | |
| formatting (bold, decimal places and centering) cells in an Excel spreadsheet. | |
| entering functions into cells and copying functions across to other cells in an Excel spreadsheet. | |
| adding colour to cells in an Excel spreadsheet. | |
| sorting students on their average mark. | |
| saving and printing your spreadsheet. Printing formulas and changing column width is also discussed. | |
| entering more complex formulas into cells in a spreadsheet. Order of operations is discussed. | |
| relative and absolute references in formulas. | |
| the importance of using correct formulas. | |
| using a spreadsheet to model a situation and making changes to simulate/play 'what-if' activities. | |