Percentages — Sales split by department
Calculate each department's share of total sales as a percentage, then model an increase, a decrease and a target — 6 guided steps.
=SUM( ... )
1 / 6
Compute the total sales of all departments.
=SUM(B2:B7)
= value / total * 100
2 / 6
What percentage of total sales does the Fruit department represent? (the total is in C2)
=B2/C2*100
3 / 6
What percentage does the Meat department represent?
=B4/C2*100
= amount * (1 + percentage/100)
4 / 6
The Fruit department increases its sales by 10%. What will the new amount be?
=B2*(1+10/100)
= amount * (1 - percentage/100)
5 / 6
The Fish department drops by 20%. What will the new amount be?
=B5*(1-20/100)
= target - current
6 / 6
The manager wants the Dairy department to reach 10% of total sales. How much is missing?
=C2*10/100-B7
Your score is
Restart
