Guide

1. Open the file you want to edit.

2. Click on the cell where you want to calculate and display the average.

3. Type an equal sign (=), followed by AVERAGE(, then click on the cells containing the data you want to calculate the average. Close the parentheses to complete the formula. For example, =AVERAGE(F2,G2,H2,I2) in our case.

4. Press the enter key.

5. Click and drag the bottom corner of the cell down to automatically apply the formula to the desired cells for averaging.