Microsoft Excel 2021365 - Beginner to Advanced - Finding the Average with the AVERAGE Function

The video tutorial explains the AVERAGE function in Excel, which calculates the average of selected cell values. It demonstrates how to use the function directly in a cell or through the Functions dialog box. The tutorial also covers using Auto Sum to find averages and introduces the concept of auto fill and relative referencing, which allows formulas to be copied and adjusted automatically. The video concludes with a brief mention of absolute and mixed referencing, which will be discussed in future lessons.

What is the purpose of the AVERAGE function in Excel?

How can you enter the AVERAGE function into a cell?

What steps are involved in using the Functions dialog box to find the average?

What is the significance of the auto fill handle in Excel?

Explain the concept of relative referencing when copying formulas in Excel.