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 primary purpose of the AVERAGE function in Excel?

• To find the maximum value in a range

• To find the average of values in a selected range

• To sum up all the values in a range

• To count the number of cells in a range

Which method can be used to enter the AVERAGE function in Excel?

• Only through the Functions dialog box

• Only by typing it directly into a cell

• Only by using a keyboard shortcut

• Either by typing it directly into a cell or using the Functions dialog box

What is the correct way to select a cell range for the AVERAGE function?

• Select the cells you want to average

• Select the first and last cell only

• Select any random cells

• Select the entire worksheet

What feature in Excel allows you to quickly apply the AVERAGE function to multiple cells?

• AutoFill

• AutoCorrect

• AutoSum

• AutoFormat

What does Excel do when you drag a formula down using the AutoFill handle?

• It keeps the cell references the same

• It deletes the formula

• It adjusts the cell references automatically

• It changes the formula to a different function