Body
Use the AVERAGE, MAX, OR MIN functions.
- Click your mouse in the cell in which you wish your result to appear
- Click the arrow next to AutoSum on the Home Tab or the Formulas Tab
- Click the Average, Max, or Min
- Highlight the range of cells you wish to find the value for
- Press Enter
To see more functions, click More Functions on the AutoSum list on the Home Tab to open the Insert Function dialog box OR go to the Formulas Tab and click on the More Functions orange textbook icon.