Exercise: Excel


  • Create a series of 10 random numbers between 1 and 100 and save them in an Excel file in a column.
  • Create a graph showing the values.
  • Add a second series of 10 random numbers, add them to the Excel file as a second column next to the first one.
  • Add a 3rd colum containing the average of the first two columns.
  • Update the graph to include all 3 number serieses