Mr. Thoreau uses an Excel file to manage his grade book. He wants to average his homework grades for each term so that he can compare the subtotals for each class period. What steps could he follow so he can compare these
averages?
Select the data — Click the Data tab - Select "Subtotal" in the Outline group – Choose AVERAGE in the use
function
Select the data - Click the Data tab - Select "Consolidate" in the Data Tools group - Choose AVERAGE in the
function box
Select the data - Click the Formula tab - Select "Calculation Options" in the Calculation group – Choose
Automatic
Select the data - Click the Formula tab - Select "Equation Options" in the Symbols group - Select "Insert New
Equation" Type in new equation