This resource covers cells, ranges and workbooks, writing formulas, the functions SUM, AVERAGE, MAX, MIN, COUNT and IF, relative and absolute cell references, building and testing a model with what-if analysis, and validation and error checking. Pupils build a school trip budget and complete an error hunt. A misconceptions slide covers typed answers, missing dollar signs and wrong ranges. Two worked examples and challenge questions are included. This is a ready-to-teach PowerPoint scaffold for an hour-long lesson on this topic.
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.
£3.00