Below, I have written, in simple terms, how you can apply formula to your spread-sheets and how you can conditionally format them:
Formula
To multiply cells:
=click
cell*click cell Press Enter
To add cells:
=SUM(highlight
cells)
Press Enter
To copy the formula to other cells,
click and drag the tiny square that is on the bottom right of the highlighted
cell and drag it to the cells where you want the same formula
Remember:
-
Don’t change the units in the cell from pounds to pence. Choose one and stick to it!
- Put the chosen unit in the column title, not in each cell
Conditional Formatting
Highlight the cells that you would like to apply a rule to
Click on ‘Conditional Formatting’
Click ‘Highlight Cell Rules’
Choose the appropriate rule
Format and choose how the cell should change colour if it ‘meets’ your rule
TASK
Create a spread-sheet which uses all of the formulae and some conditional formatting. You have two lessons to complete this and it can be any topic of your choice. Here are some ideas:
Football player analysis (give each player a mark out of ten for every game)
Ultimate Team style spread-sheet
Game/Song review out of ten from different magazines or websites
Car/Bike statistics
