Back to lesson
1. How should inputs be linked into a calculation section?
Perform calculations directly on input cell reference so that fewer calculations are required
Link directly back to the inputs themselves (sign may change for clarity)
Inputs should actually be positioned at the top of each calculation section so that it is easier for the model developer to reference
2. What is the main purpose of these greyed out cells in the associated image from an Inputs worksheet?
To make the model look more professional
To inform end users that these cells should be left blank
3. Are there any new calculations performed on the output sheet?
Yes, without restriction
Yes, but limited to summations, negations and ratios
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement