17. Switch to the EmployeeBenefits worksheet. Add a Total Row to the EmployeeBen

Question

17. Switch to the EmployeeBenefits worksheet. Add a Total Row to the EmployeeBenefits table. Using the total row, add the following calculations to the table: a. In cell I102, use the AVERAGE function to determine the average of the Current Salary column values. b. In cell L102, use the AVERAGE function to determine the average of the Age column values. c. In cell M102, use the AVERAGE function to determine the average of the Years Service column values. d. In cell Q102, remove any calculation associated with the Vision Plan Costs column. Change the text in cell A102 to read Average. How do I change he text in cell A102 to read Average?

Explanation / Answer

These are my assumptions

Row 1 contains the column headings

Having data in R2-R101

a.Avg current salary formula in cell I102 is =AVERAGE(I2:I101)

b.Avg.age of the column

first we need to calculate age using formula using =INT(YEARFRAC(D2,TODAY()))

This will calculate the age then we can calculate average age.

calculate the average using =AVERAGE(L2:L101)

C.Average years of service   =AVERAGE(M2:M101)

D.example to change the text in cell   =REPLACE("EMPID",A102,num_chars,"AVERAGE")

If you need the answers with excel sheet i need the data

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.