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

In Excel, which function is used to calculate the depreciation of an asset using the straight-line method?
A. DB
B. SYD
C. SLN
D. DDB
Answer: Option C
Solution (By JKExamLibrary)
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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
In Excel, which function is used to calculate the slope of a linear regression line?
A. INTERCEPT
B. All of the above
C. SLOPE
D. LINEST

Correct Answer: Option B


Explanation:
SLOPE, INTERCEPT, and LINEST can all be used for linear regression analysis (LINEST returns array).

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS PowerPoint, which view is used to print handouts with multiple slides per page?
A. Slide Sorter View
B. Normal View
C. Print Preview
D. Handout Master

Correct Answer: Option D


Explanation:
Handout Master is used to edit the layout for printed handouts. However, to print handouts, you go to File > Print and choose handouts layout. But the question asks which view, so Handout Master is the correct answer.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS Word, what does the 'Gutter Margin' refer to?
A. Margin space added to the binding side of a document to prevent text coverage during binding
B. The footer section containing page counts and file metrics
C. The empty gap between two lines of text inside a paragraph
D. Margin space reserved on the right to accommodate comments

Correct Answer: Option A


Explanation:
A gutter margin adds extra buffer space to the side or top margin of a document intended for bookbinding, ensuring text remains fully legible.

This question belongs to: Computer Microsoft Office