Excel Project: GPA Calculator

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
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

Don't use plagiarized sources. Get Your Custom Essay on
Excel Project: GPA Calculator
Just from $13/Page
Order Essay
ORDER NOW »»

and taste our undisputed quality.