2026\2027 A+ Grade
RATE
- correct answer calculates the interest rate earned for an investment given the number of payments
made as part of the investment, the payment amount, and the current value of the investment.
EFFECT
- correct answer calculates the annual percentage rate for an interest rate given the number of times
per year that interest is charged.
NPER
- correct answer calculates the number of payments that will be made to pay off a loan given the
interest rate, payment amount, and original loan amount.
PMT
- correct answer calculates the payment amount for a loan given the interest rate, number of payments
to be made to pay off the loan, and the original loan amount.
PV
- correct answer calculates the current value (accounting for compounding interest) of an investment
given the interest rate, number of payments to be made, and the amount of the payment.
FV
- correct answer calculates the future value of an investment given the interest rate, number of
payments to be made, and the amount of the payment.
"Fill" feature in Excel.
- correct answer The "Fill" feature allows you to automatically populate cells in a worksheet. The "Fill"
menu item is in the "Editing" group on the "Home" tab. The fill "Up," "Down," "Left," and "Right" options
allow you to automatically copy the contents of one cell to other contiguous cells