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