Introduction   |Word | Excel |PowerPoint |Internet and Email  
 

Task 2 - Excel

Open the Home Budget spreadsheet from here and change it to show the following things:

  • Format the months with cells of a different colour
  • Change the height and width of the cells so all the data fits properly
  • Change the cells with money in so they look like money (ie £23.00 rather than just 23)
  • Fill in the missing rows ('money spent' and 'money left over') using formulae
  • Create a bar chart showing the money left over each month

  • Make the whole thing look really attractive (for example change the colour of the bars on the bar chart to something more interesting)

Now save the sheet and attach it to an email and send it to Skills@ProvenICT.com

 

sheet