Skip to main content

Posts

Showing posts with the label budget
Project Four - A Budget spreadsheet - OK, let’s put all our arithmetical operator knowledge together and construct a spreadsheet. The spreadsheet you’re going to construct is a Budget spreadsheet. Here’s the scenario. There is a small town called Evercrease. Last year the council had a budget of half a million pounds to spend. They overspent by 69 thousand pounds, which the citizens of Evercrease objected to most strongly. So strongly in fact that they got rid of the entire council. Now they need to appoint somebody else to manage the budget. They have asked you to do the job. Have a look at last year’s budget: Budget Spreadsheet Image The final budget figure is in cell B33 and reads minus £69 000. Your job is to make a new budget spreadsheet, ensuring that you do not have a minus figure in cell B33. Your first job is to recreate the budget spreadsheet exactly as it is in the picture. Once you have a spreadsheet exactly like the one in the image, along with the for...