Upload Instructions
Please view the assignment submission process document provided to you by the Virtual University to upload the assignment.
Rules for Marking
Please note that your assignment will not be graded if:
• It is submitted after due date
• The file you upload does not open
• The file you uploaded is copied from some one else
• Submit only Excel file with extension .xls , no other file like Notepad or word file should be submitted.
Objective
This assignment has been designed to enable you to draw graphs and use functions in MS Excel.
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)
Please view the assignment submission process document provided to you by the Virtual University to upload the assignment.
Rules for Marking
Please note that your assignment will not be graded if:
• It is submitted after due date
• The file you upload does not open
• The file you uploaded is copied from some one else
• Submit only Excel file with extension .xls , no other file like Notepad or word file should be submitted.
Objective
This assignment has been designed to enable you to draw graphs and use functions in MS Excel.
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)
Post a Comment