contestada

In the file MajorSalary, data have been collected from 111 College of Business graduates on their monthly starting salaries. The graduates include students majoring in management, finance, accounting, information systems, and marketing. Create a PivotTable in Excel to display the number of graduates in each major and the average monthly starting salary for students in each major.

Respuesta :

batolisis

Answer:

The pivot table is attached below

Explanation:

procedure used to create the Pivot Table

  • select insert from worksheet Ribbon
  • select pivot table
  • select the range of Data
  • select   "new worksheet "
  • select Major as row heading and the summation symbol to count the major
  • input variables given in their right cells

after this procedure the table is successfully created

Attached below is the Pivot Table in Excel displaying The number of graduates in each major and average monthly salaries

Ver imagen batolisis

Otras preguntas