Method to calculate average in Excel

Select the cell to show the result e.g. cell E5 in the image shown below. Now put “=” sign in the cell and type “average” then press key opening parenthesis. Now select the data, cells from B5 to D5 then press the Enter key to get the average of selected data.

 

Please Share