This question "** Which function is used to calculate depreciation, rates of return, future values and loan payment amounts A) Logical B) Math & Trigonometry C) Statistical D) Financial**" is asked from Spreadsheet Calculation System topic and more specifically, it is from Excel Functions and Formula.

The question was asked in Computer Operator Examination conducted by Public Service Commission in various years. It aims to test candidate's general familiarity on various kind of functions in Excel.

**Show Your Love! Share this page!**

Question:

## Which function is used to calculate depreciation, rates of return, future values and loan payment amounts

Options:

A. Logical

B. Math & Trigonometry

C. Statistical

D. Financial

#### Correct Answer

Explanation:

### Which function is used to calculate depreciation, rates of return, future values and loan payment amounts

MS Excel is rich with its functions. Functions are what makes Excel so powerful in its calculation and usefulness.

There are various kind of functions available in Excel such as Math and Trigonometry functions, Logical functions, Statistical functions, financial functions and so on.

**Logical functions** are used to carry out more than one comparison in formula or test multiple conditions instead of just one. Logical functions return True or False after their arguments are evaluated. AND, OR, XOR and NOT are the logical functions. (Ref: Svetlana Cheusheva has written a nice page about these functions)

**Math & Trigonometry functions **are used to calculate arithmetic or trigonometric problems. SUM, PRODUCT, ABS, SQRT are some examples. You can find more extensive list of math and trigonometry functions (click here).

Edward presents a nice video on these functions. Recommended to watch!

**Statistical Functions** calculate these statistics: mean, variance, standard deviation and correlation and so on. You can download this PDF file for better reference - A Brief Review of Statistics and Microsoft Excel Statistical Functions.

**Financial Functions** are used to perform many of the common financial calculations, such as the calculation of yield, interest rates, duration, valuation and asset depreciation. Some of the financial functions are Investment Value Functions - FV, NPV, PV, Payment Functions - PMT, Interest Rate Functions - RATE, Internal Rate of Return Functions - IRR. Here you can download Nadeeshani Aththanagoda's presentation for more information about financial functions in Excel. (view online in original source)

With above discussion, it is obvious that ** Financial Functions** are used to

*used to calculate depreciation, rates of return, future values and loan payment amounts. Thus option D is correct answer.*

[…] command will be used to display all the files having .ext extension but different filename? Which function is used to calculate depreciation, rates of return, future values and loan payment am… When integrating word and excel, word is usually the …… Which of the following […]