• 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. AQA GCSE ICT Specification B

    Useful for opening and printing forms and receipts. Data validation Presence Check Applies To Order ID First Name Surname Title Address 1 Address 2 Address 3 Post code Home Phone Payment Type Credit Card (If 'Payment Type' = Credit Card) Start Date End Date Evidence of Implementation Justification The company must have enough information about the customer to create, deliver and bill the customer's order correctly.

  2. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    I then went to the 'Staff Finance' sheet, highlighted all the data, returned to the 'Payroll' sheet and typed '3' because 'Surname' is located in column '3' of the 'Staff Finance' sheet. 8. Combo Box Above is the 'Payroll' sheet, which shows the use of a combo box.

  1. The aim of my project is to make the task of the allocation of ...

    of adults/children/concessions that are watching the performance, the fixed costs and their respective percentages. These will then be used in the grand total to show whether Mr. Brown has made a profit or a loss. Data collection The requirements which Mr.

  2. computerised spreadsheet for pupil attendance data

    but they cannot do complex calculations, which are needed. This type of program cannot do calculations it is unsuitable for my requirements. People like the police use databases to store information on criminals although it doesn't suit the needs of this inquiry.

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

    To format the required cells, I selected the cells I wanted then right clicked and clicked the 'format cells' button. From here, I chose Currency for most cells and had 2 decimal places and a � sign to start. To do a times of 2 cells, simply type = (Cell one * Cell two)

  2. I am going to design a spreadsheet model for a painting company which will ...

    We will also be able to act quicker and present customers with the information on the moment and they will then not get fed up and go somewhere else.

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

    the average, max, min etc providing the calculations are correct, therefore making the process easier for the teacher, as she doesn't have to change them herself. Furthermore, data can easily be formatted creating attractive, readable tables, charts or text, which is an advantage for the teacher as it allows her

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

    Each file needs to be stored for the accountant to look through, also every now and then the inspector come sin to check the invoices, and so everything needs to be in order of date and all correct. This is very risky when it is manually stored, as sometimes invoices

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