• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Payments Spreadsheet task. - formulas and fomatting

Extracts from this document...

Introduction

Spreadsheet Assignment B3 1) Introduction a) Choice of application:- > The applications required in this task are Excel, Word and Internet. . The three applications are suitable because they have particular features such as excel has features like validation, conditional formatting, formatting cells which allow you to change cells into a particular function for example currency, percentage also alignment of the text , font, borders , patterns etc. These features make your spreadsheet more efficient and accurate they make it easier for you to record results with ease also to keep a record which is up to date. The application Word is suitable because it has good features like word art, word count, spell check etc. These features are necessary to write report to make sure no spelling mistakes, certain amount of words (no overwriting), good titles and right structured into paragraphs, and most of all the feature of re-reading through your work. The internet explorer is needed to obtain data and this would require website and search engines where you need to search and collect websites from where data was obtained. All these applications are required in the two tasks. ...read more.

Middle

These three websites were used throughout my search to get the data. These websites were used to search the adult price and was later than calculated into the child's price, by working out 80% of it. This price enabled me to calculate all the other costs, averages throughout the spreadsheet. The data attained is located at the end of the report, showing all the prices of flights which I have received from the websites that I used during this assignment. b) Description of formula used:- There are three types of formula used in this spreadsheet one of them were used to calculate the total cost for 5 staff and 50 children, the other was used to workout the average cost per pupil and finally a formula was used to calculate the cost of per child. For the total cost you simply multiply the number of people by the cost of the ticket. So for the total cost for children you multiply the cost per child by 50 because there are 50 children and this will give you the total cost for children and the same goes for total cost of 5 staff but instead of multiplying by 50 you multiply by 5. ...read more.

Conclusion

Once you have selected the type of format you want to use then click ok and to test if your conditional formatting is working then type any invalid data which exceeds the type data your have set in those cells, and you will be able to see that conditional formatting highlights that data into that colour. Protection:- o The way to protect sheet is to lock all cells by clicking on the top left hand corner which is allocated before the title of the column A, it is a point where the rows and column start. Then select cells which you want to protect and right click this will take you to a couple of options and where you will see and option called format cells, click on that and go on the last tab which says Protection, unlock the cells and click ok. After go on the title at the top which says tool click and you will see a option called protection then click again and go on protect sheet heading, after that you will have two options selected but unselect the option which says 'select locked cells' and click ok with only one option left which is 'select unlocked cells' and finally click ok. Now you have your spreadsheet protected. ?? ?? ?? ?? ...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 ...

    Cell formatting Cell formatting has been used for the table showing where the people are sitting. In the event of a child the cell it is in will turn light blue, in the event of an adult, dark blue and for concession, green.

  2. Flight Spreadsheet Report. The task we had to complete was to find prices of ...

    into the formula bar. The same format can be used for other types of mathematics but instead, replace the * with the appropriate sign.

  1. Appropriate Software To do this project I am going to use excel because ...

    The store manager Calculations Profit: This will be calculated by subtracting the expenditure for each individual product from the income for each individual product. This is the money made from each product over the past week. Total Profit: This will be calculated by subtracting the total expenditure form the total income.

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

    Due to the advantages of Microsoft Excel, I believed that it was the correct package to use considering my task provides and my target audience. Step 4 After deciding what package I was going to create the grade book in, I started to create my spreadsheet.

  1. AQA GCSE ICT Specification B

    - - CustomerFirstName Table 1 - Yes - - - Date Table 1 - Yes - - - CustomerSurname Table 1 - Yes - - - CustomerTitle Table 1 - Yes - - - Address1 Table 1 - Yes - - - Address2 Table 1 - Yes - - -

  2. ICT BTEC UNIT 2 - REPORT

    system is using all the minimum system requirements which could cause the computer to be slow and tedious. The top computer meets the requirements and then exceeds them this will make the computer a very fast system but comes at a considerably higher price at �8,395 however having said that

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

    by asking the employees that presently work in CNE and other organisations to criticise it, so that I can work on their statements, and base my improved spreadsheet on their comments, and my instincts. I will hope to evaluate my coursework by handing out these questionnaires to all the employees and to the manager to receive their opinion.

  2. implementation report

    to choose what style I would like the report to be, I chose the same style as the main page as this would make the database look more professional and appealing. Appendix 15 Appendix 15 asked me to name the form so that it would make it easier for me

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