Copyright

Using the COUNT Function in Excel

Instructions:

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

question 1 of 3

Which function totals the number of cells within a range that contain numbers?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 75,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. Which function totals the number of cells within a range that contain numbers or text?

2. If you wanted to find the empty cells within a range, what formula would work?

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

On these practices, you are going to put your knowledge to the test on topics regarding Excel's COUNT function. Topics will include things like different Excel functions, how to find empty cells, and the actions of certain formulas.

Quiz & Worksheet Goals

More particularly, you'll be quizzed on:

  • Excel functions that deal with totaling numbers of cells
  • A formula for finding the empty cells in a range
  • The function something like =COUNT(A1:A10) would perform
  • Values returned by formulas

Skills Practiced

  • Knowledge application - use your knowledge to answer questions about roles of the COUNT function
  • Interpreting information - verify that you can read information regarding the way the COUNT function works and interpret it correctly
  • Problem solving - use acquired knowledge to solve practice problems on the COUNT function

Additional Learning

Discover how much more you can learn about the COUNT function by employing the use of our video lesson, Using the COUNT Function in Excel. This lesson's purpose to teach you more about:

  • Features of the COUNT function
  • The COUNTA function
  • Other related functions
  • Mechanics of how these functions work
  • Examples of how these functions work
Support