You may display semester subtotals instead of the year’s overall Total, Maximum, Average, and Grade in the far right summary columns.
There are two ways to choose which summary data to view.
Select Year, Semester 1 or Semester 2 from the Standard Toolbar.
Use the drop down on the toolbar to view semester or year
From the View menu.
- Click View > Subtotals.
- Choose which grades to display in summary columns option of the dialog box. Click Year,Semester 1 or Semester 2. A notation in the cell beneath Grade in the Grade column of the spreadsheet will indicate whether summary information for the year (Yr) or semester 1 or 2 (Sm1 or Sm2) is displayed.
Use the menu to view semester or year