FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following doesn’t belong to the NPER function syntax?

A	Rate
B	Pmt
C	Pv
D	Value ____ if ____ true

Explanation:

Detailed explanation-1: -NPER is used to calculate the number of periods required to repay a loan. The syntax for NPER is “=NPER(rate, pmt, pv, fv, type)". In order to use NPER in Google Sheets, you will need to enter the following formula: “=NPER(rate, pmt, pv, fv, type)".

Detailed explanation-2: -What is the NPER Function? The NPER Function[1] is categorized under Excel Financial functions. The function helps calculate the number of periods that are required to pay off a loan or reach an investment goal through regular periodic payments and at a fixed interest rate.

Detailed explanation-3: -The [type] argument can have the value 0 or 1, meaning: 0-the payment is made at the end of the period; 1-the payment is made at the beginning of the period. If the [type] argument is omitted, it takes on the default value of 0 (denoting payments made at the end of the period).

There is 1 question to complete.