AICT 1 15F‎ > ‎Spreadsheets‎ > ‎

Lesson 2

  1. You are the proprietor of a pie shop. You are going to create a dataset for sales of your 5 types of pies, from Monday to Saturday. The dates will be listed on top, and the pies on the side.
  2. Label your rows and columns.
  3. In a column after your Saturday entries, create a formula to add up your weekly sales for that kind of pie. Make sure you've labelled that column.
  4. In a row below your types of pie, create a formula for each day to add up the total pie sales for each day.
  5. Create a pie chart with appropriate labels to show your pie sales for the week.