4. Rename Sheet 2: Grading Scale

 

5. On Sheet 3, create an HLOOKUP table for the Homeroom Teacher.  Put the Class in Row 1 and the Teacher in Row 2. Enter the following information: 

Students in the class of 2010 have Mr. Green.

Students in the class of 2011 have Mr. Plum.

Students in the class of 2012 have Mrs. White. 

Students in the class of 2013 have Ms. Scarlett.

 

6. Name the HLOOKUP Table TEACHER

 

7. On Sheet 1, use the HLOOKUP function in Column E to return the appropriate Homeroom Teacher.

 

8. Rename Sheet 1 as Student Records

 

Save your work as YOUR NAME Sound Advice Practice.

 

Practice Activities

Lesson 4: Sound Advice

Try This: Do the following steps

1. Open the spreadsheet:  Student Records.xlsx

 

2. On Sheet 2, create an VLOOKUP table with the following grading scale.  Put the percentages in Colum A and the letter grade in Column B. 

 

3. Select the grading scale and Name the Range: GRADES. 

 

0

E

62

D-

65

D

69

D+

72

C-

75

C

79

C+

82

B-

85

B

89

B+

92

A-

100   

A