What are spreadsheets used for - Calculations!
What makes up a spreadsheet - Cell
What is a vertical run of cells called? - Column
What is a horizontal run of cells called? - Row
What do we call (A1:D9) - Range of Cells
What three things can go in a Cell? - Number, Text and Formula
Spreadsheets allow us to replicate formulas, What does Replicate mean - Copying!
5 functions in spreadsheets
= average()
= sum()
= min()
= max()
= if(B2 >= 18, "Go Dancing", "away hame")
= if(b2 >= 35, "Hit the Overs, old git", if(b2 >=18, "Hit the dancing", "Away to unders"))
There are two types of Replication ($$$)
$$$ - Absolute - formula DOES NOT change!
No dollars - Relative - formula changes to suit the new cells
