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?
Change the cell style to a number
Leave the opening payable number blank
Hard code a zero value
3. What should the formula in the Closing Payables line be?
Purchases less Cash Payments
Equal to the sum of the other items in the Control Account
Equal to the calculated Closing payables in the section earlier
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement