Exercises / Foundations · 9 of 12
Each region's share of sales
A share is a part divided by the whole: =B2/B7 when B7 holds the total. Format the result as a percentage and 0.25 shows as 25%.
Your taskIn C2, divide the region's sales by the total in B7. It will be copied down to C6, so make sure every row divides by B7.
I'll check your formula on this sheet and on changed versions of it, so it has to work in general. Stuck? Ask for a hint, one step at a time.
Answer cell
Type in a cell, or double-click it to edit
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Region | Sales | Share | |||
| 2 | North | $48,200.00 | ||||
| 3 | South | $36,900.00 | ||||
| 4 | East | $52,150.00 | ||||
| 5 | West | $29,750.00 | ||||
| 6 | Central | $41,000.00 | ||||
| 7 | Total | $208,000.00 | ||||
| 8 | ||||||
| 9 |