# FUNDAMENTALS OF COMPUTER

## DATABASE FUNDAMENTALS

### USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The FV function returns the future value of an investment based on periodic, constant payments and a constant interest rate.
 A true B false C Either A or B D None of the above
Explanation:

Detailed explanation-1: -FV, one of the financial functions, calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single lump sum payment. Use the Excel Formula Coach to find the future value of a series of payments.

Detailed explanation-2: -PV, one of the financial functions, calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that’s your investment goal.

Detailed explanation-3: -Future value in Excel In other words, FV measures how much a given amount of money will be worth at a specific time in the future. Normally, the FV calculation is based on an anticipated growth rate, or rate of return.

Detailed explanation-4: -PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate. Use the Excel Formula Coach to figure out a monthly loan payment. At the same time, you’ll learn how to use the PMT function in a formula.

Detailed explanation-5: -The EFFECT function returns the compounded interest rate based on the annual interest rate and the number of compounding periods per year.

There is 1 question to complete.