BYU Student Author: @Marco
Reviewers: @Spencer, @Christian, @Erick_Sizilio
Estimated Time to Solve: 15 Minutes
We provide the solution to this challenge using:
Need a program? Click here.
Overview
You’ve been working at a big tech company called Pear Inc. for a couple of years as an accountant. You enjoy working there and helping your co-workers. After lunch, you notice that your new co-worker in the HR department, Jane, is having some trouble. You ask her if there’s anything you can help her with. She responds by asking if you can help her analyze some employee data on excel. You happily accept and begin conducting your analysis.
Instructions
- She tells you there are duplicates and would like to delete them.
- Make a new sheet and call it “Info Needed”, this is where you’ll put all info from the next instructions.
- Separate employee names to only show first names and name the column “First Name”.
- Calculate the age of every employee and name the column “Age”.
- Make a column named “Birth Month” and show the birth month of every employee (ex: December, August).
- Calculate the # of years the employee has been employed at the company (no decimals) and name the column “Years Employed”.
- Bonuses are being given out to the employees who have worked 10 or more years.
- Highlight the cells that are 10 or more years in the “Years Employed” column.
- Make a new column named “# of Bonuses” with the number of employees that have worked 10 or more years.
- Jane would like to start preparing birthday cards for people who have birthdays in December, make a column named “# of December Birthdays” and calculate the number of birthdays in December.
- Make a column named “Average Age” and calculate the average age of employees.
Data Files
Solution
Challenge91_Solution.xlsx
Solution Video: Challenge 91|EXCEL – Lending a Helping Hand