Coursework.Info - Inspiration in an Instant

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

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. The columns B, D, E, F and G contain the data type of currency set as they hold the charge for each hour, the cost of labour, cost of materials, call out charge and the total bill. Column A has a data type of Text as the customer names are stated and Column C is set as data...

Get instant access

• Instant, unlimited access to our documents in full
• Swap your work for free access, or pay £4.99
• To see the full version of this document and 149,410 others