• 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. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    From the toolbar, I selected the combo box icon (shown below) and dragged it across the desired position. I then right-clicked on the box and selected 'Format Control' to display a dialogue box and in the 'Input Range', I highlighted the list of employee numbers.

  2. AQA GCSE ICT Specification B

    Combo Box: Allows a limited selection of responses available to the user. It is quicker to find the chosen answer and prevents the user typing invalid data. Useful in details such as Colour and Payment type. More convenient than a list box as it takes up less room on the

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

    Also the use of cell protection on the cells which contain the data for the calculations, such as the prices for the various shows, are protected with cell protection which prevents the user from incorrectly editing the data inside the cells.

  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. computerised spreadsheet for pupil attendance data

    store data in an easy to read format and cannot do calculations, this is not what I need so I will not be using it, although it is a very big multi purpose system. Database packages include Lotus123 and Microsoft Works, effective at storing information in fields (row and column format)

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

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

    Another problem he faces is modelling his finances. He is not able to predict what kind of difference making a change to the retail price will have on the income and the profit. If he wants to do this he has to calculate and re-calculate, he also needs to re-check

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

    To start my model I would have to find out the cost of the more common brands sold by the shop and then find out the prices of the different finishes. To get all this information I would have to ask the shop owner.

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