Saika Bi Candidate Number: 4037 Centre Number: 20243
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
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 type Number as numbers are included.
To work out the cost of labour, a formula was used. This was =SUM (B2*C2). Then, for the rest ...
This is a preview of the whole essay
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 type Number as numbers are included.
To work out the cost of labour, a formula was used. This was =SUM (B2*C2). Then, for the rest of the column to be worked out, drag down the fill handle from D5 to D9 and the results should automatically be worked out.
To work out the total bill another formula was used. 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. Columns E, I and J contain a format of number this information is about the size of the property.
Cell P2 contains a formula =D2*1% which works out the stamp duty for the first house this is done for each house using the same formula but obviously changing as they go down the columns. To work out cell Q2 the following formula is entered (=SUM (M2:P2)) this adds up everything in the blue section for that row which is all the fees and duty for the house, this also needs to be done for each house. The final formula used in this spread sheet is to work out total cost of the property this is by adding the 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
