New York University Professor Total Course Points Worksheet

I’m working on a Excel exercise and need support to help me understand better.

Uses Excel skillsSum()Vlookup() with Named cell rangesIf()Formatting cellsColumn widthAlignmentBordersText Orientation

1. Replace the data in the Total Points Earned column with a formula that sums each student’s points (1.0)
2. Use the VLookup Function to automatically assess final grades based on the total points column and the Grade table in the Grade Table worksheet. (3.5)
3. Using the If Function, create a formula so each student’s grade shows the words Pass or Fail based on 750 total possible points and >=60% is passing (3.5)
4. Formatting (1.75)
   1. Put a thick border around the table’s headings (0.25)
   2. Put a thick vertical border between student names and their grades (0.25)
   3. Change the heading row’s text (all but student name) to be Angle Counterclockwise Orientation (0.25)
   4. Put a thick border around the entire grade table (0.25)
   5. Format grades and Total Points Earned to only display one decimal point and adjust columns widths to be more reasonable (0.5)
   6. Left Align the student’s points and Total Points Earned, and increase indent by one (0.25)

PreviousNext