• 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

    form, allowing all details to be condensed into a simple, clear, user-friendly display. Command Button: Performs a single function. Very simple, as it provides no room for error. Each button is clearly labelled and defined. Useful for opening and printing forms and receipts.

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

  1. Reviewing different multimedia presentations.

    of course different colours in the body parts as they are the actual colour that the body part would be. The amount of text and other information In this Multimedia Presentation I think that the amount of text is a perfect amount as when you are about to put a

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

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

  2. ICT BTEC UNIT 2 - REPORT

    There are several good reasons for why they're both good but the Dell Precision T7400 is more high spec and that's what makes it stand out in quality and quantity. The hard drives are tremendously different in size the Dell Precision T7400 has a 750GB hard drive where as the

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

    This will help me decide what my spreadsheet would require. A copy of this questionnaire, along with its answers from the manager, is on the page overleaf. TASK B: Spreadsheet coursework page 4 The questionnaires helped me with understanding the employees' needs.

  2. implementation report

    writing as the main page so that the system would look professional; I also added the same pictures as the main page to make it look even more professional Now that the layout of the form had been created I had to add command buttons to do specific jobs to

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