Implementation. In this task I would use Microsoft Office Excel as it would help Hickley Travel to work out the number of passenger and the cost of passenger.

1. First I need to open topics folder

Then I need to go in the ict folder

Then I need to on in 2011 assessment folder

Then I need to open 2011 data files

Then I need open the excel file of passenger for Cotswold and scorpion theme park

This excel file would appear but now I need to save in my folder

I needed to go on file sae as then put  I  the desired file and I also changed the type from CVS file to Microsoft excel 97-Excel 2003 &5.0/95 workbook (*.xls)

Now I need to crate a new heading in Q1 which would be total

Now I have added a heading, now I need to insert  in a formula so I need to go in  insert the go on

function

This screen would appear I need to choose sum

Then another screen would appear so I need to select B2 P2

So I need to click the button  

 so this type screen would appear

The I need to click and drag from B2 to P2 so that I could get the total Then I need to press enter the press ok

 

The total appear which is 32

I added one more heading Total passenger 4

I added in  a formula in Q4 which is =SUM (Q2:Q3)

Now the answer is  32 but I need to calculate the number of children in Q3

Now I added a formula in Q3 which is =SUM(B3:P3) to calculate the number of children

My answer is 16 So the number total of passenger changed to 48

I increased the width of the row now I am going to insert a heading in P6

I put a new heading passenger quota now I need to insert a formula in Q6

I inserted the a formula in Q6  WHICH is =Q3/2+Q2

 

I got the passenger quota=40

I went in the formula auditing mode to show my formula I used

 

This is my print preview