Modify the document property. MathTracker.xlsx Subject "Homework"

Change the color theme. MathTracker.xlsx Slipstream

Create a hyperlink to another worksheet. Cell A2. Cell reference "A3" Sheet reference "Section 3" worksheet.

Insert data from a text file. Cell A1. File source Autumn.txt Tab-delimited

Add a worksheet After other worksheets Rename "Section 5"

Formula. Insert text using a formula Cell K2 Use Function CONCATENATE Text1 : "Students with no " Text 2: header of column F Absolute Reference

Rename the title of the chart. Chart Text "All Zero Scores"

Apply a style to the chart. Chart. Chart Styles Style 7

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.

Formula. Find the maximum homework score for each student. Cell range E7:E29 Use Function MAX Number 1: maximum homework score for each student on "Section 3" worksheet.