SPREADSHEETS

SPREADSHEETS

1. The three main parts

   • Data: Which is text or numbers that you just type in. It has no meaning
   • Labels: Are headings that you add that give and explanation to the data
   • Formulas: Are automatic calculations that you tell the spreadsheet to do

2. Functions

   • =SUM(A1:E1)
     • This SUM function is used to add up the cell A1,E1 and everythinhg in between.
   • =AVERAGE(A1:E1)
     • AVERAGE will find the average of cells A1,E1 and everything in between
   • =If(A1>49."Pass","fail")
     • IF functions made decisions. If the test result is higher than 49, you will "pass" Otherwise the result will "fail"
   • MIN(A1:E1)
     • This finds smallest number between A1 and E1
   • MAX(A1:E1)
     • This finds the largest number between cells A1 and E1

3. Formula

   • =A1+B1
     • The plus sign adds up cells A1 and B1
   • =A2-B2
     • The minus sign takes away cell B2 from A2
   • A3*B3
     • The asterisk sign multiplies A3 by B3
   • A4/B4
     • The forward slash divides A4 by B4

4. Formatting techniques

   • Coloured borders or lines can be added to the edge of each cell
   • Cells can be formatted according to their data types
   • Cells can be merged or combined together
   • The font can be changed
   • Background fill can change the colour of the cells

Images and files in the map