Modelling with spreadsheets
A self-employed builder charges £15.00 an hour. He's constructed a spreadsheet [spreadsheet: A spreadsheet is made up of cells, rows and columns. Each cell holds a piece of numeric (numbers) or alphanumeric (text) data. Cells can also contain formulae to calculate their contents. ] to keep a record of his work but it's incomplete.
Download the builder's incomplete spreadsheet.
Download the incomplete spreadsheet on the left and perform the tasks below. To open it you will need a spreadsheet application, eg Microsoft's Excel, OpenOffice.org's Calc, Google Docs or another application that can open *.xls files.
Please note that the actual steps required to complete each tasks may differ slightly depending on the spreadsheet application you're using.
The builder has just completed some work for Jason Williams. It took him four hours and the materials cost £37.00.
The formulae to calculate the bill should be automatically inherited from the cell above.
The values stored in columns C and D are currency. Change the number category to currency so the spreadsheet recognises this.
There's a mistake in the formula used to calculate the total bill, the builder has entered his hourly rate incorrectly - correct his mistake (remember, his hourly rate is £15).
The builder wants to calculate his daily earnings, write a formula in cell D8 to do this for him. Press enter to save the changes.
The formula can be written two ways, decide which one to use:
The spreadsheet program should realise you're adding together currency and automatically change cell D8's number category to match.
Download the builder's completed spreadsheet.
Download the completed spreadsheet on the left to see how you did or to learn where you went wrong.