Assignment

In the table below, there are assignment scores from a class of students. The first assignment was worth 150 points and the second was worth 180 points and the scores in the table are the points scored. Letter grades will be assigned using the standard grade boundaries given on the right, below.

Last Name	First Name	Assignment 1	Assignment 2
Aliya	Sally	132	147
Anderson	Vega	118	126
Bardsley	Abhilash	86	87
Donegal	Kyle	98	103
Golden	Stacey	129	133
Harrison	David	127	122
Hendry	Stasia	123	129
Henry	Pat	123	137
Hollins	Gus	129	135
Jonas	Maliyah	158	170
Lingood	Carey	151	164
Marshall	Cronelia	99	104
Mercado	Jaylyn	112	115
Morales	Katie	110	103
Olvera	Wallace	106	105
Parks	Lucas	117	123
Ramirez	Belle	102	108
Ronald	Riley	87	89
Rowe	Kerry	118	128
Sutton	Elle	137	144
Teng	Ken	153	166
Uppstrom	Shirley	129	135
Waters	Bennie	128	144
Whittemore	Charlotte	107	114
Williams	Herring	102	98

Percentage	Grade
87%	A
75%	B
63%	C
50%	D
< 50%	F

You will need to create a new Excel file for this assignment.

Create a worksheet with the columns of student names and scores as shown above.

Add a column to the right of assignment 2 labeled Percentage

Add a column to the right of Percentage labeled Grade

Put the maximum score (330, to include both assignments) in any convenient cell on your worksheet. Reference this cell using absolute addressing to calculate the corresponding percentage score for each student.

Points will be deducted if you do not use absolute addressing in this formula.

EX: If a student's score was in cell C2 and the maximum score is in cell G3, your formula would be C2/$G$3, not C2/G3 (relative addressing).

Below the table of students, use the MIN function to calculate the lowest percentage and display with a label of Lowest Percentage.

Below the lowest percentage, use the MAX function to calculate the highest percentage score and display with a label of Highest Percentage.

In any convenient area on your worksheet, order the grade cutoffs in ascending order. Then, use the VLOOKUP function to display the letter grade for each student. If you don't have the grade cutoffs in ascending order, your VLOOKUP function will not work. Also, remember that the cutoff for an F grade is actually a zero.