Back to lesson
1. In our model example, what is the formula that we need in the Purchases row below?
Purchases x Prices
Purchases x Prices / Thousand
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?
Leave the opening payable number blank
Hard code a zero value
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