Microsoft Excel Tutorial: Working with Average Functions

This video tutorial covers the use of average functions in Excel. It begins with an introduction to the purpose and key points of average functions, such as ignoring text and empty cells, and handling up to 255 arguments. The tutorial then demonstrates how to insert the average function in Excel, followed by three methods to calculate averages. It also addresses common errors like reference and division errors, and concludes with a summary and encouragement to practice.

What is the primary purpose of the average function in Excel?

• To find the minimum number

• To find the sum of numbers

• To find the average of a group of numbers

• To find the maximum number

Which of the following is ignored by the average function in Excel?

• Numbers

• Text

• Formulas

• Conditional Formatting

Which method allows you to insert the average function without typing the formula?

• Using the data tab

• Using the function sign

• Using the home tab

• Using the formula bar

What error might you encounter if you delete a row or column used in the average function?

• Reference error

• Syntax error

• Runtime error

• Logical error

What happens if the average function is applied to a range with no numbers?

• It returns a syntax error

• It returns a logical error

• It returns a division error

• It returns zero