Unit E Quiz
Select the best answer for the question. Remember you can look in your book or, if all else fails, open Microsoft Word and look and see.
To generate a postive payment value when using the PMT function, you must (pg. 14)
- Enter the function arguments as positive values.
- Enter the function arguments as negative values.
- Enter the amount being borrowed as a negative value.
- Enter the interest rate divisor as a negative value.
When you enter the rate and nper arguments ina PMT function, (pg. 14)
- Multiply both units by 12.
- Be consistent in the units used.
- Divide both values by 12.
- Use monthly units instead of annual units.
To express conditions such as less than or equal to, you can use a(n) (pg. 11)
- IF Function.
- Comparison operator.
- AutoCalculate formula.
- PMT function.
Which of the follwoing satements is false? (pg 9)
- $#,### is an Excel number format.
- You can create custom number and date formats in Excel.
- You can use only existing number and date formats in Excel.
- m/d/yy is an Excel date format.