Question: Use the IF function to complete the Comments column of Table 1 . Display Good Job if both the Hours Worked are less than or

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. Note: you can combine "less than" and "equal to" operators -"<="- to check for "less than or equal to"
Display "Too Much Time" if the "Hours Worked" on a project exceed the "Estimated Hours" for that project.
Otherwise, display "Poor Quality".
Reuse your formula to complete the column.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!