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

Spreadsheet Examples

Extracts from this document...

Introduction

Spreadsheet Examples Example 1 - A builders charge rate A self-employed builder uses a spreadsheet to keep a record of his daily jobs. He charges �12.00 an hour and a call-out charge if he has to do a job after 6.00pm A B C D E F G 1 Customer Charge Hours Cost of Cost of Call out Total 2 name per hour worked labour materials charge bill 3 4 5 Law �12.00 2 �24.00 �4.00 - �28.00 6 Derrick �12.00 3 �36.00 �18.00 - �54.00 7 Allen �12.00 4 �48.00 �40.00 - �88.00 8 Crowe �12.00 1 �12.00 �15.00 �15.00 �42.00 9 George �12.00 2 �24.00 �12.00 �15.00 �51.00 10 11 Daily 12 total �263.00 This example shows a spreadsheet used by a builder to keep track of his daily jobs. ...read more.

Middle

This was =SUM(D5*F5). Then, for the rest of the column to be worked out, drag down the fill handle from G5 to G9 and the results should automatically be worked out. To work out the daily total you need to use this formula: =SUM (G5+ G6+ G7+ G8+G9). Example 2 - Estate agents Someone searching for a property or an estate agent can use this spreadsheet to keep track of properties on the market. Column D, M, N, O, P, Q and R contain a format type of currency the show different prices and taxes and fees when buying a house. Columns C, F, G, H, K, L have a format of text from which C is the postcode (location of property, columns G and H contain the estate agent name and a link to the property website, and columns F, K and L contain information about the property features. ...read more.

Conclusion

total fees to the price of the house the formula entered to work out R2 is =D2+Q2, this also needs to be done for each holiday. All these formulas can be work out for every house without re-entering the formula this is by using the fill handle tool and dragging it down. The presentation of this spread sheet is simple and easy to understand, there is a gap between the heading of each row and the data this is to make the headings stand out better. Also the spreadsheet is made easy for user to read by highlighting the area were all the duties and fees are covered to divide it from the information about the actual house ?? ?? ?? ?? Saika Bi Candidate Number: 4037 Centre Number: 20243 ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Database Coursework estate agent

    To create a stylish and corporate looking database Data Input The data input will be collected by the estate agent surveying the house. It will be put into the main system and then can be accessed by all estate agents.

  2. Develop a spreadsheet application for the Ibis Hotel.

    Please can let me know as soon as possible if I could computerise your system and integrate a database into your hotel business operations. Would you please reply to me on the above address and let me know if you have accepted my accordance.

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