MODULE 3 HOMEWORK ASSIGNMENT
(45 points)
The completed Excel worksheet image shown below lists student grades for four students in a class.
Student names appear in column A, rows 4 through 7. The class content includes three homeworks (HW
1, HW 2, and HW 3), a midterm (MT), and a Final. Total possible points for each of these assignments is
indicated in row 3 under the appropriate assignment heading in columns D through H in the worksheet.
Individual student grades for these assignments appear in columns D through H and rows 4 through 7.
Students are marked as being either full time (FT) or part time (PT) in column B. There is also an
indication in column C as to whether a student is an honors student or not (YES or NO). Data given in
the problem is shaded gray. You will be providing proper formulas or functions for the remaining data in
the unshaded cells by answering the following questions using cell references from this worksheet. You
will type your answers in this document. There is no Excel file provided for this assignment. Note that
once you have completed a question, you may use the results of that question in subsequent problems.
Remember to start all formulas or functions with an equal (=) sign and to always use cell references and
functions where possible. Only use a $ if necessary when copying formulas down or across.
1. (0-5 pts) Write an Excel function in cell I4, which can be copied down the column, to calculate the
total points in the class for each student.
=SUM(D4:H4)
2. (0-5 pts) Write an Excel formula in cell J4, which can be copied down the column, to calculate the
student’s final percentage grade in the class. Note that the cells are already formatted as
percentages.
Page 1 of 3
