content_image/787717.jpg content_image/787718.jpg content_image/787719.jpg
<img src='content_image/787717.jpg'>

3. Select the desired checkboxes to change the format of the table. 

Header Row  – Creates a row at the top of the table for headers. 

Total Row  – Creates a row at the bottom of the table populates a total sum for each column. 

Banded Rows – Shades every other row in the table. 

First Column  – Shades the entire first column the same color as the header row. 

Last Column  – Shades the entire last column the same color as the header row. 

Banded Columns  – Shades every other column in the table. 

## Pivot Tables 

A pivot table is a data summarization tool within Excel. A pivot table can sort, count, total and average the data within a table or spreadsheet. 

To Insert a Pivot Table: 

1. Select any cell in your data range. 

2. Select Pivot Table located on the Insert tab. 

<img src='content_image/787718.jpg'>

The Create PivotTable dialogue box will appear. 

<img src='content_image/787719.jpg'>

