Excel PivotTables: Showing Count of First Column - Quiz Assignment Mark Range
In this article, we will focus on creating and customizing a PivotTable in Excel, specifically showing the count of the first column with a Quiz Assignment Mark Range. This tutorial will be helpful for those who are beginners in Excel and currently practicing PivotTables.
Table Setup
Let's assume that you have a table named "Table7" with the following setup:
| ROW Labels | Quiz Assignment Mark Range |
|---|---|
| Student1 | 90-100 |
| Student2 | 80-89 |
| Student3 | 70-79 |
| Student4 | 60-69 |
| Student5 | 90-100 |
Creating a PivotTable
To create a PivotTable, follow these steps:
- Select the entire table.
- Go to the "Insert" tab and click on "PivotTable".
- In the "Create PivotTable" dialog box, select "New Worksheet" and click "OK".
Adding Rows and Columns
To add rows and columns, follow these steps:
- Drag the "ROW Labels" field to the "Rows" area.
- Drag the "Quiz Assignment Mark Range" field to the "Columns" area.
Showing Count of First Column
To show the count of the first column, follow these steps:
- Right-click on any cell in the PivotTable.
- Select "Summarize Values By" and then "Count".
Customizing the PivotTable
To customize the PivotTable, you can change the formatting, add filters, and more. For example, you can change the formatting of the numbers by right-clicking on any cell in the PivotTable and selecting "Format Cells".
Quiz Assignment Mark Range
In this example, we have used the "Quiz Assignment Mark Range" as the column headers. You can customize this to fit your specific needs, such as using "Quiz Score" or "Assignment Grade".
In this article, we have covered the basics of creating and customizing a PivotTable in Excel, specifically showing the count of the first column with a Quiz Assignment Mark Range. By following the steps outlined in this tutorial, you will be able to create and customize your own PivotTables to fit your specific needs.
References
Note: The above references are provided for informational purposes only and are not endorsed by the author or site.
End of Article