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:
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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started