FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year. You can add only a maximum of five conditional formats to a range.

Detailed explanation-2: -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: -PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.

Detailed explanation-4: -The PMT function calculates the payment for a loan based on constant payments and at a constant interest rate.

There is 1 question to complete.
Previous
Next