USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -An amortization schedule summarizes loan information over the life of the loan. A column border is an unused column with a significantly reduced width. You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.
Detailed explanation-2: -An amortization table can show you how your payment breaks down to principal paid and interest paid, and will also keep track of how much principal you have left to pay. Amortization tables do not typically show additional charges you pay on your loan, other than interest.
Detailed explanation-3: -Amortization Schedule. Also called a Repayment Schedule or a Loan Reduction Schedule it shows the amount of payments for interest, the amount for principal, and the principal balance for each month over the entire life of the loan.
Detailed explanation-4: -Spreadsheet specialists usually format a worksheet before they enter any data. Spreadsheet specialists often assign names to a cell or range of cells so that they can select them quickly. An alternative to a one-input data table is a three-input data table.