https://docs.google.com/spreadsheets/d/1s-SZ_hfdOABx3sGvGNiYcrw-UB2…

/in /by

Question Answered step-by-step https://docs.google.com/spreadsheets/d/1s-SZ_hfdOABx3sGvGNiYcrw-UB2… https://docs.google.com/spreadsheets/d/1s-SZ_hfdOABx3sGvGNiYcrw-UB2QKbbU/edit?usp=sharing&ouid=102838264550843771364&rtpof=true&sd=true 1. Open the workbook RSROctLabor2. Modify the range named LaborCost to include cell F22.3. Change the range name for the range named Hr to Hours.4. In cell E7, create a VLOOKUP formula to return the correct hourly rate based on the technician code in cell D7. Use the range name RateChart within the formula to reference the hourly rate chart. Make sure Excel will return values for exact matches only. 6. Create or copy the following formulas:a. Copy the VLOOKUP formula in cell E7 to the range E8:E22.b. In cell F7, multiply the number of hours logged in cell C7 by the hourly rate in cell E7. Add the ROUND function to ensure that all labor costs are rounded to the nearest cent (two digits after the decimal point).c. Copy the formula in cell F7 to the range F8:F22.d. Create the formula in cell F23 to sum the values in the column7. Using the range named TechCode, create COUNTIF formulas in these cells:                 I9: Count the number of calls made by technician 1. I10: Count the number of calls made by the technician 2. I11: Count the number of calls made by the technician 3.8. In cell I14, create a COUNTIFS formula to count the number of calls made by technician 3 for which the hours logged were greater than three. Use range names (TechCode and Hours) where possible.9. Using the ranges named TechCode and LaborCost, create SUMIF formulas in these cells: J9: Add the labor cost for calls made by technician 1. J10: Add the labor cost for calls made by technician 2. J11: Add the labor cost for calls made by technician 3.10. Using the ranges named TechCode, LaborCost, and Hours, create a SUMIFS formula in cell J14 to add the labor cost for calls made by technician 3 (criteria 1) in which the hours logged were greater than three (criteria 2). 6. Using the named ranges TechCode and LaborCost, create AVERAGEIF formulas in these cells: J18: Average the labor cost for calls made by technician 1.                J19: Average the labor cost for calls made by technician 2. J20: Average the labor cost for calls made by technician 3.7. Ensure that the Comma format has been applied to these cells or ranges:    J9:J11 J14 J18:J20 Accounting Business Financial Accounting EXCEL 365 Share QuestionEmailCopy link Comments (0)