The Complete Excel Guide: Beginners to Advanced - Exercise 03

The video tutorial covers exercise three, focusing on calculating depreciation using different methods. It starts with an enhanced course file showing straight line depreciation and guides learners to calculate declining balance and sum of years digits depreciation without using intermediate columns. The tutorial highlights a small rounding error in the fixed declining balance depreciation function and concludes with encouragement to complete the exercise.

What is the starting point for exercise three in the video tutorial?

• An enhanced version of the last course file

• A completely different course file

• A file with only text data

• A new course file with no data

Which columns contain the figures for straight line depreciation?

• Columns F & G

• Columns H & I

• Columns C & D

• Columns A & B

What is one of the depreciation methods you need to calculate in exercise three?

• Activity-based depreciation

• Units of production depreciation

• Declining balance depreciation

• Double declining balance depreciation

What should you avoid using when performing the depreciation calculations?

• Intermediate columns or values

• Multiple worksheets

• External data sources

• Complex macros

What is the reason for the small rounding error mentioned in the video?

• Rounding done in the calculation

• Software bug

• Data entry mistake

• Incorrect formula