Microsoft Excel Exercise 1

Excel Exercise 1

Student GPA Calculator

Open a new excel document. Save the file as [your initials] GPACalculation.

1. Add a table with following columns – ID, Course Name, No. of Credits, Letter Grade,

Grade Points, Quality Points.

2. Create title for worksheet. Center and merge it.

3. Enter at least five courses in this table with grade earned and number of credits.

4. Use VLOOKUP to take the letter grade for the first course and look up the Grade Points

in the second column of the lookup table. Use absolute referencing; then fill and copy to

look up the grade points for each course. Please use following lookup table for this –

Letter

Grade

Grade

Points

A 4

B 3

C 2

D 1

F 0

5. Multiply the Grade Points by the Credits to get the Quality Points for each course.

6. Next two rows in this table should display the total of Number of Credits and total

Grade points. You need to use AutoSum to find these two.

7. Compute the GPA by dividing the total Quality Points by the total number of credits

and display it as Cumulative GPA in the next row. This completes the table.

8. Name the worksheet GPA and add a tab color.

9. Save the file and submit it through blackboard.