Spreadsheet software

Spreadsheet software

1. Components of spreadsheets

   • Labels- 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 spreadsheet
   • Formulas- are used to perform calculations on the cell contents

2. Functions

   • A function is a specialized calculation that the spreadsheet software has memorized
   • Average- for example, to find the average of the numbers in a range of cells from A3 to A10 you would use =Average(A3:A10)
   • SUM= SUM(E3:P3) displays the total of all the cells from cells E3 TO P3 inclosive

3. Relative referencing

   • This will move when cells are copied

4. Absolute referencing

   • This doesnt move when cells are copied