Skip to content

Excel Challenge 8 – Math Functions

How often do you find yourself working with math functions in Excel? Do you use them often? Or are you not too familiar with them?

Either way, you are about to get the chance to test your skills working with math functions in Microsoft Excel!

In this week’s Excel challenge, you will have four questions to test your math function knowledge. Click the link below to download the workbook.

Excel Challenge 8 Download

Question 1

For question number one, your task is to calculate the number of possible starting hand combinations given a deck with 52 cards and a starting hand size of 4 cards.

Question 1 – Solution

The best way to solve question one is through the use of the COMBIN function.

The COMBIN function automatically calculates the number of possible combinations given the total number of items and the number of items allowed in each combination. That fits this scenario perfectly.

So in cell F4, enter the following formula.

=COMBIN(C4,C5)

The COMBIN function does all the math for you and calculates the number of possible starting hand combinations.

Question 2

For question two, your goal is to calculate the total number of units sold rounded to the nearest ten, such as 550, 560, etc.

Question 2 – Solution

To solve question two, you will use two functions.

  • The SUM function
  • The ROUND function

You will use the SUM function to calculate the total number of units sold, and then you will use the ROUND function to round the number accordingly.

So in cell F5, enter the following formula.

=ROUND(SUM(D5:D18),-1)

The SUM function calculates the total, and the ROUND function rounds the result to the nearest ten due to the negative one entered for the second argument.

Question 3

For question three, you must calculate the total revenue using the data provided.

Question 3 – Solution

To solve question three, I suggest using the SUMPRODUCT function.

You calculate the revenue for each product by multiplying the Units Sold by the Revenue/Units Sold metric. Then once you have the revenue for each product, you add up those numbers to get the total revenue.

Luckily, the SUMPROUCT function will perform both of these calculations in one go.

So in cell G5, enter the following formula.

=SUMPRODUCT(D5:D18, E5:E18)

The SUMPRODUCT function multiplies each number from the first range with the corresponding number from the second range. The function then adds all these numbers together to generate the final result.

And just like that, you get back the total revenue!

Question 4

For question four, you have to calculate the total revenue for category A products that have sold more than 35 units.

Question 4 – Solution

To solve question four, I highly recommend using the SUMIFS function. The SUMIFS function will allow you to sum only those numbers that meet specified criteria.

So in cell G5, enter the following formula.

=SUMIFS(E5:E18, C5:C18, "Category A", D5:D18, ">35")

The SUMIFS function checks to see which cells in C5:C18 contain category A and which cells in D5:D18 contain a value greater than 35.

The SUMIFS function then adds together the numbers from the range E5:E18 in rows that meet both conditions.

As a result, you get back the total revenue for category A products that have sold more than 35 units!

What Were the Results?

How did you do? Did you get all the questions right, or did you struggle with one or two?

Leave me a comment below to let me know how you did!

Also, if you missed the first few Excel challenges, you can check them out using the links below.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top