Simple operations
Track a half-year of revenue, costs and profit with basic arithmetic formulas across a small activity table — 7 guided steps.
Divide the annual costs by the number of months in a year.
1 / 7
The total fixed costs for the year are 9000. In B3, how do you write the formula to calculate the fixed costs to pay in January?
=9000/12
Write a formula that always picks up February's amount.
2 / 7
In D4, March's variable costs follow February's. How do you write the formula?
=C4
3 / 7
April's variable costs are March's plus 1000.
=D4+1000
4 / 7
May's variable costs are three times higher than February's.
=C4*3
5 / 7
June's variable costs are three times higher than February's, plus half of January's variable costs.
=C4*3+B4/2
It's the sum of fixed costs and variable costs.
6 / 7
In B5, what is the formula to calculate January's total costs?
=B3+B4
The difference between the revenue figure and total costs.
7 / 7
In B6, what is the formula for January's operating result — the difference between revenue and expenses?
=B2-B5
Your score is
Restart
