WGU C268 Spreadsheets
(Excel) QUESTIONS AND
VERIFIED CORRECT
ANSWERS GRADED A+
[LATEST] 100% GUARANTEED
PASS
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
"AutoFill" - CORRECT ANSWER-You can use "AutoFill" to have Excel insert values into a range of
cells by completing a pattern in previous cells.
Select "Fill" and "Series" from the "Home" tab. In the "Series" dialog window, change "Type" to
"AutoFill" and click "OK".
Calculate the payment amount for the loan in cell C15. Reference the cells containing the
appropriate loan information as the arguments for the function you use. Cells C20-C67 in the
"Payment" column are populated with the payment amount from cell C15. - CORRECT ANSWER-
=PMT(C13/12,C12,C11)
Calculate, in cell D20, the interest amount for period 1 by multiplying the balance in period 0
(cell F19) by the loan interest rate (cell C13) divided by 12. Dividing the interest rate by 12
results in the monthly interest rate. This formula is reusable. The interest for a given period is
always the monthly interest rate times the balance from the previous period.
f - CORRECT ANSWER-=F19*0.065/12
Copy the Interest amount calcualtion down to complete the "interest" column of the
amortization table. - CORRECT ANSWER-Paste down column .
Calculate, in cell E20, the principal amount for period 1. The principal amount is the difference
between the payment amount (cell C20) and the interest amount (cell D20) for period 1.
(Excel) QUESTIONS AND
VERIFIED CORRECT
ANSWERS GRADED A+
[LATEST] 100% GUARANTEED
PASS
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
"AutoFill" - CORRECT ANSWER-You can use "AutoFill" to have Excel insert values into a range of
cells by completing a pattern in previous cells.
Select "Fill" and "Series" from the "Home" tab. In the "Series" dialog window, change "Type" to
"AutoFill" and click "OK".
Calculate the payment amount for the loan in cell C15. Reference the cells containing the
appropriate loan information as the arguments for the function you use. Cells C20-C67 in the
"Payment" column are populated with the payment amount from cell C15. - CORRECT ANSWER-
=PMT(C13/12,C12,C11)
Calculate, in cell D20, the interest amount for period 1 by multiplying the balance in period 0
(cell F19) by the loan interest rate (cell C13) divided by 12. Dividing the interest rate by 12
results in the monthly interest rate. This formula is reusable. The interest for a given period is
always the monthly interest rate times the balance from the previous period.
f - CORRECT ANSWER-=F19*0.065/12
Copy the Interest amount calcualtion down to complete the "interest" column of the
amortization table. - CORRECT ANSWER-Paste down column .
Calculate, in cell E20, the principal amount for period 1. The principal amount is the difference
between the payment amount (cell C20) and the interest amount (cell D20) for period 1.
