BeginnerMath Functions
Total a month of sales with SUM
Add up a column of daily sales figures to get the monthly total.
SUM
3 min10 points
Calculate the annual turnover rate
The situation
Harbor Supply's HR director has to report turnover to the board. Fourteen people left last year against an average headcount of 112, and the number has been quoted three different ways in three different decks.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Annual turnover | ||||
| 2 | |||||
| 3 | Leavers in the year | 14 | |||
| 4 | Average headcount | 112 | |||
| 5 | Turnover rate | ||||
| 6 |
Who this is for
Recommended next
Related exercises
- BeginnerFormulas
Calculate achievement against target
Divide actual sales by target to get an achievement percentage.
3 min10 points - BeginnerMath Functions
Apply a percentage discount to a list price
Work out what a customer pays after their contracted discount.
5 min15 points - BeginnerMath Functions
Total a month of sales with SUM
Add up a column of daily sales figures to get the monthly total.
SUM
3 min10 points