cell references as needed in the formula . Copy the formula to the range W4 : W21 .
8 In cell X3 of the Grades sheet , use a VLOOKUP
9.000 function to calculate the letter grade equivalent . Use the range name to reference the lookup table in the function . Copy the formula to the range X4 : X21 .
9 Name the passing score threshold in cell B1 with the 4.000 range name Passing .
10 In cell Y3 , use an IF function to display a message
6.000 based on the student ’ s semester performance . If a student earned a final score of 70 or higher , display the label Enroll in CS 202 . Otherwise , display the label RETAKE CS 101 . Use the range name in the function