FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS 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 is the path to the Financial button and the PMT function?

A	(FORMULAS tab \| Function Library group)
B	(HOME tab \| Formulas group)
C	(FORMULAS tab \| Defined Names group)
D	(DATA tab \| Function Library group)

Explanation:

Detailed explanation-1: -The PMT function syntax has the following arguments: Rate Required. The interest rate for the loan. Nper Required.

Detailed explanation-2: -What is the PMT Function? The PMT Function[1] is categorized under financial Excel functions. The function helps calculate the total payment (principal and interest) required to settle a loan or an investment with a fixed interest rate over a specific time period.

Detailed explanation-3: -Click the Home tab; Go to Font group; Then you will view the border button, as the figure 2 shows above.

There is 1 question to complete.