• 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. The aim of my project is to make the task of the allocation of ...

    To see if the spreadsheet will allow the user to change pricing without causing any damage we will change all numbers, including: pricing of seating, cost of shows, projected profits % and pricing of confectionary goods to zero. This will also tell us if all spreadsheet formulas function correctly.

  2. Database Hajj&Umrah travel agency

    Interview (End User) Me: So Mr. Yusuf you tell me you have many problems with the current booking system in your company. Mr. Yusuf: Yes this is correct, and due to this I am losing many customers. They are getting deeply frustrated by our errors.

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

    I included IF functions, filters, subtraction and charts to display this data by working between different sheets. I have explained how to complete each of these functions and working between sheets in previous steps, so I just followed the steps stated above to include them into the worksheet.

  2. Evaluation of Microsoft Excel

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

  1. AQA GCSE ICT Specification B

    Data security details The new system will be encrypted, backed up and password protected. Physical security Sprinklers in the building to protect from fire and a security alarm. Deliverables A disc containing the program and a user guide Operational Scenario We would like a simple layout, easy to get used to, with clear font.

  2. 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.

  1. Spreadsheet for a basketball company

    3 Calculate the company's total income and total expenditure for each match The total income or expenditure is calculated by adding all the categories of the particulars that make up the income or expenditure for e.g. =SUM(E8+E16+E23+F31). 4 Calculate Profit The formula =SUM(C4-C5)

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

    later we would instantly store it on disk, to ensure it safety and its existence in our files and that we have a second hard copy. Once the description of item has been keyed in, due to the computers high level of intelligence, it will automatically calculate the amount due, and the heaviness of the VAT.

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