How to Use the AVERAGEIF Function in Excel


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

question 1 of 3

Which definition is best when describing the AverageIF function?

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. If you wanted to find the average price of transmissions sold, which formula would you be likely to use?

2. You have a list of numbers in Column B, specifically, B3 through B25. You would like the average, if the number is below 10. Which formula would be best?

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

This interactive quiz and worksheet can be used to test your knowledge of Excel and some of its functions. The questions will require you to match Excel formulas to their function. Some important terms to look for include the definition of the word 'average.'

Quiz & Worksheet Goals

In this quiz, you will be tested on the following terms and topics:

  • Use of AverageIF
  • The Excel formula for averages
  • Basic layout of Excel spreadsheets

Skills Practiced

This quiz and worksheet combo allow students to practice the following skills:

  • Reading comprehension- ensure that you draw the most important information from the related lesson on using AVERAGEIF in Excel
  • Problem solving- use acquired knowledge to solve Excel practice problems
  • Knowledge application- apply your knowledge of Excel spreadsheets to find the mean of a group of numbers

Additional Learning

If you'd like to learn more about this function of Excel, take a look at the corresponding lesson, How to Use the AVERAGEIF Function in Excel. This lesson covers the following objectives:

  • Understand the difference between the AVERAGEIF and AVERAGE function
  • Explore different worksheet layouts
  • Use the AVERAGEIF function
  • Identify the meaning of ALTERNATOR