Intro
Objectives
Use a spreadsheet to model outcomes.
Use functions including Max, Min and If.
Name a cell.
Sort data into different sequences.
Try out different ‘What if’ scenarios to achieve a goal.
Display formulae in a spreadsheet.
Resources
Slides
Spreadsheet modelling L3 'What if' scenarios.pptx
4mb
Worksheet
Spreadsheet Modelling Worksheet 3 'What if' scenarios.docx
Homework
Spreadsheet modelling Homework 3.docx
Spreadsheet for Homework 3 question1.xlsx