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


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.


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.


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

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

    With the use of macros Mr. Brown will be able to quickly and easily change seating arrangements by highlighting the appropriate cells and pressing the macro button which will allow them to change automatically without typing c, a or n in manually.

  2. For this task I needed to type. I needed to type because then I ...

    I think that Microsoft Excel and Publisher could do this task . Copy and paste For this task I need to copy and paste the fonts when I'm editing the database and moving things around to get every thing

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

    The formula for the function is shown above. Conditional formatting was once again used here as well to highlight those cells related to pharmacists as they are not required to complete training modules. =IF(J22<4615,"0",IF(J22<19020,"0.10",IF(J22<29500,"0.22","0.40"))) Above is another area of the system where I have used the nested IF Function.

  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.

    click the section that you want to so to and it is quite self explanatory what to do and how to make your way through the Multimedia Presentation. 5. Improvements to the multimedia website/product to help meet the product's aims.

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

    Robert Price Bought This is how much my user buys it for from another distributor The distributor who the end user buys the products from. Expenditure amount/ Cost Cost of expenditure The companies that supply each of the utilities. E.g.

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