1.1.1 The 3 main types of data in a
spreadsheet model
1.1.1.1 cells
1.1.1.1.1 rows
1.1.1.1.1.1 columns
1.1.1.1.1.1.1 relative cell referencing:not using the $ in cell references so
the cell does change when a formula is copied into another cell
1.1.1.1.1.1.1.1 how to format a spreadsheet:including widen columns,change
the colour,size,embolden,underline,borders etc
1.1.1.1.1.1.2 all the cells going down a spreadsheet
in a line:labelled with a letter
1.1.1.1.1.2 all the cells going across a spreadsheet
in a line:labelled with a number
1.1.1.1.2 individual boxes in a spreadsheet
where you can enter data
1.1.1.2 including rules,variables and labels
(a.k.a formulae,numbers and text
1.1.2 changing the variables in a
model to test different situations
1.2 a representation of a real life
situation or thing
1.2.1 what a formula is
1.2.1.1 an automatic calculation
in a spreadsheet
1.2.1.1.1 cell reference
1.2.1.1.1.1 i.e A1,C4 etc
1.2.1.1.1.1.1 Formula to add/subtract the
values of cells together
1.2.1.1.1.1.1.1 formula to multiply values together
1.2.1.1.1.1.1.1.1 formula to divide values
1.2.1.1.1.1.1.1.1.1 how the results of formula change when another cell value is changed:you
should be able to predict what will happen in a spreadsheet when a variable
is changed.e.g if the price of an item goes up... the total income will go up by
1.2.1.1.1.1.1.1.1.1.1 absolute cell referencing:using the$to make the cell reference
stay the same when a formula is copied into another cell
2 different value formats including:currency,date,text decimals etc
2.1 what "what if" questions are in a spreadsheet model