Spreadsheets - C268
Comprehensive Questions and
Solutions Graded A+
IPMT - Answer: 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 - Answer: 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", - Answer: #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")) - Answer: #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
Worked" on a project exceed the "Estimated Hours" for that project; otherwise, display "Poor
Quality."
Comprehensive Questions and
Solutions Graded A+
IPMT - Answer: 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 - Answer: 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", - Answer: #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")) - Answer: #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
Worked" on a project exceed the "Estimated Hours" for that project; otherwise, display "Poor
Quality."
