- 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