C268 Spreadsheets Test Questions with Correct Answers

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