Using the AVERAGE Function in Excel


Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

To find the average of a range of numbers, the AVERAGE function performs what calculation?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. What happens if you have empty cells in your range, when using the AVERAGE function in a formula?

2. If you have a list of numbers in cells B2 through B20 and you wanted the average of these numbers, what would be the formula?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

If you use these resources, you'll be checking your awareness of concepts such as the AVERAGE function's calculation, factors, and the way it works. Some of these questions will come in the form of example problems.

Quiz & Worksheet Goals

Expect to be quizzed on:

  • How the AVERAGE calculates the average of a range of numbers
  • Affects of empty cells on calculating the average
  • The formula to calculate the average

Skills Practiced

  • Problem solving - use acquired knowledge to solve average calculation practice problems
  • Knowledge application - use your knowledge to answer questions about the AVERAGE function
  • Making connections - use understanding of the concept of Excel's functions

Additional Learning

What else can you learn about the AVERAGE function? Formulate an answer to that question by watching our affiliated lesson, Using the AVERAGE Function in Excel. This lesson will cover:

  • Using AVERAGE in a formula
  • How to set up the formula
  • More elaborate formulas
  • Examples of the way the formula works