Back to lesson
1. In our model example, what is the formula that we need in the Purchases row below?
Purchases x Prices / Thousand
Purchases x Prices
2. If you link the Opening Payables balance in the first period to the empty cell in the model, and you get a blank cell, what should you do?
Hard code a zero value
Leave the opening payable number blank
Change the cell style to a number
3. What should the formula in the Closing Payables line be?
Equal to the sum of the other items in the Control Account
Equal to the calculated Closing payables in the section earlier
Purchases less Cash Payments
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement