Back to lesson
1. In modeling depreciation, which of the following would you not use the OFFSET function to calculate?
Transposing capital expenditure
Determining economic life
2. In calculating depreciation, why do we need to adjust the period counter for the SUM(OFFSET) methodology?
This is required in case of economic lives having non-integer values
It reminds the end user of the value of the economic life
This restriction to economic life prevents depreciation charges being included for too many periods and thus incurring over-depreciation
3. Which of the following is not true about the Height argument in the OFFSET function?
A Height of 1 is the same as a Height of -1
The argument is optional
Its default value is zero
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement