Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

On the att On the att On the att On the att 2 Share Function h sip 2.3. Use the

ID: 3605233 • Letter: O

Question

On the att On the att On the att On the att 2 Share Function h sip 2.3. Use the IF On the Attendance worksheet, in cell L5 enter an IF function to determine if the R. Tpercentage 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 tfrom cell L5 to the range L6 L11 10 of 50 Time Remaining 47.03 Attempts Remaining: 6 View All CReset Submit 2:56 PM

Explanation / Answer

Ans 1. If functiom should be written as:-

=IF(K5>H18,"Goal Met","Review")

And percent for attendence can be found by using general formula=(total-attended) / total .

----------------------------------------------------------------------------------------------------------------------------------------------------

Ans. 2 PMT function:-

= - PMT(B4/12,B5*12,B6)

Where:

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote