relative cell referencing:not using the $ in cell references so
the cell does change when a formula is copied into another cell
how to format a spreadsheet:including widen columns,change
the colour,size,embolden,underline,borders etc
all the cells going down a spreadsheet
in a line:labelled with a letter
all the cells going across a spreadsheet
in a line:labelled with a number
individual boxes in a spreadsheet
where you can enter data
including rules,variables and labels
(a.k.a formulae,numbers and text
changing the variables in a
model to test different situations
a representation of a real life
situation or thing
what a formula is
an automatic calculation
in a spreadsheet
cell reference
i.e A1,C4 etc
Formula to add/subtract the
values of cells together
formula to multiply values together
formula to divide values
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
absolute cell referencing:using the$to make the cell reference
stay the same when a formula is copied into another cell
different value formats including:currency,date,text decimals etc
what "what if" questions are in a spreadsheet model