Four J's Painting 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 (Jim, Jill, 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-Painting Projects on the Painting worksheet. 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 . Touchup Projects. Table 3 - Employee Summary summarizes information about your employees. Table 4 - Project Summary by Difficulty 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 references (e.g., D3:H4). 2.1) Use the HLOOKUP function to complete the "Hourly (2.2) Use the AND function to complete the "Time Bonus?" Use the OR function to complete the "Outcome Bonus?" (2.1) Use the HLOOKUP function to complete the "Hourly (2.2) Use the AND function to complete the "Time Bonus?" (2.3) Use the OR function to complete the "Outcome Bonus?" (2.4) Use the IF function to complete the "Time Bonus $ " (2.5) Use the IF function to complete the "Outcome Bonus $ " 2.6 Use the IF function to complete the "Comments" 2.7) Complete the "Employee" column of Table 2 by using 2.8) Use the VLOOKUP function to complete the "Difficulty" (2.9) Use the COUNTIF function to complete the "# of Jobs" (2.10) Use the SUMIF function to complete the "Total Hours" 2.11) Use the SUMIF function to complete the "Total Pay" 2.12) Use the COUNTIF function to complete the "\# of (2.13) Use the SUMIF function to complete the "Cost (2.14) Use the AVERAGEIF function to complete the "Average Four J's Painting 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 (Jim, Jill, 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-Painting Projects on the Painting worksheet. 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 . Touchup Projects. Table 3 - Employee Summary summarizes information about your employees. Table 4 - Project Summary by Difficulty 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 references (e.g., D3:H4). 2.1) Use the HLOOKUP function to complete the "Hourly (2.2) Use the AND function to complete the "Time Bonus?" Use the OR function to complete the "Outcome Bonus?" (2.1) Use the HLOOKUP function to complete the "Hourly (2.2) Use the AND function to complete the "Time Bonus?" (2.3) Use the OR function to complete the "Outcome Bonus?" (2.4) Use the IF function to complete the "Time Bonus $ " (2.5) Use the IF function to complete the "Outcome Bonus $ " 2.6 Use the IF function to complete the "Comments" 2.7) Complete the "Employee" column of Table 2 by using 2.8) Use the VLOOKUP function to complete the "Difficulty" (2.9) Use the COUNTIF function to complete the "# of Jobs" (2.10) Use the SUMIF function to complete the "Total Hours" 2.11) Use the SUMIF function to complete the "Total Pay" 2.12) Use the COUNTIF function to complete the "\# of (2.13) Use the SUMIF function to complete the "Cost (2.14) Use the AVERAGEIF function to complete the "Average
