ICT

ICT

1. Spreadsheet software

   • Benefits of using spreadsheets
     • Can perform 'what if' investigations
     • Automatic recalculation
     • Accurate calculation
     • Easy to produce graphs and charts
   • Components of spreadsheets
     • Label- are used for titles,headings,names and for identifying rows or columns of data
     • Data- are the values (text or numbers) that you enter into the spreadsheets.Meaningless
     • Formula- are used to perform calculations in a cell
   • Functions- specialised calculations that the spreadsheet has memorised
     • Average- To find the average of the numbers in a range of cells from A3 to A10 , =average(A3:A10)
     • Sum- =sum(E3:P3) displays the total of a cell from E3:P3
   • Cell referecing