Pages

Monday 3 October 2011

cs101 assignment no 5 fall 2007


Assignment

You have to make an Excel sheet, similar to the one provided in the snapshot at the end of the document. Following things ought to be part of your solution:

  • Enter the provided marks in the sheet, and then calculate the Total marks using Sum function provided in Excel or use a formula to calculate the Total marks. You will not get any marks if you entered these two values manually. Also draw borders around the values entered in the sheet. (Marks 7)
  • Make a graph of these marks using Column Chart, as shown in the snapshot. The graph should have a title named Assignments’ Marks and the x-axis and y-axis should be labeled Assignments and Marks respectively. (Marks 8)