INF1060‎ > ‎

Assignment 4b

  • Create a spreadsheet from the following Column Headers: Math mark, Geography mark, the Average and the Total Mark.
  • You will need to create a formula for the "Total Mark" and the "Average Mark" column.
  • Hint: Use the Functions tool in Excel to insert functions such as Average and Summary.
  • Your data should look exactly like the spreadsheet table below.
  • Now create a chart from the data you just entered into your spreadsheet
  • Your chart should look similar to the one below when you are finished.
  • Now print out your data and chart. Don't forget to setup your Headers up before you print.