Spreadsheets

Spreadsheets

1. Three main parts

   • Data: The text or numbers you type in
   • Labels: Are headings explaining the data
   • Formulas: Are automatic calculations

2. Functions

   • =SUM(A1:E1)
     • This SUM function is used to add up the cells A1, E1, and everything in between. Without this, we would have a very long formula of =A1+B1+C1+D1+E1!
   • =AVERAGE(A1:E1)
     • Average will find the average of cells A1, E1 and everything in between
   • =IF(A1>49,"Pass","Fail"
     • IF functions make decisions. 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

Images and files in the map