Back to lesson
1. CRaFT is the acronym to support the four ideal principles of a Best Practice model. Which of these is NOT an attribute of CRaFT?
2. In a financial model, which of the following is unlikely to be given its own worksheet?
Constants summary, where assumptions are stored that are not be changed (e.g. hours in day)
Chart sheets, due to the fact data is on another sheet and they are difficult to hyperlink to
3. When creating formulae, what is the “Rule of Thumb”?
Functions used in an Excel formula should be as recognizable to an end user as their thumbs
As a general principle (i.e. Rule of Thumb), use CRaFT to build your models when you can
Ideally, no formula should be longer than your thumb in the formula bar
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement