What is the difference between relative and absolute referencing?
It is usual to create your website on your own machine and then upload it to your web space. If this is the case any links or graphics that you have created within the site will be referenced absolutely – this means that the path of the file is specific to where the image is located on your machine: eg 
, If your graphics are referenced in this way, links to your graphics will not work when you upload the site to your web space, causing your site to contain broken links. To avoid this situation, reference your graphics relatively, which will make your web fully portable. For example, if you include a graphic located in the same directory as your web page, then the path would look something like 
if it is in a directory called graphics,it would be 
. Either way the file would not be linked absolutely to the C drive of your machine.
A relatively referenced cell will adjust the cell reference relative to where a formula is copied to, i.e. if a formula is copied across two columns the cell reference will adjust by two columns. An absolutely referenced cell will remain the same no matter where the formula is copied to. • How would you write a formula to add cells A1 to C1 and divide the answer by D1? =(A1+C1)/D1 • In which order would the following calculation be performed and why? =C5+D5*E5-F5/G5 D5*E5, F5/G5, +C5, -the value of F5/G5. Multiplication and division are always performed before addition and subtraction. • How do you insert a page break? Select Insert/Page Break from the menu bar. • Name three types of data that can be entered into a spreadsheet. Text, numerics, formulae • List three ergonomic features you would use when interacting with a computer. Chair height, desk height, monitor brightness, contrast etc, foot stool, lighting, copy holder, posture. • What is a cell range? Briefly explain and give an
