Question

On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references. Copy the formula to the range C10:C15

On the Attendance worksheet, in cell L5, enter an IF function to determine if the percentage in cell K5 is greater than or equal to the goal in cell H18. The function should return the text Goal Met if true and Review if false. Set the reference to cell H18 as an absolute reference. Copy the formula from cell L5 to the range L6:L11 .

Answer 1

Question 1

Step 1

Click on Cell C9

Step 2

Enter the following formula

=PMT($B$5/12,$B$6,-B9)

Step 3

Enter

Step 4

Now use the fill handle to copy the formula C10:C15

---

Quesiton 2

Step 1

Go to cell L5

Step 2

Enter the following formula

=IF(K5>=$H$18,"Goal Met","Review")

Step 3

Enter

Step 4

Use the fill handle to copy the result L6:L11