Year 9 – Task 5 creating a spreadsheet model

For this task you will need to create a model using a spreadsheet (MS Excel). Use the task sheet below to help produce your model. You will need to use the data from your travel options:

Unit 1 AO5 task

To record your evidence use this evidence sheet

Evidence sheet

You may use the tutorials below to help you

Excel video tutorials