This 14 page spreadsheet activity resource is suitable for Functional Skills ICT - Numerical Data and Graphs and covers:
Theory sheets providing explanations and examples of arithmetical formulas, referencing and BODMAS and also functions such as SUM and also IF and VLookup/HLookup statements, along with creating comparison bar charts.
Handy 'how to do it' sheets giving practical help for Excel 2010 - formulas, functions, headers & footers, layout, editing, importing and also creating charts and graphs from two data sets
Questions (with answers) to test knowledge and understanding
Practical 'hands on' exercises using formulas and functions and creating comparison bar charts, line graphs and scatter graphs