Excel Practice & Exercises with SUM Function

Get FREE Advanced Excel Exercises with Solutions!

This article contains six Excel practice exercises related to the SUM function. The problems are easy to solve, so you will only need a basic level of Excel knowledge to solve them. To solve all the problems, you should know the following: the SUM function, the SUMIF function, the Fill Handle, the AutoSum feature, Excel VBA, enabling the Developer tab, and custom cell formatting. You will need at least Excel 2010 to solve all the problems.


Download Practice Workbook

You can download the Excel file from the following link.


Problem Overview

In this article, you will get six exercises related to the SUM function. To illustrate the problems, we have used a dataset. This dataset represents the order information for a fast food restaurant. Additional information is provided in the “Reference Tables” sheet, and the worked out exercises are in the “Solution” sheet. Moreover, relevant hints are given as notes in the file.

Problem Overview of Excel SUM Function Practice Exercises

  • Exercise 01 Add Consecutive Cells: In the first exercise, you will need to find the total time worked for each of the employees and return the values in column K.
  • The following animated image shows the solution to the first problem. Here, we have hidden some columns for better presentation.

  • Exercise 02 Aggregate Non-consecutive Cells: You will calculate the total sales value from the odd positioned cell (i.e. position 1,3,5, etc.).
    • You will need to input all the cell cells and separate them with commas inside the SUM function to solve this.
  • Exercise 03 Summation of Entire Row: Your task is to find the total work completed by finding the summation of the entire row for the employee named Salli.
  • Exercise 04 Use Shortcut to Get Total Value: In this exercise, you will use a shortcut key to find the AutoSum to find the total sales.
  • Exercise 05 Add Values based on Criteria by Inserting a Helper Column: First, compute the total of the more than 8 hours only. After that, use the SUM function to find the total values from the previous operation.
  • Exercise 06 VBA SUM Function: In this last exercise, your task is to find the total sales value by using the VBA SUM function.

The final exercise is depicted in the image below. Here, we have hidden some columns for better presentation.

Excel SUM Function Practice Exercises


Conclusion

Thank you for reading this article. By completing these SUM function Excel practice exercises, you will learn about various ways to think. We hope that you have gained knowledge about Excel. You can find more articles similar to this on the ExcelDemy website. If you have any questions or suggestions, feel free to comment below. However, remember that our website implements comment moderation. Therefore, your comment may not be instantly visible. So, have a little bit of patience, and we will solve your query as soon as possible. Keep excelling!

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Rafiul Haq
Rafiul Haq

Greetings! I am Rafiul, an experienced professional with an engineering degree and an MBA in finance. Data analysis is my passion, and I find Excel to be an invaluable tool in this domain. My goal is to simplify complex concepts by providing comprehensive and user-friendly guides on Excel and finance topics, aiming to enhance people's productivity and understanding at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo