Modify the cell alignment settings.
Cell range B3:B25
Horizontal: Right (Indent)
Create a hyperlink to another worksheet.
Cell A2.
Cell reference "A3"
Sheet reference "Section 3" worksheet.
Insert the instructor's name for column B.
Cell B5.
Use Function RIGHT
Text: B2
Absolute reference
Num_chars: "16"
Add conditional formatting.
Color Scales: Green –White-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"
Formula. Find the average of each student's homework scores.
Cell range C7:C29
Use Function AVERAGE
Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"
Formula.
Find themaximum homework score for each student.
Cell rangeE7:E29
Use Function MAX
Number 1: maximum homework score for each student on "Section 3" worksheet.
Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style