Hi
I really need help with this assignment. I submitted the assignment already, and I got feedbacks to solve the mistakes in my first submissions.
I will attach the submissions ( The excel file ). Also, the feedbacks that include the mistakes in the excel submission. Please, I only need to fix the mistakes so I can submit the second submission. thankyou for your time I really appreciate it!
The two pictures I attached of the excel page is what I attached for my first submissions. The rest pictures shows what the mistakes are. Please I only need to solve the mistakes so I can submit it today and my professor take the higher grade. PLEASE HELP!
Four J's Painting is a home painting contractor that completes interior painting work for new construction projects. Four J's Painting has four employees UimJill, Jake, and Jennifer). You have been hired to determining how to make the company more efficient and provide better service. You have tracked information on the last 20 painting projects on Table 1. Employees receive bonuses for efficient and high quality work. Occasionally some jobs require touchup work. Information about the projects that required touchup work is stored on Table 2. Table 3 summarizes information about your employees Table 4 categorizes projects according to difficulty. Complete Tables 1 through 4 to determine how to more efficiently and effectively run the company. Complete each task so that the formulas you use can be copied and pasted down to complete the columns of the tables. Do not name your lookup tables, rather keep them as referencesler, 816:30). Employee Hourly Ware Employee Wage Information Jim Jill 552 550 Jake $47 Jennifer 5 48 Bonus information Time 10% Outcome = = = = = = H ] = = # 5 9 Table 1. Painting Projects Table 4. Project Suryby Diculty $2.28 COLES 2,114 g gg g 8 8 8 35115 $$ $$6 001 Es 32746 PI's Too Much Time 24 Use the SUMIF function to complete the "Cost Touchups" column on Table 4. Reference an appropriate field on Table 2 as your range and the "Difficulty" rating on Table 4 as your criteria. FEEDBACK 2.5/7.5 (33.3%) Feedback: [-1.25] The formula in cell K46 is incorrect [-2.5] The formula in cell K46 does not reference the correct cells [-1.25) The formula in cell K46 was not reused to complete column K of table 4 25 Use the AVERAGEIF function to complete the "Average Hours/Job' column on Table 4. Reference an appropriate field on Table 1 as your range and the "Difficulty" rating on Table 4 as your criteria. FEEDBACK 0/7.5 (0.0%) Feedback: [-1.25] The formula in cell N46 is incorrect |-2.5The formula in cell N46 does not reference the correct cells [-2.5] The value in cell K46 is incorrect [-1.25) The formula in cell K46 was not reused to complete column K of table 4 Four J's Painting is a home painting contractor that completes interior painting work for new construction projects. Four J's Painting has four employees UimJill, Jake, and Jennifer). You have been hired to determining how to make the company more efficient and provide better service. You have tracked information on the last 20 painting projects on Table 1. Employees receive bonuses for efficient and high quality work. Occasionally some jobs require touchup work. Information about the projects that required touchup work is stored on Table 2. Table 3 summarizes information about your employees Table 4 categorizes projects according to difficulty. Complete Tables 1 through 4 to determine how to more efficiently and effectively run the company. Complete each task so that the formulas you use can be copied and pasted down to complete the columns of the tables. Do not name your lookup tables, rather keep them as referencesler, 816:30). Employee Hourly Ware Employee Wage Information Jim Jill 552 550 Jake $47 Jennifer 5 48 Bonus information Time 10% Outcome = = = = = = H ] = = # 5 9 Table 1. Painting Projects Table 4. Project Suryby Diculty $2.28 COLES 2,114 g gg g 8 8 8 35115 $$ $$6 001 Es 32746 PI's Too Much Time 24 Use the SUMIF function to complete the "Cost Touchups" column on Table 4. Reference an appropriate field on Table 2 as your range and the "Difficulty" rating on Table 4 as your criteria. FEEDBACK 2.5/7.5 (33.3%) Feedback: [-1.25] The formula in cell K46 is incorrect [-2.5] The formula in cell K46 does not reference the correct cells [-1.25) The formula in cell K46 was not reused to complete column K of table 4 25 Use the AVERAGEIF function to complete the "Average Hours/Job' column on Table 4. Reference an appropriate field on Table 1 as your range and the "Difficulty" rating on Table 4 as your criteria. FEEDBACK 0/7.5 (0.0%) Feedback: [-1.25] The formula in cell N46 is incorrect |-2.5The formula in cell N46 does not reference the correct cells [-2.5] The value in cell K46 is incorrect [-1.25) The formula in cell K46 was not reused to complete column K of table 4