Knowledge Books

Home → Google → Google Sheets → Using the Average Function

13.8. Using the Average Function

Directions: There are four options to view the resources below: try it, view it, watch it, or print it. Click the drop down menu titled "Try-It Interactive" to select your preferred viewing method. Then, click start.


8 STEPS

1. With your Google Sheet open click the cell in which you want your function (Q12 in this case)

Step 1 image

2. With the cell clicked, Click Insert

Step 2 image

3. With your mouse, hover Function►

Step 3 image

4. Scroll up and Click AVERAGE

Step 4 image

5. Click and highlight the cells you would like to average. They will automatically be added to your functions range.

Step 5 image

6. Again, highlight your desired cells to average.

Step 6 image

7. Press enter or click out of Q12.

Step 7 image

8. That's it. You're done.

Step 8 image

Here's an interactive tutorial

https://www.iorad.com/player/1737611/Google-Sheets---Using-the-Average-Function


Downloads

Knowledge Tags
average  /  functions  /  function  /  Google Sheets  /  Google Sheets  /  Sheets  / 

← Using the Sum Function to Add Multiple Cells Using the Unique Function →