Create a hyperlink to another worksheet.
Cell A2.
Cell reference "A3"
Sheet reference "Section 3" worksheet.
Create a chart. To the right of the data Chart 3-D Clustered Column Exclude all filtered rows Horizontal Axis Labels: "IDs" column in table Series 1: "Zero Scores" column in table.
Insert the instructor's name for column B.
Cell B5.
Use Function RIGHT
Text: B2
Absolute reference
Num_chars: "16"
Sort and Filter. Apply a sort and a filter to the table. Cell range B6:F29 Sort Column Zero Scores Order Largest to Smallest Column IDs Order Smallest to Largest Filter Hide students ids with no zero scores.
Configure page layout options.
Cell range B3:S25.
Set Print Area.
Enable the Gridlines Print option.
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.
Formula.
Find the minimum homework score for each student.
Cell range D7:D29
Number 1: minimum 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