MS Excel Assigment

Gulf University For Science and Technology Department of MIS

Department of MIS

MIS 118

Computers and Information Systems

Assignment 2 : MS Excel

1. Enter the following data in a new excel sheet

2. Format the title cells as follows (grey background, Bold centered text):

3. For every student, calculate the average of the 3 midterms using formulas in column E.

4. Highlight the final grades of students who obtained a final grade greater than 90%, using conditional formatting.

5. For each of MT1, MT2, MT3, MT Avg, and Final, calculate the average, standard deviation, maximum, and minimum using formulas. Results should appear as follows:

6. Sort the data in the table according to increasing stud_id, making sure every id moves with its corresponding midterm and final grades.

7. Display a line graph as follows to show how all 7 students performed in all three midterms as follows:

8. Delete the record of the last student and watch the averages change according to stored formulae.

9. Insert a new column to the left of the ID column. Add any student names you like in this column. Now, hide the new column created.

10. Add a header to the excel sheet that contains your name and ID in the middle.

11. Add a footer to the excel sheet that contains the course name in the middle, the date (auto) on the left, and the page number on the right (in the format page/pages).

12. Make sure that all the columns are sized appropriately in order to show the title of the column completely.

13. Rename the excel sheet to be section 1, and delete all other sheets in the workbook.

14. Change the page orientation from portrait to landscape. Then, save your workbook document with the name StudNum_ex2_1 and post the spread sheet document by uploading it to Assignment2 in MyGUST by Saturday, October 17th, 2015 at 11:55 PM.

Only the data in the green square are included in the line graph.

Only the data in the blue brackets are included in the line graph.

MIS 118 - 3 - Fall 2015