contestada

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 functionSelect the data → Click the Data tab → Select ""Consolidate"" in the Data Tools group → Choose AVERAGE in the function boxSelect the data → Click the Formula tab → Select ""Calculation Options"" in the Calculation group → Choose AutomaticSelect the data → Click the Formula tab → Select ""Equation Options"" in the Symbols group → Select ""Insert New Equation"" → Type in new equation

Respuesta :

jayilych4real

The steps which Mr Thoreau can follow so he can compare these averages on his Excel file is:

  • Select any cells in the range of data
  • Click the data
  • In the Sort&Filter group, click sort
  • Select the column to sort by and then select a sort order
  • Select the next column to sort by and select the sort order click ok

What is Average?

This refers to the sum of numbers which are gotten from a list and divided by the numbers in the list and is the central value of the data.

With this in mind, we can see that because Mr Thoreau is making Excel to grade homework grades, then for him to find the average, he would select the data and then sort and filter them.

Read more about averages here:
https://brainly.com/question/6504879

Otras preguntas