Target Exam

CUET

Subject

-- Accountancy Part C

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 correct answer is option 1- Calculating Depreciation.

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.