• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  • Level: GCSE
  • Subject: ICT
  • Word count: 422

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.

Extracts from this document...

Introduction

Implantation task 2 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. I need to set up a system that would count the number to add up the number of adults and children separately and give the total number of passenger separately. I would do so as the company could charge the price of adults full and the price of children half of it. ...read more.

Middle

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 ...read more.

Conclusion

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 ?? ?? ?? ?? Zaid Tariq ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Evaluation of Microsoft Excel

    So basically it is there to prevent any errors occurring in the spreadsheet, it keeps figures in range.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    I also added text on hyperlinks to reports, charts and subjects, as there was no relevant image which would make the user understand where the hyperlink took them, so I decided to use text to tell them instead. I did this by, right clicking and selecting "text," and inserted my

  1. AQA GCSE ICT Specification B

    Evaluation Criteria Criterion Number Criterion Justification 1. On opening, the main menu should appear, and the navigation panel should not. The user needs to use the menu to navigate, and giving access to the navigation panel could harm the system.

  2. Project 1a. ICT

    By using cartoons like these you can see that the age range is going to be designed for the younger generation. If I was devising this story booklet for someone in my generation or older I would take the opportunity to right a fare bit more as our vocabulary and

  1. A02 Implementation Commentary

    This is sometimes called 'non-volatile memory'. * Random Access Memory (RAM) - this is erased when the power supply is switched off i.e. turning the computer off will mean the document will not be there when it is turned back on again. This is sometimes called 'volatile' memory.

  2. Spreadsheet for a basketball company

    In more detail D5 in the expenditure page is the cell that contains the number bought of an item and D5 in the income page is the cell that contains the number sold of that particular item. 7 Calculating the remaining stock in the expenditure page The following formula has

  1. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    This becomes useful when there is a lot of data that requires to be saved, but will not fit on a single disk but on numerous floppy disks. The good thing about the backup drive is that it is not too expensive, as the disks usually cost around �5 and the backup disk drive around �100.

  2. GNVQ intermediate ict unit 4

    chart was because it's an easy way to compare the results also it's easy to read and understand them. Why I chose this line graph, was because it's a good way to show the progress of each of the teams/ area.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work