Using the SUM Function in Excel


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

question 1 of 3

What types of calculations can you perform using the SUM 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. Which formula is correct if you want to add the numbers in cells B3 and B4?

2. If you wanted to add the cells A10 through A20 and then multiply that total by 5%, which formula below would be correct?

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

The SUM function in Excel can provide many different types of equations. This quiz will gauge your understanding of this function and how to use it.

Quiz & Worksheet Goals

This assessment will test your knowledge of the SUM function including:

  • Possible calculations
  • How to use each calculation
  • Practice problems

Skills Practiced

  • Making connections - use understanding of the concept of the SUM function and its formulas
  • Problem solving - use acquired knowledge regarding the various calculations of the SUM function to solve practice problems
  • Knowledge application - use your knowledge to find answers to specific calculations of sample ranges

Additional Learning

To learn more about the SUM function, review the accompanying lesson titled Using the SUM Function in Excel. This lesson provides more information regarding:

  • Excel functions and SUM function uses
  • Step-by-step process to each calculation
  • Input of multiple calculations