Share of the total

Beginner← PreviousSkip →
Exercise 11 of 11 Premium

What share of all the items sold over the six months were pastries?

Checking your plan…

coffee-shop-sales.xlsx

ABC
1MonthCoffeePastries
2
3
4
5
6
7
8

About basics & math in Excel

Start here if you're new to Excel formulas. These exercises teach you how cell references and ranges work, and how to add up, average, count and round numbers with SUM, AVERAGE, MAX, COUNT and ROUND.

Functions you can use here

  • SUM(number1, [number2], …)
  • AVERAGE(number1, [number2], …)
  • MAX(number1, [number2], …)
  • COUNT(value1, [value2], …)
  • ROUND(number, num_digits)

More basics & math exercises

  1. 1.Total revenue
  2. 2.Average order size
  3. 3.Largest orderPremium
  4. 4.Smallest orderPremium
  5. 5.Count the ordersPremium
  6. 6.Count text cellsPremium
  7. 7.Add two cellsPremium
  8. 8.Revenue per unitPremium
  9. 9.Percentage changePremium
  10. 10.Round to the nearest 10Premium
  11. 11.Share of the totalPremium
See the whole topic →