Question

Make a pivot table with "Business Student" (Rows), "Athlete" (Rows), "Cheated" (Columns), and "Cheated" (Summed Value).

Answer 1

Creating the specified pivot table involves selecting the relevant data and using the Pivot Table feature in spreadsheet software like Excel to arrange 'Business Student' and 'Athlete' as rows, and setting 'Cheated' as both the column label and the value to be summed.

Step-by-step explanation:

To make a pivot table with "Business Student" and "Athlete" as row labels, "Cheated" as the column label, and "Cheated" as the summed value, you will need to have access to data that has these specific fields.

The steps to create this pivot table in a program like Microsoft Excel would be:

1. Select the range of data that includes the Business Student, Athlete, and Cheated fields.
2. Go to the Insert tab and click on the Pivot Table button.
3. In the Pivot Table creation window, drag the Business Student field to the Rows area and the Athlete field to the Rows area below Business Student.
4. Drag the Cheated field to the Columns area.
5. Drag the Cheated field again to the Values area, and ensure it is set to sum the values rather than count them.
6. After you click OK, the pivot table will be created.

This pivot table will allow you to analyze the data to find, for example, the total number of business students who are athletes that have cheated.

The complete question is: Make a pivot table with "Business Student" (Rows), "Athlete" (Rows), "Cheated" (Columns), and "Cheated" (Summed Value). is:

Answer 2

Creating the specified pivot table involves selecting the relevant data and using the Pivot Table feature in spreadsheet software like Excel to arrange 'Business Student' and 'Athlete' as rows, and setting 'Cheated' as both the column label and the value to be summed.

Step-by-step explanation:

To make a pivot table with "Business Student" and "Athlete" as row labels, "Cheated" as the column label, and "Cheated" as the summed value, you will need to have access to data that has these specific fields.

The steps to create this pivot table in a program like Microsoft Excel would be:

Select the range of data that includes the Business Student, Athlete, and Cheated fields.

Go to the Insert tab and click on the Pivot Table button.

In the Pivot Table creation window, drag the Business Student field to the Rows area and the Athlete field to the Rows area below Business Student.

Drag the Cheated field to the Columns area.

Drag the Cheated field again to the Values area, and ensure it is set to sum the values rather than count them.

After you click OK, the pivot table will be created.

This pivot table will allow you to analyze the data to find, for example, the total number of business students who are athletes that have cheated.

The complete question is: Make a pivot table with "Business Student" (Rows), "Athlete" (Rows), "Cheated" (Columns), and "Cheated" (Summed Value). is: