In Excel, which function is used to calculate the depreciation of an asset using the straight-line method? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to calculate the depreciation of an asset using the straight-line method?

A. SLN

B. DB

C. DDB

D. SYD

Answer: Option A

Solution (By JKSSB Mock Tests)

SLN returns straight-line depreciation. SYD is sum-of-years digits, DDB double-declining balance, DB fixed declining.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

Share Report

In MS PowerPoint, which option is used to add a video to a slide?

A. Insert > Media

B. Insert > Video

C. Insert > Movie

D. Insert > Object

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Video command is under the Insert tab, in the Media group. In older versions it may be 'Movie', but current is Video.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, the 'Sort & Filter' group is on which tab?

A. Formulas

B. View

C. Home

D. Data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Data tab has Sort & Filter.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the shortcut key to open the 'Spelling and Grammar' check in MS Word?

A. Shift + F7

B. F5

C. F7

D. F9

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F7 launches the Spelling and Grammar checker. F5 opens Find and Replace, F9 updates fields, Shift+F7 opens the Thesaurus.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs