Home / Computer Fundamentals / MS Excel :: Discussion

Discussion :: MS Excel

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

  2. A.

     Logical

    B.

     Math & Trigonometry

    C.

     Statistical

    D.

     Financial

    View Answer

    Workspace

    Answer : Option D

    Explanation :

    Financial Functions are used to calculate depreciation, rates of return, future values and loan payment amounts.
    A list of Excel Financial Functions in Excel are:
    ⇒Investment value functions including
    1. FV
    2. FVSCHEDULE
    3. NPV
    4. PV
    5. RECEIVED
    6. XNPV
    ⇒Internal rate of return functions including
    1. IRR
    2. MIRR
    3. XIRR
    ⇒Asset depreciation functions including
    1. AMORDEGRC
    2. AMORLINC
    3. DB
    4. DDB
    5. SLN
    6. SYD
    7. VDB
    ⇒Payment functions including
    1. CUMIPMT
    2. CUMPRINC
    3. IPMT
    4. ISPMT
    5. PMT
    6. PPMT
    ⇒Dollar conversion including
    1. DOLLARDE
    2. DOLLARFR
    ⇒Yield functions including
    1. YIELD
    2. YIELDDISC
    3. YIELDMAT
    4. ODDFYIELD
    5. ODDLYIELD
    6. TBILLEO
    7. TBILLYIELD
    ⇒Price functions including
    1. PRICE
    2. PRICEDISC
    3. PRICEMAT
    4. ODDFPRICE
    5. ODDLPRICE
    6. TBILLPRICE


Be The First To Comment