Task 2: Design, create and use a business spreadsheet
Assessment Objective 5 is assessed in this task
In this task you will design, create and use a spreadsheet appropriate to your work for the Year 8 trip. You will need to use appropriate information that you found in Task 1 when completing this task. Your spreadsheet should present the costs involved for at least two of the different trip options and display a warning message if the price per pupil goes over £15. The final costs per pupil should be rounded up to the nearest pound.
Use the activities below to produce evidence for your assignment.
For Pass level you need to complete parts A, B, C, D, E and F of this task.
For example your spreadsheet could include:
For Merit level you must use several different formulas including at least one function and one arithmetic operator.
For Distinction level you must use several different formulas including at least two different functions and two different arithmetic operators. .
You might, for example, format: