Spreadsheets

Spreadsheets

1. Labels

   • Headings explaining the data 

2. Data

   • text or numbers you type in.

3. Formulas

   • Automatic calculations

4. Formula

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

5. Functions

   • More advanced calculations that the spreadsheet can do.
   • =SUM(A1:E1)
     • This Sum function is used to add up the cells A1, E1, and everything in between. Without this we would have the formula =A1+B1+C1+D1+E1
   • =AVERAGE(A1:E1)
     • AVERAGE will find the average of cells A1, E1, and everything in between.
   • =IF(A1>4,"Pass" ,"Fail")
     • IF functions make ndecisions. if the test score is larger than 49, the test result of 'pass' will be displayed. Otherwise, the result of 'Fail' will be displayed.
   • MIN(A1:E1)
     • This finds the smallest number in the range of cells A1 to E1
   • MAX(A1:E1)
     • This finds the largest number in the range of cells A1 to E1

6. Formatting Techniques

   • Borders
     • Coloured borders, or lines, can be added to the edge of each cell.
   • Data Type
     • cells can be formatted to their data type e.g. cells with money can automatically have a pound sign placed at the front by assigning a currency data type
   • Merge
     • Cells can be merged