Back to lesson
1. In modeling depreciation, which of the following would you not use the OFFSET function to calculate?
Determining economic life
Transposing capital expenditure
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
Its default value is zero
The argument is optional
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement