Accountancy Part CUse of Spreadsheet in Business Applications

Which Excel function is used to calculate depreciation under Straight…

Which Excel function is used to calculate depreciation under Straight Line Method (SLM)?

Answer & explanation

Correct answer: option 3

The correct answer is Option (3) → SLN

NCERT (2026-27 edition):
Summary – “… • The Excel functions SLN and DB are used for computation of depreciation using Straight Line Method (SLM) and Written Down Value Method (WDVM), respectively. WDV Method is also termed as declining balance (DB) method.”