Spreadsheets have many uses which include creating information systems such as markbooks, salary timetables and more. It can also calculate the all the different calculations within each kind of information system by using different kinds of formulas depending on what needs to be calculated. The use of '=' sign is used in the beginning of a formula to tell the spreadsheet program that a formula is going to be used.
Relative Reference Used to tell the computer to use the same formula for one cell to be used on another cell. This can be achieved by clicking on a cell and on the bottom right corner of the cell there is a black box that can be dragged down. This tell this computer to use the name forumla
Absolute Reference Uses the symbol '$' to tell the computer to use the same cell when the code is used for another cell.
Auto Fill A feature where the a spreadsheet will automatically fill a cell depending on what is inputted into the first cell. For example one cell had 'Monday' if you drag the little black box to other cells it will add Tuesday, Wednesday etc. This can also work with numbers and months.
