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. DB

B. SYD

C. SLN

D. DDB

Answer: Option C

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 Excel, which function is used to convert a text string that looks like a number into a number?

A. TEXT

B. CONVERT

C. VALUE

D. NUMBER

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The VALUE function converts a text string that represents a number into a numeric value. TEXT does the opposite.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut key to open the 'Page Setup' dialog in MS Excel?

A. Ctrl + Shift + P

B. F5

C. Ctrl + P

D. Alt + P, S, P

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Alt+P,S,P opens Page Setup in Excel. Ctrl+Shift+P is not standard. Ctrl+P is Print. F5 is Go To.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, which query type displays summarized data in a spreadsheet-like format with rows and columns?

A. Select query

B. Crosstab query

C. Action query

D. Parameter query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Crosstab query aggregates data and presents it in a grid with row and column headings.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs