FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

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: -Excel NPER function NPER is an Excel financial function that calculates the number of payment periods for a loan or investment based on equal periodic payments and a constant interest rate. The function is available in all versions Excel 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010 and Excel 2007.

Detailed explanation-2: -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-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.