Here's how to do it:
- Open the file you want to edit.
- Click on the cell where you want to calculate and display the average.
- 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.
- Press the enter key.
- Click and drag the bottom corner of the cell down to automatically apply the formula to the desired cells for averaging.