Wednesday, 3 November 2010

Spreadsheets

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

No comments:

Post a Comment