Review Two

You've seen a spreadsheet on chocolate addiction. The finished version looked like this:

An Excel 2007 Spreadsheet

Time now to reveal your addiction! Create a spreadsheet like the one above, but substitute Chocolate Addiction for something else. Examples might be: smoking, drinking, eating out, clothes, makeup - in fact, anything that someone might be spending too much money on. (It doesn't have to be you doing the spending: it can be entirely made up.)

Your spreadsheet should include the following:

  • Daily totals
  • Individual totals
  • Weekly total
  • Columns for Prices
  • Columns for Number and Cost
  • Weekly cost
  • Annual cost

You can format the spreadsheet any way you like. The colour scheme is entirely up to you. Just make sure that your spreadsheet is easy to follow.

 

In the next section, we'll make start on Charts in Excel. Before that, you'll learn how to sort data.