Practicing Success

Target Exam

CUET

Subject

Accountancy

Chapter

Use of Spreadsheet in Business Applications

Question:
The Excel functions SLN and DB are used for which of the following purposes?
Options:
Calculating Depreciation
Payroll Function
Loan Payment Schedule
Fixed Asset Accounting
Correct Answer:
Calculating Depreciation
Explanation:
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.