Functional Skills ICT Spreadsheets and Graphs
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
Save for later
  • FS_SS_L2.pdf

About this resource


Created: Dec 6, 2016

Updated: Feb 22, 2018

Whole lesson

pdf, 1 MB


Report a problem

Tes Paid License

How can I re-use this?