DATABASE FUNDAMENTALS
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.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
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: -PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.
Detailed explanation-3: -The PMT function calculates the payment for a loan based on constant payments and at a constant interest rate.
Detailed explanation-4: -The PMT function uses the following arguments: Rate (required argument) – The interest rate of the loan. Nper (required argument) – Total number of payments for the loan taken.
There is 1 question to complete.