C268 Spreadsheets Test Questions with Correct
Answers
IPMT
The formula that returns the interest payment for a given period for an investment based on
periodic, constant payments and a constant interest rate.
PMT
One of the financial function formulas which calculate the payment for a loan based on
constant payments and a constant interest rate.
=IF(AND(E17<=C17,H16>1),"Good Job",
#1
Use the IF function to complete the "Comments" column of table 1. Display "Good Job" if
both the "Hours Worked" are less than or equal to the "Estimated Hours" for a project and the
assessed "Quality" of that project is greater than 1. Display "Too Much Time" if the "Hours
Worked" on a project exceed the "Estimated Hours" for that project; otherwise, display "Poor
Quality."
IF(E17>C17,"Too Much Time","Poor Quality"))
#2
Use the IF function to complete the "Comments" column of table 1. Display "Good Job" if
both the "Hours Worked" are less than or equal to the "Estimated Hours" for a project and the
assessed "Quality" of that project is greater than 1. Display "Too Much Time" if the "Hours
Answers
IPMT
The formula that returns the interest payment for a given period for an investment based on
periodic, constant payments and a constant interest rate.
PMT
One of the financial function formulas which calculate the payment for a loan based on
constant payments and a constant interest rate.
=IF(AND(E17<=C17,H16>1),"Good Job",
#1
Use the IF function to complete the "Comments" column of table 1. Display "Good Job" if
both the "Hours Worked" are less than or equal to the "Estimated Hours" for a project and the
assessed "Quality" of that project is greater than 1. Display "Too Much Time" if the "Hours
Worked" on a project exceed the "Estimated Hours" for that project; otherwise, display "Poor
Quality."
IF(E17>C17,"Too Much Time","Poor Quality"))
#2
Use the IF function to complete the "Comments" column of table 1. Display "Good Job" if
both the "Hours Worked" are less than or equal to the "Estimated Hours" for a project and the
assessed "Quality" of that project is greater than 1. Display "Too Much Time" if the "Hours
