# Excel Practice & Exercises with SUM Function

## Problem Overview

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. Relevant hints are given as notes in the file.

• Exercise 01 Add Consecutive Cells: In the first exercise, you must find the total time worked for each employee 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 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 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 using the VBA SUM function.

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

Get FREE Advanced Excel Exercises with Solutions!

Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF