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
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
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£5.00