content_image/736383.jpg content_image/736382.jpg content_image/736381.jpg
## Removing Subtotals 

To remove subtotals from a data sheet: 

1. Select the Subtotal t ool 

The Subtotal Dialogue box will appear. 

2. Select Remove All  to remove all subtotals. 

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

## Average 

To find the average of a select range of data: 

1. Select the cell directly beneath the range of data 

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

2. Select the Auto Sum  dropdown on the Formulas tab. 

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

3. Choose Average  from the Auto Sum dropdown 

