Tuesday, 2 November 2010

Spreadsheets

Spreadsheets is an example of a GPP which is used for calculations

A spreadsheet is made up of small boxes called cells

We can insert 3 things into these - Number, Formulas and Text

A Horizontal "Range" of cells is called a Row

A Vertical "Range" of cells is called a Column

5 functions which we can enter into a cell are

= average
= max
= min
= sum
= IF!

We can replicate formulas into other cells - replicate means COPY!

Two types of replication are Relative Referencing and Absolute Referencing!

No comments:

Post a Comment